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, a value used in a formula that does not change is called a …………

 
 
 
 

2. Shortcut to open the Font tab in Format Cells dialog box?

 
 
 
 

3. VLOOKUP function is used to?

 
 
 
 

4.  Which shortcut key we use for quick watch? 

 
 
 
 

5. Shortcut to define the name?

 
 
 
 

6. What is the sign of not equal to?

 
 
 
 

7. You are working on Excel in File A and realize you need some information from another Excel file, File B. However, you accidentally open File C. What shortcut would you use to close File C while keeping File A open, and while also keeping Excel open?

 
 
 
 

8. To drag a selected range of data to another worksheet in the same workbook, use the

 
 
 
 

9. For Example, we have sales data in which column A contains sales person name and column B contains sales amount. In cell C2, we have sales person name and in cell D2, we want to return the sales amount based on cell C2. Which of the following formulas we use?

 
 
 
 

10. Which among the following is Excel data types?