NEW
Font size
WorksheetsSpreadsheets 1
Total questions: 15
Worksheet time: 7mins
A grid of cells which organises data into rows and columns is called a
Spreadsheet
Document
Hardcopy
Workplan
These run left to right across the window and they are identified by a number.
Row
Column
Grid
Cell
The intersection of a row and a column is called a
Grid
Cell Address
Cell
Range
The above picture BEST indicates a
Cell
Cell Address
Row
Range
Spreadsheets are preferable to manual calculation and recording of data for a variety of reasons. Which of the following is NOT a use of spreadsheets?
Calculations e.g. Adding, Subtracting
Household Finance Planning
Creating Invoices
Sourcing Information
The highlighted section above signifies a
Cell
Row
Grid
Range
Which of the following is not a spreadsheet software package?
Microsoft – Excel
Google Sheets
Lotus 123
Quantum Pro
The cell that is outlined with a black border is called
Value
Active Cell
Formula
Label
A group of cells from A1 to A5 is called
Active Cell
Cell Address
Range
Label
A piece of text entered into a spreadsheet that cannot be used in calculations is called
Value
Label
Range
Formula
The address of the cell in Column C, Row 7 is
C7
7C
7: C
Row7ColC
A set of instructions that performs a calculation in a spreadsheet is called a:
Value
Label
Formula
Range
Which of the following symbols is used to begin a formula in a spreadsheet?
.
+
=
/
If the contents of cell A1 = 10 and B1 = 5, what will the result of =A1+B1 be?
10
15
20
25
Which of the following can be entered into a spreadsheet cell?
Text, Numbers, and Formulas
Only text
Only numbers
Only pictures
