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 return average on the basis of one condition?

 
 
 
 

2. Which of the following functions, as a formula with a logical function, shows the word “TRUE” or “FALSE” as a result ?

 
 
 
 

3. Which function we will use to find the highest number in a series of number in the range?

 
 
 
 

4.  Shortcut to create the chart?

 
 
 
 

5. Shortcut to step out from the evaluation?

 
 
 
 

6. Which formula we can use to copy the data from horizontal to vertical?

 
 
 
 

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

 
 
 
 

8. Which chart we use for visually comparing the values across a few categories when the chart shows duration or the category text is long?

 
 
 
 

9. In a cell, we have a dropdown filter of grades and we want when we select A, it should be highlighted with Green color and when we select B then it should be highlighted with Yellow color. Which option we will use to highlight the cell based on grades?

 
 
 
 

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