WorksheetsUsind Spreadsheets Entry 3
Total questions: 10
Worksheet time: 6mins
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
