1.
Which Excel function would you use to find the highest value in a range of cells?
2.
In the VLOOKUP function, what does the 'range_lookup' argument specify?
3.
How can you create a drop-down list in Excel?
4.
What does the 'MATCH' function do in Excel?
5.
What does the 'IF' function do in Excel?
6.
What is the correct syntax to use VLOOKUP?
7.
What is the purpose of the VLOOKUP function in Excel?
8.
Which of the following is NOT a valid data type in Excel?
9.
What is the purpose of the 'OFFSET' function in Excel?
10.
How do you sort data in Excel?
