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