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. You can check the conditions against ____ when applying conditional formatting?

 
 
 
 

2. If we want to step in the formula, which of the following options we have to select?

 
 
 
 

3. If you want to check the data on specific condition then which formula you will use to get the desired output?

 
 
 
 

4. Shortcut to define the name?

 
 
 
 

5. The cell reference for a range of cells that starts in cell A1 and goes over to column D and down to row 10 is?

 
 
 
 

6. Shortcut to step out from the evaluation?

 
 
 
 

7. Which formula we use to merge the text from different cells in a cell?

 
 
 
 

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

 
 
 
 

9. Which formula we use to define the value indirectly?

 
 
 
 

10. Which formula we use to get the position of an item in an array?