Microsoft Excel – Intermediate

Please enter your email:

1. Define a template


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


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


4. What is a name reference not used for?


5. How do you enable the circled feature?


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


7. What does a hyperlink not do?


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


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


10. Which example of a named reference is correct?


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. What does Sheet3! Indicate in a formula?


14. What is a Sparkline?


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


Question 1 of 15