Please enter your email:

1. What does Sheet3! Indicate in a formula?

 
 
 

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

 
 
 
 

3. Which example of a named reference is correct?

 
 
 

4. Define a template

 
 
 
 

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

 
 
 
 
 

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

 
 
 
 

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

 
 
 

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

 
 
 
 
 

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

 
 
 

10. What is a name reference not used for?

 
 
 
 

11. How do you enable the circled feature?

 
 
 

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

 
 
 
 
 

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

 
 
 

14. What does a hyperlink not do?

 
 
 
 

15. What is a Sparkline?

 
 
 

Question 1 of 15

Execu-Train