Magic for Learning and Revision

Join Us
Models 03
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.

What name is given to the text at the top of a column?
This can help others to understand the data that you are using in your model
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
A cell contains a number. This is called a .......
Values can be entered manually or automatically from other cells
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
This is found just above the work space
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
Which of these is not a commonly used function?
A huge number of helpful functions are available
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
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
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
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
You can find more about this topic by visiting BBC Bitesize - Spreadsheets

Author:  Duncan Daish

© Copyright 2016-2024 - Education Quizzes
Work Innovate Ltd - Design | Development | Marketing

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