Microsoft Excel – Intermediate

Please enter your email:

1. Define a template

 
 
 
 

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

 
 
 
 

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

 
 
 
 
 

4. What is a name reference not used for?

 
 
 
 

5. How do you enable the circled feature?

 
 
 

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

 
 
 

7. What does a hyperlink not do?

 
 
 
 

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

 
 
 
 
 

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

 
 
 

10. Which example of a named reference is correct?

 
 
 

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

 
 
 
 
 

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

 
 
 

13. What does Sheet3! Indicate in a formula?

 
 
 

14. What is a Sparkline?

 
 
 

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

 
 
 
 

Question 1 of 15