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