Microsoft Excel – Intermediate

Please enter your email:

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

 
 
 
 
 

2. What does a hyperlink not do?

 
 
 
 

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

 
 
 
 

4. How do you enable the circled feature?

 
 
 

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

 
 
 
 

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

 
 
 

7. Which example of a named reference is correct?

 
 
 

8. What is a name reference not used for?

 
 
 
 

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

 
 
 
 
 

10. What does Sheet3! Indicate in a formula?

 
 
 

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

 
 
 
 
 

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

 
 
 

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

 
 
 

14. Define a template

 
 
 
 

15. What is a Sparkline?

 
 
 

Question 1 of 15