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

 
 
 
 

2. Which formula we use to convert a number into text in a number format?

 
 
 
 

3. Which shortcut key we use to open VBE?

 
 
 
 

4. Shortcut to show/hide the objects view?

 
 
 
 

5. Which shortcut key we use to switch between last 2 windows? 

 
 
 
 

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

 
 
 
 

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

 
 
 
 

8. Which shortcut key we use to close VBE? 

 
 
 
 

9. Which syntax is absolute reference to the column and row?

 
 
 
 

10. How can we arrange the data in descending or ascending order?