Font size
WorksheetsGR10 EXCEL
Total questions: 20
Worksheet time: 12mins
What is a function?
A function is a built in option that we can get from excel.
A function is when we use any math operators to get the answers.
A function is clicking in a cell.
What does the SUM function do?
Counts the number of cells in a range
Calculates the total amount
Returns the value that occurs most frequently
The function we use to count the number of empty cells in a range
(a)
The multiply symbol in Excel
/
-
+
*
The letters in Excel represents the....
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Column
Cells
Data
When inserting a Formula or Function. It should always start with
/
=
+
-
What do you call the blocks on an Excel Sheet?
Value
Info
Cell
Square
What is the name of the Cell?
A6
B9
B1
B3
Choose the correct function:
The teacher needs to find out how many learners was absent
=Sum(C2:C6)
=Count(C2:C6)
=Max(C2:C6)
=Count(A2:A6)
What function will I use to get the highest value?
=Min(C2:C6)
=Average(C2:C6)
=Max(C2:C6)
=Mode(C2:C6)
What function are you going to use the get the number of Males in the worksheet?
(a)
What will my criteria be when I want to know how many Gr11 learners there are.
M
12
11
50
What will be the correct function when working out the number of scores that are above 7000
=Count(E3:E12)
Countif(E3,E12,>=7000)
=Countif(E3:E12,<=7000)
=Countif(E3:E12,>=7000)
Function we use to return the current date
Mode
Rand
Today
Now
Function used to generate random whole number
Rand
Randbetween
Max
Mode
In cell C3. Type the formula that will be used when calculating the new price that will include the VAT of 15%
(a)
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1-A25)
=average(A1-A25)
=avg(A1:A25)
What does the function CountA do?
Counts the number of cells in a range that contain numeric values.
Counts the number of empty cells
Counts the number of cells that comply with a specific criterion
Counts the number of cells in a range that contains either numeric values or text
What does the following error mean in Excel:
#NAME?
Invalid function name is used
Cell reference in a formula/ function is no longer valid
Division by zero
Reference is made to cells in the formula/ function where the data type cannot be used in calculation
