Microsoft Excel – Intermediate

Please enter your email:

1. What does Sheet3! Indicate in a formula?

 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

4. Define a template

 
 
 
 

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

 
 
 
 

6. What is a Sparkline?

 
 
 

7. Which example of a named reference is correct?

 
 
 

8. How do you enable the circled feature?

 
 
 

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

 
 
 

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

 
 
 

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

 
 
 
 

12. What does a hyperlink not do?

 
 
 
 

13. What is a name reference not used for?

 
 
 
 

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

 
 
 
 
 

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

 
 
 

Question 1 of 15