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 the number to specified number of digits? For example, cell A1 contain 456.25 and we want to show number as 456.

 
 
 
 

2. Which syntax we use to count the cells which contain text?

 
 
 
 

3. In Excel, comments can be added to cells using

 
 
 
 

4. Which shortcut key we use to switch between last 2 windows? 

 
 
 
 

5. You have a worksheet with data in cells A1:G25 and you are in cell C6. What is the quickest way to navigate to cell G1?

 
 
 
 

6. Which among the following is Excel data types?

 
 
 
 

7. Which function converts miles into kilometers?

 
 
 
 

8. Shortcut to enter the formula as an array formula?

 
 
 
 

9. Which formula we use to extract the text from the mid?

 
 
 
 

10. Which formula we use to get the interest rate per period of an annuity?