Microsoft Excel – Intermediate

Please enter your email:

1. What does Sheet3! Indicate in a formula?


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


3. How do you enable the circled feature?


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


5. What does a hyperlink not do?


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


7. Define a template


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


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


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


11. What is a Sparkline?


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


13. What is a name reference not used for?


14. Which example of a named reference is correct?


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


Question 1 of 15