Topic 12.2 Spreadsheet

Question 1

Sum

Answer 1

Adds up numbers 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 the table of price without having to rewrite formulas, such as IF statements

Question 7

LOOKUP Advantages (2)

Answer 7

Reduces data entry errors

Data only has to be changed once in the main table

Question 8

LOOKUP Disadvantages (2)

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 so that it prints quickly because I don’t have to enter them each time.

Question 11

Graph

Answer 11

Provides a visual representation of the data

Question 12

Filtering

Answer 12

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

Question 13

Answer Structure

Answer 13

Definition
Where
What
Why