NEW
Font size
WorksheetsSpreadsheet Basics
Total questions: 35
Worksheet time: 18mins
A vertical line of cells in a spreadsheet is a what?
Row
Column
A horizontal line of cells in a spreadsheet is a what?
Row
Column
If you wanted to change the colour of the text inside a cell, which tool would you use?
Text colour
Fill colour
Borders
Bold
If you wanted one cell or a number of cells to stand out from the rest which tool could you use?
Bold
Fill Colour
Currency
Borders
Something that automatically calculates something for you using the data in cells is a:
Formula
Formatting
What do all formulae start with in a spreadsheet?
+
/
*
=
Which mathematical operator (symbol) would you use if you are adding the values in cells together?
/
-
+
=
Which mathematical operator (symbol) would you use to divide the values in two cells?
/
-
*
=
Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?
/
-
*
=
Which mathematical operator (symbol) would you use to multiply the values in two cells together?
/
-
*
=
What is the cell reference of the cell with value Coca-Cola inside?
A3
3A
C5
D7
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
=Sum(E2:E25)
=A1 + B5 + C10
What is the name of this part of a Spreadsheet?
Row
Column
Letters
Cells
Spreadsheet
What is the name of this part of a Spreadsheet?
Row
Column
Letters
Cells
Spreadsheet
What is the name of this part of a Spreadsheet?
Row
Column
Letters
Cell
Spreadsheet
How do we call the text in bold in this spreadsheet?
Values
Columns
Capitals
Labels
How do we call the part in orange in this spreadsheet?
Price
Items
Labels
Values
What is the cell reference of the one that is highlighted?
B3
A2
Row B
3B
The graph shows the number of colored beads used to make a necklace. How many purple and green beads were used in all?
23
20
18
15
The least animals in the farm are . . . .
cows
chicken
sheep
Which circle graph has the same data as the bar graph?
Name the type of graph.
pie chart
tally chart
pictograph
bar graph
Name the type of graph.
pie chart
tally chart
pictograph
bar graph
Name the type of graph.
pie chart
tally chart
pictograph
bar graph
