Microsoft Excel – Intermediate

Please enter your email:

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


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


3. Which example of a named reference is correct?


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


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


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


7. How do you enable the circled feature?


8. What does a hyperlink not do?


9. Define a template


10. What does Sheet3! Indicate in a formula?


11. What is a Sparkline?


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


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


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


15. What is a name reference not used for?


Question 1 of 15