#1. What is a MACRO?
#2. The WATCH WINDOW provides you with the ability to display, in ONE PLACE, the results of many formulas throughout your workbook.
#3. #NULL! is displayed when a CELL:
#4. Which of the following FILE EXPORT FORMATS are not supported by MICROSOFT EXCEL:
#5. You can GROUP DATA:
#6. #VALUE! is displayed in a CELL when:
#7. What is the PURPOSE of the GOAL SEEK function?
#8. What does the ‘#DIV/0?’ calculation error type indicates?
#9. What is DATA VALIDATION?
#10. The MACROS group is not available in MICROSOFT EXCEL ONLINE.
#11. Which two options can be used to ANALYSE DATA?
#12. When adding a NEW MACRO, there are specific rules which must be followed. Which of the following rules is INCORRECT?
#13. CONDITIONAL FORMATTING can highlight DUPLICATES in a data.
#14. Which of the following statement(s) are true about a MACRO?
#15. #REF! occurs when a referenced cell is deleted or moved.
#16. A SPARKLINE is:
#17. SLICER and TIMELINE FILTERS are not available in MICROSOFT EXCEL ONLINE.
#18. Which statement ACCURATELY DESCRIBES the updating process of PIVOTTABLES?
#19. The SHORTCUT KEY to EDIT the formula in a CELL, press:
#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
