KS3 - Ks3 Ict - Models 03 Solution - MCQGeeks.com

Q.1.

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

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

Q.2.

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

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

Q.3.

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

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

Q.4.

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.5.

Which of these is not a commonly used function?

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

Q.6.

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.7.

Why are computer models sometimes unreliable?

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

Q.8.

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

0%
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.9.

Spreadsheets are good at answering what-if questions. Which of the following statements is true?

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
0%
None of the above will work