UK USIndia

Every Question Helps You Learn

Take this quiz and improve your knowledge of ICT.

Models 03

Take a look at our third and final KS3 ICT quiz on models. Many businesses use spreadsheets to record their income, expenses and profits. Spreadsheets can also be used to help them carry out what if investigations. A florist could see what effect an increase in prices of certain items would have on their profit or a bike repair shop could see how increasing the hourly rate would affect the daily takings. The spreadsheet can also be used to display the information as a graph or other chart which could be used when showing a bank manager how a loan might benefit their company.

Spreadsheets can be formatted in many ways. This can make them easier to use. Columns and rows can have a label entered in the first cell to describe what information it contains. The width of a column can be altered, so can the height of the columns. Cells can be given a coloured background, a border and even merged together to form a large block. Text can be justified left, right or centre, underlined, emboldened and different fonts can be used.

1.
What name is given to the text at the top of a column?
Function
Label
Sum
Value
This can help others to understand the data that you are using in your model
2.
Which of the following statements is not true?
You can use different fonts in different cells.
Calculations in a spreadsheet model are carried out manually.
The width of a column can be altered.
A formula takes some or all of its data from other cells.
A big advantage of a spreadsheet model is that if you change some of the data, any calculations based on it will automatically update
3.
A cell contains a number. This is called a .......
input
numeric
output
value
Values can be entered manually or automatically from other cells
4.
A formula is not normally displayed in a cell. It is found .......
in the formula bar
in the formulae bar
in the rule bar
This is found just above the work space
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 reliable, it depends on how carefully they are set up and how many variables they consider
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. A good example of this is weather forecasting which is not always reliable, but that is far too complicated for a spreadsheet model - weather models require some of the world's largest 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
That applies to any computer model
10.
Spreadsheets are good at answering what-if questions. Which of the following statements is true?
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
This is a strength of a spreadsheet model - you don't necessarily need a lot of complicated, powerful and expensive computers to set up a what-if question