Microsoft Excel – Intermediate

Please enter your email:

1. What does Sheet3! Indicate in a formula?


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


3. What does a hyperlink not do?


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


5. What is a name reference not used for?


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


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


8. Define a template


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


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


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


12. Which example of a named reference is correct?


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


14. What is a Sparkline?


15. How do you enable the circled feature?


Question 1 of 15