NEW
Font size
WorksheetsBasic Spreadsheet
Total questions: 30
Worksheet time: 15mins
The cell that is currently selected
Cell reference
Cell range
Label
Active cell
Which is an example of a cell reference in a spreadsheet?
6C
45
fall
B9
A group of cells is called _______________.
Range
Autosum
Row
Column
Which are fields?
Which are the records?
How do we filter data in Excel?
How do we validate data in Excel?
Which formula multiplies E2 times 0.1?
Which formula adds D2 plus E2?
A selection of 2 or more cells that lets you perform an action on a group of cells at once
Copy
Format
Range
Function
Appears at the border of the column letters. Drag to widen or narrow the width of a column.
Used to select a whole row/column when positioned on the row number or column letter.
The fill handle - used for copying formula or extending a data series.
Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
COUNT
COUNTA
SUM
AVERAGE
Why would you put a filter on your spreadsheet?
To view the top row at all times
To view specific criteria in your spreadsheet
To help with formulas
To delete data from your spreadsheet
What must all formulas start with?
+
=
#
sum
What is the cell reference of the active cell?
A1
4B
BB8
B4
What has happened to Superheros in cells B2:D2?
Merged
Joined
Fused
Nothing
What does the function =SUM() do?
Adds up Cells
Sells Cells
Multiplies Cells
Divides Cells
What does the function =MAX() do?
Finds the smallest number
Finds the biggest number
Finds the right number
Finds the left number
What does the function =MIN() do?
Finds the biggest number
Finds the smallest number
Finds the correct number
Finds the wrong number
