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 the chosen multiple? For example, cell A1 contains 25 and we want to show number as 24.75.

 
 
 
 

2. How to round the number to millions in Excel? 

 
 
 
 

3. In Excel, which functions will calculate the number of workdays between 1/1/2015 and 6/5/2015? 

 
 
 
 

4. Shortcut to evaluate the part of formula?

 
 
 
 

5. Which function we use for rounding a number up to the nearest multiple of significance? For example, cell A1 contains 456.25 and we want to show number as 456.75

 
 
 
 

6. For Example, we have sales data in which column A contains sales person name and column B contains sales amount. In cell C2, we have sales person name and in cell D2, we want to return the sales amount based on cell C2. Which of the following formulas we use?

 
 
 
 

7. Which formula we use to get the location of text in a string?

 
 
 
 

8. Which syntax of SUMIF formula we use as per range and criteria in same columns?

 
 
 
 

9. How to change the border line and color in the cells?

 
 
 
 

10.  Shortcut to create the chart?