Spreadsheet

Question 1

Sum

Answer 1

Adds up a list of number in a list

Question 2

Count

Answer 2

Returns the total number of items there are in a list

Question 3

Single IF

Answer 3

Allows the end user to choose an option

Question 4

Multiple IF

Answer 4

Allows the user to select from 2 or more possible options

Question 5

Spinners

Answer 5

using a button to make changes to values to see what effect this would have on the overall totals

Question 6

LOOKUP function

Answer 6

You can update table of price without having to rewrite formulas, such as IF statements

Question 7

LOOKUP Advantages

Answer 7

Reduces data entry errors

Data only has to be changed once in the main table

Question 8

LOOKUP Disadvantages

Answer 8

If you edit the table the VLOOKUP formula doesn’t work

If there are errors in the table then these errors will return when looked up

Question 9

Sorting

Answer 9

To arrange the data into a meaningful order or sequence

Question 10

Macro

Answer 10

The print macro makes sure that the data will be printed in landscape, in colour, in the middle of the page and that only the current page will be printed

Question 11

Graph

Answer 11

Provides a visual representation of the data

Question 12

Answer Structure

Answer 12

Definition
Where
What
Why

Question 13

Filtering

Answer 13

To look for a specific item of data and remove any other, similar details on the same worksheet