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