Year 9 Spreadsheets Part 1

What do you write to perform calculations in a spreadsheet?

• Computer programs

• Formulae

• Instructions

• Sums

What is SUM an example of?

• Function

• Formula

• Operation

• Instruction

Which feature allows a formula to be copied to another cell yet adjusting the cell reference to match?

• Copy and paste

• Autofill

• Sum

• Fill

What is the purpose of an Absolute cell reference?

• It copies only the cell reference, not the formulae

• It copies the formula, but changes the cell reference to match

• It copies the formula, but does not change the cell reference of selected references

Which is NOT a method of formatting headings to make them clearer?

• Merging cells and increasing text size

• Reduce the size of the text

• Change the background colour of the cell

• Change the colour of the text

Why do we use Formulae for calculations in a spreadsheet?

• So other cells that use this value change when the original value changes

• It shows off what you know about spreadsheets

• It looks better

Which of the following is a suitable formula for calculating 20% of a value?

• =A2*0.20

• =A2-20%

• =A2-0.20

• =A2*20%

To change the formatting of cells that include money, which of the following should we choose?

• Text

• Number

• Currency

• Date