Year 8 Spreadsheet Quiz

What is the name of the "boxes" that you enter data into?

• Box

• Cell

• Reference

• address

If I type an "=" symbol into a box I am starting a:

=SUM() is an example of a:

What is wrong with this formula? = 1A + B1

• It should be =A1 + B1

• It should be =1A + 1B

• It should be A1 + B1

• It should be 1A + 1B

If I "format a cell for currency" will the value of the cell change?

• No, the value stays the same but displays the £ sign

• Yes, the £ will be stored in the cell address

What is wrong with this function? =SUM(A1,B12)

• The function is missing a "

• The function is missing a ;

• The functions should be =add

• The function is missing a :

The software to create a spreadsheet is called:

• Office 365

• Sheets

• Excel

• Access

=AVERAGE() will do what?

• Calculate the mean

• Calculate the mode

• Calculate the median

• Calculate the range

In Excel, if I want to create a bar chart I click "insert", then click...

Changing how a spreadsheet displays data is known as "F________g"?