Microsoft Excel – Intermediate

Please enter your email:

1. What does Sheet3! Indicate in a formula?

 
 
 

2. Which option is used to add number onto a chart indicating the figure of a column?

 
 
 
 
 

3. How do you enable the circled feature?

 
 
 

4. How would you format cells based on certain conditions that must be met?

 
 
 

5. What does a hyperlink not do?

 
 
 
 

6. Which button will allow you to add the figures onto a chart:

 
 
 
 
 

7. Define a template

 
 
 
 

8. What is the general use of a line graph?

 
 
 

9. Using Formula auditing, which button will show if a number is needed by other cells?

 
 
 
 

10. Using Formula auditing, which button will show where a formula got its numbers from?

 
 
 
 
 

11. What is a Sparkline?

 
 
 

12. How would you protect the content of cells whilst allowing the user to change specific area’s?

 
 
 
 

13. What is a name reference not used for?

 
 
 
 

14. Which example of a named reference is correct?

 
 
 

15. Can you change the background of the plot area of a chart?

 
 
 

Question 1 of 15