#1. 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.
#2. CONDITIONAL FORMATTING includes the following rule type(s):
#3. You can GROUP DATA:
#4. A SPARKLINE is:
#5. The WATCH WINDOW provides you with the ability to display, in ONE PLACE, the results of many formulas throughout your workbook.
#6. MICROSOFT EXCEL does not allow the integration of MICROSOFT FORMS into a WORKBOOK.
#7. When adding a NEW MACRO, there are specific rules which must be followed. Which of the following rules is INCORRECT?
#8. Which of the following FILE EXPORT FORMATS are not supported by MICROSOFT EXCEL:
#9. SLICER and TIMELINE FILTERS are not available in MICROSOFT EXCEL ONLINE.
#10. What is the command sequence to open the CONSOLIDATE dialog box?
#11. What is the PURPOSE of the GOAL SEEK function?
#12. The MACROS group is not available in MICROSOFT EXCEL ONLINE.
#13. Which of the following is not a VALID DATA SOURCE for MICROSOFT EXCEL?
#14. #REF! occurs when a referenced cell is deleted or moved.
#15. CONDITIONAL FORMATTING can highlight DUPLICATES in a data.
#16. What is a MACRO?
#17. What does the ‘#NAME?’ calculation error type indicate?
#18. #NULL! is displayed when a CELL:
#19. What does the ‘#DIV/0?’ calculation error type indicates?
#20. What is CONDITIONAL FORMATTING?
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
