WorksheetsG7 Excel Quiz 1
Total questions: 10
Worksheet time: 2mins
What does the number represent?
Data number
Column number
Row number
Table number
What does the letter represent?
Data letter
Column letter
Row letter
Table letter
What is not an Excel formula?
SUM
TOTAL
MIN
MAX
Adding a group of numbers and then dividing by the count of those numbers is the math formula of...
AVERAGE
MAX
SUM
MIN
This is an accounting number format.
CORRECT
FALSE
V in VLOOKUP stands for...
(a)
H in HLOOKUP stands for...
(a)
VLOOKUP formula contains 4 arguments. "FALSE" goes to the ... argument.
1st
4th
2nd
3rd
HLOOKUP formula also contains 4 arguments. Number count/Index number of the row of the data we want to return (for example "2") is in the ... argument.
4th
3rd
2nd
1st
To make a drop-down list from a selection of cells/tables, we go to menu...
Data information
Data validation
Data confirmation
