KS3 ICT Quiz
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.

Did you know...

You can play all the teacher-written quizzes on our site for just £9.95 per month. Click the button to sign up or read more.

1. 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
2. Which of the following statements is not true?
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 .......
Values can be entered manually or automatically from other cells
4. A formula is not normally displayed in a cell. It is found .......
This is found just above the work space
5. Functions are pre-programmed formulae which .......
They save the user time and unnecessary effort
6. Which of these is not a commonly used function?
A huge number of helpful functions are available
7. Which is not an advantage of using models?
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?
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 .......
That applies to any computer model
10. Spreadsheets are good at answering what-if questions. Which of the following statements is true?
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

Quiz yourself clever - 3 free quizzes in every section

• Reinforce your school learning in the comfort of home
• Build your confidence in National Curriculum subjects
• Test yourself to identify gaps in learning
• Revise fast for tests and exams

TJS - Web Design Lincolnshire