Microsoft Excel – Intermediate

Please enter your email:

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

 
 
 
 

2. How do you enable the circled feature?

 
 
 

3. What does Sheet3! Indicate in a formula?

 
 
 

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

 
 
 
 

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

 
 
 

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

 
 
 
 
 

7. What is a Sparkline?

 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 

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

 
 
 

12. What is a name reference not used for?

 
 
 
 

13. Which example of a named reference is correct?

 
 
 

14. Define a template

 
 
 
 

15. What does a hyperlink not do?

 
 
 
 

Question 1 of 15