This quiz is automatically created to help you get started. It will be created only once.
Please provide valid email address to know your score

Please enter your email:

1. Which function we use for rounding down the number? For example, cell A1 contains 456.25 and we want to show number as 456.

 
 
 
 

2. Which formula will be useful to get the cell address from a given column and row?

 
 
 
 

3. Which among the following is divide symbol in Excel?

 
 
 
 

4. Shortcut to find the value in the data?

 
 
 
 

5. Shortcut to convert the format into currency format?

 
 
 
 

6. How to specify cell range from B1 to B20 in Excel?

 
 
 
 

7. What is the way to highlight the duplicate cells in data?

 
 
 
 

8. Which formula we use to lookup the value in a range?

 
 
 
 

9. Where are the status indicators located?

 
 
 
 

10. Shortcut to paste the data in Excel?