Elementary School: 3rd, 4th & 5th Grade - Computer Science - Models 3 Solution - MCQGeeks.com

Q.1.

What name is given to the text at the top of a column?

0%
Function
0%
Label
100%
Sum
0%
Value

Q.2.

A cell contains the characters Total. This is called a .......

0%
datum
0%
label
0%
output
0%
result

Q.3.

A cell contains a number or date. This is called a .......

0%
input
0%
numeric
0%
output
0%
value

Q.4.

A formula is not normally displayed in a cell. It is found .......

0%
in the address bar
0%
in the formula bar
0%
in the formulae bar
0%
in the rule bar

Q.5.

Functions are pre-programmed formulae which .......

0%
have to be learned by heart
0%
perform tasks a user could not create a formula to do
0%
save the user having to type in regularly used formulae
0%
work better than formulae created by a user

Q.6.

Which of these is not a commonly used function?

0%
MAX
0%
MIN
0%
MINGIN
0%
MOD

Q.7.

Which is not an advantage of using models?

0%
Is cheaper than doing the real thing, e.g. car crashes
0%
Models usually give only approximate answers
0%
They can be used for making predictions
0%
Training people to do dangerous jobs without any risk

Q.8.

Why are computer models sometimes unreliable?

0%
Real life often has unpredictable events occur
100%
The models might be processing too much information
0%
The rules were probably entered incorrectly
0%
They have been run on old computers

Q.9.

A spreadsheet model might be tested by .......

100%
changing the input data and looking at the predictions
0%
changing the rules used and looking at the predictions
0%
comparing the model predictions with real life results
0%
It is a computer model and doesn't need testing

Q.10.

Spreadsheets are good at answering what-if questions.

0%
You can change input values and check the results
0%
You can change the rules and check the results
0%
You can change the rules and data and check the results
100%
None of the above will work