N5 Admin Spread Sheet Questions

I want to add 2 cells together. I have to....

• +

• range

I have to add a row of figures. I use....

• +

• Range

I have to create a formula which involves working with a figure for tax. Tax is subtracted

• True

• False

A discount means an amount is subtracted from a total

• True

• False

A sub total comes before an Overall Total

• True

• False

An 'if statement' offers how many answers at N5

• 1

• 2

• 3

• 4

I have figures from 4 different areas - North, South, East and West. I want to add up the amounts for each area. I have to do what first before totalling?

• Add up the row or the column

• Insert a new row

• Sort into A to Z order

• Create a graph

I see $ around cells when using which function?

If I want to create a graph I click on which menu?

I am printing showing formula view. I show gridlines only.

• True

• False