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 formula we use to remove the extra spaces within a cell?

 
 
 
 

2. If you want to get the row number then which formula you will choose to achieve the requirement? 

 
 
 
 

3. Which formula we use to return average to the number of a range?

 
 
 
 

4. To replace the apostrophe (‘) with the space, which formula we need to use?

 
 
 
 

5. Shortcut to evaluate the part of formula?

 
 
 
 

6. Which formula we use to round the number in thousands?

 
 
 
 

7. Which formula we use to return average on the basis of multiple conditions?

 
 
 
 

8. Shortcut to create the table?

 
 
 
 

9. Which syntax is relative reference (column) and absolute reference (row)?

 
 
 
 

10. How to adjust the size of a column according to the size of text?