KS3 ICT | Models - Income, expenses and profits with spreadsheets

Back to ICT

ICT Quiz - Models 03 (Questions)

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?

[ ]	Function
[ ]	Label
[ ]	Sum
[ ]	Value

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 cell contains a number. This is called a .......

[ ]	input
[ ]	numeric
[ ]	output
[ ]	value

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

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

Which of these is not a commonly used function?

[ ]	MAX
[ ]	MIN
[ ]	MINGIN
[ ]	MOD

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

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

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

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

You can find more about this topic by visiting BBC Bitesize - Spreadsheets

ICT Quiz - Models 03 (Answers)

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

[ ]	Function
[x]	Label
[ ]	Sum
[ ]	Value

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.
[x]	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 .......

[ ]	input
[ ]	numeric
[ ]	output
[x]	value

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
[x]	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
[x]	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?

[ ]	MAX
[ ]	MIN
[x]	MINGIN
[ ]	MOD

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
[x]	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?

[x]	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
[x]	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?

[x]	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