Please enter your email:

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

 
 
 
 
 

2. What is a Sparkline?

 
 
 

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

 
 
 

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

 
 
 

5. What does Sheet3! Indicate in a formula?

 
 
 

6. What is a name reference not used for?

 
 
 
 

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

 
 
 
 
 

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

 
 
 
 

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

 
 
 
 

10. How would you protect the content of cells whilst allowing the user to change specific areas?

 
 
 

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

 
 
 

12. Which example of a named reference is correct?

 
 
 

13. How do you enable the circled feature?

 
 
 

14. Define a template

 
 
 
 

15. What does a hyperlink not do?

 
 
 
 

Question 1 of 15