Microsoft Excel – Intermediate

Please enter your email:

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

 
 
 

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

 
 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

6. What is a Sparkline?

 
 
 

7. What is a name reference not used for?

 
 
 
 

8. Define a template

 
 
 
 

9. Which example of a named reference is correct?

 
 
 

10. How do you enable the circled feature?

 
 
 

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

 
 
 

12. What does Sheet3! Indicate in a formula?

 
 
 

13. What does a hyperlink not do?

 
 
 
 

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

 
 
 
 

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

 
 
 

Question 1 of 15