Computer Science: Middle School: Grades 6, 7 and 8 Quiz - Models 3 (Questions)

This Computer Science quiz is called 'Models 3' and it has been written by teachers to help you if you are studying the subject at middle school. Playing educational quizzes is a fabulous way to learn if you are in the 6th, 7th or 8th grade - aged 11 to 14.

It costs only $12.50 per month to play this quiz and over 3,500 others that help you with your school work. You can subscribe on the page at Join Us

Starting in the mid 1990s continuing through the present, Microsoft Excel has dominated the commercial electronic spreadsheet market.

See if you can excel in our third quiz on Models!

1. What name is given to the text at the top of a column?
[ ] Function
[ ] Label
[ ] Sum
[ ] Value
2. A cell contains the characters Total. This is called a .......
[ ] datum
[ ] label
[ ] output
[ ] result
3. A cell contains a number or date. This is called a .......
[ ] input
[ ] numeric
[ ] output
[ ] value
4. A formula is not normally displayed in a cell. It is found .......
[ ] in the address bar
[ ] in the formula bar
[ ] in the formulae bar
[ ] in the rule bar
5. Functions are pre-programmed formulae which .......
[ ] have to be learned by heart
[ ] perform tasks a user could not create a formula to do
[ ] save the user having to type in regularly used formulae
[ ] work better than formulae created by a user
6. Which of these is not a commonly used function?
[ ] MAX
[ ] MIN
[ ] MINGIN
[ ] MOD
7. Which is not an advantage of using models?
[ ] Is cheaper than doing the real thing, e.g. car crashes
[ ] Models usually give only approximate answers
[ ] They can be used for making predictions
[ ] Training people to do dangerous jobs without any risk
8. Why are computer models sometimes unreliable?
[ ] Real life often has unpredictable events occur
[ ] The models might be processing too much information
[ ] The rules were probably entered incorrectly
[ ] They have been run on old computers
9. A spreadsheet model might be tested by .......
[ ] changing the input data and looking at the predictions
[ ] changing the rules used and looking at the predictions
[ ] comparing the model predictions with real life results
[ ] It is a computer model and doesn't need testing
10. Spreadsheets are good at answering what-if questions.
[ ] You can change input values and check the results
[ ] You can change the rules and check the results
[ ] You can change the rules and data and check the results
[ ] None of the above will work
Computer Science: Middle School: Grades 6, 7 and 8 Quiz - Models 3 (Answers)
1. What name is given to the text at the top of a column?
[ ] Function
[x] Label
[ ] Sum
[ ] Value
2. A cell contains the characters Total. This is called a .......
[ ] datum
[x] label
[ ] output
[ ] result
3. A cell contains a number or date. This is called a .......
[ ] input
[ ] numeric
[ ] output
[x] value
4. A formula is not normally displayed in a cell. It is found .......
[ ] in the address bar
[x] in the formula bar
[ ] in the formulae bar
[ ] in the rule bar
5. Functions are pre-programmed formulae which .......
[ ] have to be learned by heart
[ ] perform tasks a user could not create a formula to do
[x] save the user having to type in regularly used formulae
[ ] work better than formulae created by a user
They save the user time and unnecessary effort
6. Which of these is not a commonly used function?
[ ] MAX
[ ] MIN
[x] MINGIN
[ ] MOD
A huge number of helpful functions are available
7. Which is not an advantage of using models?
[ ] Is cheaper than doing the real thing, e.g. car crashes
[x] Models usually give only approximate answers
[ ] They can be used for making predictions
[ ] Training people to do dangerous jobs without any risk
Computer models are not always very reliable
8. Why are computer models sometimes unreliable?
[x] Real life often has unpredictable events occur
[ ] The models might be processing too much information
[ ] The rules were probably entered incorrectly
[ ] They have been run on old computers
Unpredictable events may not be covered by the rules
9. A spreadsheet model might be tested by .......
[ ] changing the input data and looking at the predictions
[ ] changing the rules used and looking at the predictions
[x] comparing the model predictions with real life results
[ ] It is a computer model and doesn't need testing
10. Spreadsheets are good at answering what-if questions.
[x] You can change input values and check the results
[ ] You can change the rules and check the results
[ ] You can change the rules and data and check the results
[ ] None of the above will work