Usind Spreadsheets Entry 3

Each box is called....

• a row

• a column

• a speadsheet

• a cell

Which of these is a correct cell address?

• 1A

• A1

• Row1ColA

• ColARow1

Which of these indicates a selected cell?

• italics

• a heavy border

• sound

• a yellow column

Column C in a spreadsheet is too narrow. Which two columns should you hover between to resize column C?

• A and B

• C and D

• D and E

• B and D

Which of these are formatting techniques? Tick all that apply

• bold

• font colour

• cell

• number(currency)

What symbol should all formulas start with?

• %

• ?

• =

• (

Which of these shows the correct formula for C3 multiplied by C4?

• =C3xC4

• =C3*C4

• C3xC4

• =C3/C4

What does : mean in a formula?

• from

• to

• after

• before

Which of these is a correct SUM formula?

• =SUM(A1+A2+A3+A4+A5)

• =SUM(A1A5)

• =SUM(A1toA5)

• =SUM(A1:A5)

What two things do you need to do before printing? Tick all that apply.

• Fit sheet to page

• Make evrything bold

• Change orientation to portrait

• Change orientation to landscape