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