Microsoft Excel – Intermediate

Please enter your email:

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

 
 
 

2. What is a name reference not used for?

 
 
 
 

3. What is a Sparkline?

 
 
 

4. How do you enable the circled feature?

 
 
 

5. What does Sheet3! Indicate in a formula?

 
 
 

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

 
 
 
 

7. Which example of a named reference is correct?

 
 
 

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

 
 
 
 
 

9. Define a template

 
 
 
 

10. What does a hyperlink not do?

 
 
 
 

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

 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 

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

 
 
 

Question 1 of 15