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. What is the meaning of absolute reference?

 
 
 
 

2. Which of the following special characters is used to start all the formulas in Excel ?

 
 
 
 

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

 
 
 
 

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

 
 
 
 

5. Which formula we use to remove the first 32 (non-printable) characters in the 7-bit ASCII code (values 0 through 31) from text?

 
 
 
 

6. Shortcut to cancel the command and close dialog box?

 
 
 
 

7. Which formula we use to get the average on the basis of criteria?

 
 
 
 

8. Which formula we use to extract the text from the left?

 
 
 
 

9. If you press ___, the cell accepts your typing as its content?

 
 
 
 

10. The accounting style shows negative numbers inĀ