NEW
Font size
WorksheetsSpreadsheet consolidation
Total questions: 20
Worksheet time: 10mins
The program that we use to create spreadsheets
MS Word
MS Paint
MS Excel
Spreadsheet
Cell
Column
Row
Spreadsheet
Cell
Column
Row
Spreadsheet
Cell
Column
Row
Which one is a correct cell address?
A1
1A
A
1
What is the cell address of the pink cell?
A1
1A
D3
3D
What is the cell address of the red cell?
D7
7D
E7
D8
A cell can contain text, values and what else?
Currency
Percentages
Formulae
Dates
What symbol is used to multiply?
/
-
+
*
What symbol is used to divide?
*
+
/
-
How must a cell containing a formula start?
SUM
=
+
( )
What function is used to add more than 2 cells?
+
=
SUM
( )
Columns are identified by what?
Letters of the alphabet
Numbers
Roman numerals
Rows are identified by what?
Letters of the alphabet
Numbers
Roman numerals
The cell address is the combination of what two things?
column number and row number
column letter and row number
column number and row letter
What is written in cell D4?
4376
Doz
PDA
What is written in cell B3?
Ea
Quantity
Flash Drive
What is written in row 1?
The title
The descriptions
The unit prices
What cell would I find the description Scanner in?
A5
D6
E3
