EXCEL Lookup & reference functions practice test

To Learn more on Excel Logical and Reference functions click here.

This quiz will have all questions from Excel Lookup functions and reference

Please enter your email:

1. From below which Excel function helps to count the number of columns in the given range.

 
 
 
 

2. Which function is used to get the formula used in any cell?

 
 
 
 

3. Which Function used to do horizontal lookup data (using Rows).

 
 
 
 

4. Which Functions are used to get the Row and Column numbers in Excel

 
 
 
 

5. Functions which are used to count the number of rows and columns?

 
 
 
 

6. Which function is used to get Row data in a Column-wise and Column data in Row-wise?

 
 
 
 

7. Which Excel function is used to get Value in the cell if we give the cell address?

 
 
 
 

8. What is the Latest function which is replacement for Vlookup?

 
 
 
 

9. What is the Latest function which is replacement for MATCH?

 
 
 
 

10. Please select the correct function for which syntax is (reference,rows,cols,[height],[weight]).