OCR ICT AS Level - Spreadsheet Concepts (Chapter 4)

Question 1 of 20

4

What are four advantages of using a spreadsheet to answer 'what-if?' questions?

Select one or more of the following:

It is quicker and easier than using a physical model, saving time and money.
It is less risky, as lots of questions can be asked within the spreadsheet model to test many scenarios, before they are tested in real life.
Only one model needs to be built, which can then be changed. If a physical model is built, then a different one will be needed each time a change is made.
No-additional software is required: spreadsheets are standard business software. Most people are able or have the knowledge on how to use a spreadsheet, so there is no need for additional specialist training.
Using lots of 'what-if?' questions could slow down the spreadsheet's performance, making if more difficult to carry out other tasks.
You can use these questions to test out physical models as well as spreadsheet models.
You can choose from a drop down menu of personalised 'what-if?' questions within the spreadsheet model, so you don't have to type out the whole question yourself, which therefore saves you time and money.

Explanation

Question 2 of 20

1

Absolute cell referencing is when a cell referenced in a formula changes when it is copied to other cells.

Select one of the following:

True
False

Explanation

Question 3 of 20

2

What are two advantages of using ranges in a spreadsheet model?

Select one or more of the following:

There is less chance of an error if you use ranges, rather than highlighting individual cells
The ranges can be named so are easier to remember when writing a formula.
Using ranges is safer, because clicking on lots of individual cells could slow down your computer's performance and make you become tired.
Lots of ranges can be given the same identical name, so you can have lots of choice when it comes to choosing a range to include in a formula.

Explanation

Question 4 of 20

2

What are two advantages of storing data across multiple worksheets in the same workbook?

Select one or more of the following:

You can give access rights to certain worksheets, so only certain people could look at certain worksheets.
The different worksheets can be saved individually as a separate file, so you don't have to look at data within other worksheets if you don't need to.
The data can be organised into separate worksheets, but could still be used in formulas across the whole workbook.
Data that is not used often can be deleted entirely and never seen again, aiding with the organisation process.

Explanation

Question 5 of 20

1

Relative cell referencing is when a cell referenced in a formula changes when the formula is copied to other cells.

Select one of the following:

True
False

Explanation

Question 6 of 20

1

What could absolute cell referencing be used for in a financial spreadsheet model?

Select one of the following:

Changing price values of products
VAT Rate
Total sales

Explanation

Question 7 of 20

2

What are two advantages of using modelling software to create a model of the expansion of a building?

Select one or more of the following:

You can look at various layers and angles of the building, giving you a clear idea of what the building would look like in real life.
Allows 'what if?' questions to be used, so different scenarios can be tried to find the best one.
Software add-ons are free of charge so you can every possible feature within the modelling software to create the building model.
Variables can be used and can be changed to try different scenarios without rebuilding the model.
You can view the model of the building on many different electronic devices, allowing for easy editing on-the-go.

Explanation

Question 8 of 20

1

A variable is the name of a cell/the cell reference.

Select one of the following:

True
False

Explanation

Question 9 of 20

1

A function uses made up words to work/carry out a particular task.

Select one of the following:

True
False

Explanation

Question 10 of 20

4

What are four elements that could be tailored in a spreadsheet?

Select one or more of the following:

A menu bar, with a drop down menu which can have options added or removed.
Cells, which can be made secure with different access rights.
Icons, which can be added/removed/edited.
Buttons, to press/toggle and carry out commands.
Error messages, specific to the spreadsheet being used can be created to tell the user that they have done something wrong.
Screen resolution, which can be set to high so that the user can view the spreadsheet at a high quality with no obvious pixels.
Sound, which can be turned on and off when they user is carrying out a certain task.

Explanation

Question 11 of 20

2

What are two advantages of tailoring a spreadsheet?

Select one or more of the following:

You could make more money because the final product will look more professional so more people would want to use it.
The spreadsheet can be made more secure by the use of different access rights between worksheets.
The model can be personalised and made easy to used based on the company/person using it (e.g. use colours from the company's logo).
Novice users can use the new system, meaning that minimal training is required, saving costs

Explanation

Question 12 of 20

1

Spreadsheets would come under 'mathematical modelling'.

Select one of the following:

True
False

Explanation

Question 13 of 20

4

What are the four main characteristics used in modelling software?

Select one or more of the following:

Variables
Cells
Rules
Functions
IF Statements
Formulae
Ranges

Explanation

Question 14 of 20

1

Rules are a set of procedures that must be followed.

Select one of the following:

True
False

Explanation

Question 15 of 20

1

Which is larger: A worksheet or a workbook?

Select one of the following:

Worksheet
Workbook

Explanation

Question 16 of 20

1

Some cells in a spreadsheet may have the same name.

Select one of the following:

True
False

Explanation

Question 17 of 20

2

Which two of the following are examples ranges that could be found in a spreadsheet?

Select one or more of the following:

=C1*G8
=SUM(C1+G8)
C1:G8
Employee_Salaries

Explanation

Question 18 of 20

1

Which is used to represent a complex formula that uses reserved words?

Select one of the following:

Formulae
Function

Explanation

Question 19 of 20

3

What are three disadvantages of using models to represent physical events?

Select one or more of the following:

Developing a complex model can take a lot of time to produce.
The equipment and software are expensive to purchase.
You have to be an expert and know lots of technical terms to be able to produce a successful model.
Simulations can't completely re-create real life situations.
You have to know all of the formulas and functions off by heart when creating the model.

	Created by Lucy Hayfield over 9 years ago

Quiz foe Spreadsheet concepts (chapter 4) of OCR ICT AS Level

OCR ICT AS Level - Spreadsheet Concepts (Chapter 4)

Question 1 of 20

What are four advantages of using a spreadsheet to answer 'what-if?' questions?

Select one or more of the following:

Explanation

Question 2 of 20

Absolute cell referencing is when a cell referenced in a formula changes when it is copied to other cells.

Select one of the following:

Explanation

Question 3 of 20

What are two advantages of using ranges in a spreadsheet model?

Select one or more of the following:

Explanation

Question 4 of 20

What are two advantages of storing data across multiple worksheets in the same workbook?

Select one or more of the following:

Explanation

Question 5 of 20

Relative cell referencing is when a cell referenced in a formula changes when the formula is copied to other cells.

Select one of the following:

Explanation

Question 6 of 20

What could absolute cell referencing be used for in a financial spreadsheet model?

Select one of the following:

Explanation

Question 7 of 20

What are two advantages of using modelling software to create a model of the expansion of a building?

Select one or more of the following:

Explanation

Question 8 of 20

A variable is the name of a cell/the cell reference.

Select one of the following:

Explanation

Question 9 of 20

A function uses made up words to work/carry out a particular task.

Select one of the following:

Explanation

Question 10 of 20

What are four elements that could be tailored in a spreadsheet?

Select one or more of the following:

Explanation

Question 11 of 20

What are two advantages of tailoring a spreadsheet?

Select one or more of the following:

Explanation

Question 12 of 20

Spreadsheets would come under 'mathematical modelling'.

Select one of the following:

Explanation

Question 13 of 20

What are the four main characteristics used in modelling software?

Select one or more of the following:

Explanation

Question 14 of 20

Rules are a set of procedures that must be followed.

Select one of the following:

Explanation

Question 15 of 20

Which is larger: A worksheet or a workbook?

Select one of the following:

Explanation

Question 16 of 20

Some cells in a spreadsheet may have the same name.

Select one of the following:

Explanation

Question 17 of 20

Which two of the following are examples ranges that could be found in a spreadsheet?

Select one or more of the following:

Explanation

Question 18 of 20

Which is used to represent a complex formula that uses reserved words?

Select one of the following:

Explanation

Question 19 of 20

What are three disadvantages of using models to represent physical events?

Select one or more of the following:

Explanation

Question 20 of 20

Constants are values used in formulae which can be changed by the user.