NEW
Font size
WorksheetsSpreadsheet Starter
Total questions: 12
Worksheet time: 6mins
What is a spreadsheet used for?
Editing photos
Organising, calculating, and analysing data
Calculate data only
Writing up numbers
In a spreadsheet, what is a "cell"?
A type of battery
A special formula
A row of numbers
A single box where data is entered
What symbol is used to start a formula in a spreadsheet?
@
%
+
=
What is the purpose of the SUM function?
To add up a range of numbers
To format text
To multiply numbers
To sort data
What happens when you click on the bottom right corner of a cell and drag it down?
It deletes the data in the selected cells
It moves the cell to another sheet
It copies the value and fills the cells below (AutoFill)
It locks the cell so it cannot be edited
What symbol is used for division in spreadsheets
/
*
^
+
The entire spreadsheet is composed of rows and columns of cells.
True
False
In spreadsheets, columns are marked with _________.
Letters
Numbers
Signs
Formulas
In spreadsheets, rows are marked with _____.
Letters
Numbers
Signs
Formulas
Which of the following is an example of a cell reference or cell address?
=A1+A2
B4
9
C
Which of the following is an example of a "function"?
= D3 / D6
=Sum(C4:C15)
=B7 * B9
=A2 + A5
Is this a formula or a function?
=A1 + B5 + C10
Formula
Function
