WorksheetsSpreadsheet Formulas
Total questions: 22
Worksheet time: 27mins
A (a) uses a rectangular (b) made up of rows and (c) to (d) and store data that requires some type of (e) .
All spreadsheets consist of rows that run (a) across the screen and columns that run (b) down the screen.
A cell is the (a) of a row and column. The position of the cell in the spreadsheet is called its (b) (or cell address).
(a) are instructions to perform a (b) .
What is the cell reference for the following data in the spreadsheet shown:
Monday = (a) | 18.92 = (b)
Airborne = (c) | 36.72 = (d)
Write down the data stored in these cells of the spreadsheet shown.
B2
Title
Ben Hur
9
Rental Price
What data is stored in the cells of the spreadsheet shown: C4 = (a) | E6 = (b) |
| G2 = (c) | F12 = (d) |
What is a spreadsheet primarily used for?
Sending Email
Organizing and analysing data
Draw pictures
Playing games
A (a) in a spreadsheet is an (b) of a row and a (c)
The (a) of a spreadsheet (b) is to perform (c) on data such as numbers
What symbol is often used to indicate multiplication in spreadsheet formulas? (using a QWERTY keyboard)
+
*
/
\
Which of the following is a valid spreadsheet function?
=SUM()
=ADD()
=MULTIPLY()
=DIVIDE()
The (a) function (b) the (c) of a range of numbers.
A cell (a) in a spreadsheet shows the (b) of a cell like A1 or (c)
Which spreadsheet function is used to find the highest value in a range of numbers?
=MAX()
=MIN()
MAX()
=HIGH()
The (a) button is used (b) a (c) in most software applications?
A cell range in a (a) (sp......et) is a selection of two or more cells in a rectangular pattern.
Spreadsheets allow the numerical data in particular cells to be displayed as a (a) (gr....h) or chart.
Rows run (a) across the worksheet. Rows are (b) by (c)
Rows are labelled with _____ (1, 2, 3....) and columns are labelled with _____ (A, B. C....)
(a)
Study the adjacent spreadsheet : The total marks is out of 100.
The correct spreadsheet formula to calculate the % for Steven in Computer Studies is (a)
Study the adjacent spreadsheet : The total marks is out of 100 for each subject:
The correct spreadsheet formula to calculate the class average for Geography is:
(a)
