WorksheetsGRADE 12 AA DIAGNOSTIC 2026
Total questions: 40
Worksheet time: 43mins
In spreadsheet terminology, what does the term "cell range" refer to?
A group of adjacent cells
A single cell
A row or column
The entire worksheet
What is the result of the formula =SUM(A1:A5) if cells A1 to A5 contain the values 5, 10, 15, 20, and 25, respectively?
50
25
75
100
Which formula is used to find the average of a range of cells in Excel?
AVG()
AVERAGE()
MEAN()
SUM()
To add the values in cells B2 to B5, in the spread sheet table above, which formula should be placed in cell B6?
=SUM (B2:B6)
=SUM (B2:B5)
ADD (B2:B5)
TOTAL(B2:B5)
In order to find the highest value in Column B the correct formula to apply would be:
=Max(A2:C5)
=ADD(B2:C5)
=Max(B2:B5)
=SUM(A2:C5)
What is the correct cell range for Column B?
B2: B5
B2: C2
B1: B5
B2:B3
To multiply the values in cells B2 and C2, you would type the formula:
=MLTILPY (B2+C2)
=B2*C2
B2+C2
=B2:C2
What is the numerical data range in the worksheet?
A2:C5
B2:C5
A1:C5
B1:C1
Which column has numeric data formatted to 2 decimal places?
Column D
Column C
Column B
Column A
What is the alignment for the numeric data in the worksheet?
Left
Centre
Right
Merge and center
The formula for totaling the numeric data in Column D is?
=(D2+C3+C4)
=(D2+D3+D4)
=(E2+E3+D4)
=(D1:D4)
This Microsoft application can be used for storing, organizing, and manipulating data, and is also useful for storing financial data.
Word
Excel
Access
PowerPoint
In Microsoft Excel, this is defined as a box in which you can enter a single piece of data:
Cell
Row
Column
Formula bar
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?
/
-
+
=
If you wanted to add the values in four consecutive cells together which function would you use?
SUM
MAX
MIN
AVERAGE
The intersection of a row and column in a spreadsheet is called a __________.
Cell
Formula
Label
Value
In spreadsheets, columns are marked with _________.
Letters
Numbers
= sign
Both a letter and a number
In spreadsheets, rows are marked with _________.
Letters
Numbers
= sign
Both a letter and a number
Which of the following is an example of a cell reference or cell address?
C
9
B4
=A1+A2
a. Add the numbers in A3, D3, and E3
b. Take B5 away from D6
c. Divide the number in G4 by the number in H8
d. Multiply F1 by C5
e. Find the average of numbers in cells from C3 to C10
f. Find the biggest number from D3 to D40
g. Find the smallest number from D3 to D40
Match the picture with the correct safety rule.
Fill in the blank: a) To protect your head, you must wear a (a) .
Fill in the blank: b) If you see a spill on the floor, you should (a) .
Fill in the blank: c) The emergency exit is used during (a) .
Fill in the blank: d) You must wear (a) to protect your hands.
Fill in the blank: e) A _____________ is used to put out small fires.
Fill in the blank: f) Safety signs help to (a) you of danger.
What symbol must be placed at the beginning of a formula in Microsoft Excel?
*
=
+
#
Which formula correctly subtracts the value in cell B3 from the value in cell B2?
=B2/B3
=B2+B3
=B3-B2
=B2-B3
Which formula correctly calculates the average of the values in cells D2 to D5?
=SUM(D2:D5)
=AVG(D2:D5)
=MEAN(D2:D5)
=AVERAGE(D2:D5)
Which of the following is NOT considered personal protective equipment (PPE)?
Safety goggles
Protective gloves
Hard hat
Fire extinguisher
Which of the following is NOT a type of PPE used to protect the body?
Protective apron
Safety boots
First-aid box
High-visibility vest
Which of the following is NOT worn as personal protective equipment?
Warning sign
Face shield
Ear defenders
Safety harness
