Microsoft Excel – Intermediate

Please enter your email:

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


2. Define a template


3. What does a hyperlink not do?


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


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


6. What is a name reference not used for?


7. What is a Sparkline?


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


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


10. What does Sheet3! Indicate in a formula?


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


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


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


14. Which example of a named reference is correct?


15. How do you enable the circled feature?


Question 1 of 15