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. In Excel, which of the following is an absolute cell reference?

 
 
 
 

2. Which syntax we use to count the cells which are duplicate in a range?

 
 
 
 

3. Style sheet formats can be applied from 

 
 
 
 

4. Which of these will not select all the cells in a document?

 
 
 

5. Which formula we use to remove the extra spaces within a cell?

 
 
 
 

6. Shortcut to cut the selected cell or range?

 
 
 
 

7. Which option should be used to show a cell text as vertically?

 
 
 
 

8. How to split a column in 3 or more columns?

 
 
 
 

9. 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?

 
 
 
 

10. Which symbol we specify to fix the rows and columns?