#1. #REF! occurs when a referenced cell is deleted or moved.
#2. Which of the following statement(s) are true about a MACRO?
#3. What is the purpose of the WATCH WINDOW?
#4. Which is not a component of a PIVOTTABLE?
#5. Which of the following is most accurate option for IMPORTING DATA in EXCEL?
#6. The MACROS group is not available in MICROSOFT EXCEL ONLINE.
#7. What is the PURPOSE of the GOAL SEEK function?
#8. A SPARKLINE is:
#9. The DOCUMENT INSPECTOR is a tool you can use to examine your workbook for personal or sensitive information that you may not want to include when sharing your workbook with other users.
#10. Which of the following FILE EXPORT FORMATS are not supported by MICROSOFT EXCEL:
#11. What is DATA VALIDATION?
#12. Which two options can be used to ANALYSE DATA?
#13. On which ribbon do we find the TRACE DEPENDENTS command?
#14. #NULL! is displayed when a CELL:
#15. What is CONDITIONAL FORMATTING?
#16. CONDITIONAL FORMATTING includes the following rule type(s):
#17. The WATCH WINDOW provides you with the ability to display, in ONE PLACE, the results of many formulas throughout your workbook.
#18. #VALUE! is displayed in a CELL when:
#19. You can view your workbook properties by clicking:
#20. DATA VALIDATION command is found on the HOME Ribbon.
Results
Good day,
Thank you for completing our NextGen Online Computer Assessment. You have successfully passed the assessment.
For other free NextGen Online Computer Assessments, please go to:
Regards
NextGen Training Solutions
Good day,
Thank you for completing the NextGen Online Computer Assessment. You have unfortunately not reached the pass mark of 70% for this level.
This should not be seen as a negative, but rather as a reminder of some of the functionality which Microsoft Excel offers. Learning more about Microsoft Excel can help you in your day to day environment.
We see this as a positive message, as this indicates that you may potentially benefit from attending the following training to remind you of, or make you aware of what you can do with Microsoft Excel:
- Microsoft Excel (Level 3)
Regards
NextGen Training Solutions
