NEW
Font size
WorksheetsS3 Admin Spreadsheets Revision
Total questions: 18
Worksheet time: 6mins
Which Package do we use for Spreadsheets?
Microsoft Word
Microsoft Publisher
Microsoft Excel
Microsoft Powerpoint
What do we call this?
Row
Column
Cell
Workbook
What is this?
Row
Column
Cell
Workbook
What is this?
Row
Column
Cell
Workbook
What is the highlighted cell reference?
C9
C10
B10
D9
What is the highlighted cell reference?
D3
E3
C4
D4
What is the highlighted cell reference?
A1
A2
B1
B2
What does this do?
Adjust row width
Adjust row height
Adjust column width
Adjust column height
What Correction needs carried out here?
Adjust Row
Adjust Column
Wrap Text
Merge Cells
Which cell contains a multiplication (times) formula?
B2
B3
B4
B5
Which cell contains the divide formula?
B2
B3
B4
B5
Which cell contains the subtraction formula?
B2
B3
B4
B5
Which cell contains the addition formula?
B2
B3
B4
B5
What does this symbol mean?
Sum
Average
Autosum
Total
What is the correct Formula to give an Average?
Avrg(B3:B9)
Average(B3:B9)
=Average(B3:B9)
=Avrg(B3:B9)
What formula would give the total?
=Max(B3:B9)
=Total(B3:B9)
Sum(B3:B9)
=Sum(B3:B9)
What formula gives us the highest sales?
Max(B3:B9)
Min(B3:B9)
=Max(B3:B9)
=Min(B3:B9)
What formula gives us the lowest sales?
Min(B3:B9)
Lowest(B3:B9)
=Lowest(B3:B9)
=Min(B3:B9)
