OCR ICT AS Level - Spreadsheet Concepts (Chapter 4)

Question

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

Answer 1

It is quicker and easier than using a physical model, saving time and money.

Answer 2

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.

Answer 3

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.

Answer 4

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.

Answer 5

Using lots of 'what-if?' questions could slow down the spreadsheet's performance, making if more difficult to carry out other tasks.

Answer 6

You can use these questions to test out physical models as well as spreadsheet models.

Answer 7

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.

Answer 8

There is less chance of an error if you use ranges, rather than highlighting individual cells

Answer 9

The ranges can be named so are easier to remember when writing a formula.

Answer 10

Using ranges is safer, because clicking on lots of individual cells could slow down your computer's performance and make you become tired.

Answer 11

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.

Answer 12

You can give access rights to certain worksheets, so only certain people could look at certain worksheets.

Answer 13

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.

Answer 14

The data can be organised into separate worksheets, but could still be used in formulas across the whole workbook.

Answer 15

Data that is not used often can be deleted entirely and never seen again, aiding with the organisation process.

Answer 16

Changing price values of products

Answer 17

Total sales

Answer 18

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.

Answer 19

Allows 'what if?' questions to be used, so different scenarios can be tried to find the best one.

Answer 20

Software add-ons are free of charge so you can every possible feature within the modelling software to create the building model.

Answer 21

Variables can be used and can be changed to try different scenarios without rebuilding the model.

Answer 22

You can view the model of the building on many different electronic devices, allowing for easy editing on-the-go.

Answer 23

A menu bar, with a drop down menu which can have options added or removed.

Answer 24

Cells, which can be made secure with different access rights.

Answer 25

Icons, which can be added/removed/edited.

Answer 26

Buttons, to press/toggle and carry out commands.

Answer 27

Error messages, specific to the spreadsheet being used can be created to tell the user that they have done something wrong.

Answer 28

Screen resolution, which can be set to high so that the user can view the spreadsheet at a high quality with no obvious pixels.

Answer 29

Sound, which can be turned on and off when they user is carrying out a certain task.

Answer 30

You could make more money because the final product will look more professional so more people would want to use it.

Answer 31

The spreadsheet can be made more secure by the use of different access rights between worksheets.

Answer 32

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).

Answer 33

Novice users can use the new system, meaning that minimal training is required, saving costs

Answer 34

IF Statements

Answer 35

=SUM(C1+G8)

Answer 36

Employee_Salaries

Answer 37

Developing a complex model can take a lot of time to produce.

Answer 38

The equipment and software are expensive to purchase.

Answer 39

You have to be an expert and know lots of technical terms to be able to produce a successful model.

Answer 40

Simulations can't completely re-create real life situations.

Answer 41

You have to know all of the formulas and functions off by heart when creating the model.

Siguiente

OCR ICT AS Level - Spreadsheet Concepts (Chapter 4)

Descripción

Resumen del Recurso

Pregunta 1

Pregunta 2

Pregunta 3

Pregunta 4

Pregunta 5

Pregunta 6

Pregunta 7

Pregunta 8

Pregunta 9

Pregunta 10

Pregunta 11

Pregunta 12

Pregunta 13

Pregunta 14

Pregunta 15

Pregunta 16

Pregunta 17

Pregunta 18

Pregunta 19

Pregunta 20

Similar

	Creado por Lucy Hayfield hace más de 9 años