Microsoft Excel – Intermediate

Please enter your email:

1. How do you enable the circled feature?

 
 
 

2. What is a name reference not used for?

 
 
 
 

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

 
 
 
 
 

4. Define a template

 
 
 
 

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

 
 
 

6. What does a hyperlink not do?

 
 
 
 

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

 
 
 

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

 
 
 
 
 

9. What does Sheet3! Indicate in a formula?

 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 
 

13. What is a Sparkline?

 
 
 

14. Which example of a named reference is correct?

 
 
 

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

 
 
 

Question 1 of 15