Models 3
Take this quiz and improve your knowledge of computer science.

Models 3

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
They save the user time and unnecessary effort
6.
Which of these is not a commonly used function?
MAX
MIN
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
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?
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
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
Author:  Duncan Daish

© Copyright 2016-2019 - Education Quizzes
TJS - Web Design Lincolnshire
View Printout in HTML

Valid HTML5

We use cookies to make your experience of our website better.

To comply with the new e-Privacy directive, we need to ask for your consent - I agree - No thanks - Find out more