#1. What is the LEN() function used for?
#2. LOGICAL OPERATORS are used to compare two values against one another to see if they meet a specified logical condition.
#3. Which of the following FUNCTION(S) are not available in MICROSOFT EXCEL:
#4. What process do you follow to REMOVE a SLICER?
#5. MICROSOFT EXCEL contains a collection of LOGICAL FUNCTIONS which allow you to ask YES or NO questions related to your data. Such questions return a positive (TRUE) or negative (FALSE) response.
#6. Which of the following statement(s) is correct?
#7. The SYNTAX for the TRIM() function is:
#8. Which SHORTCUT KEY(S) are used to create a TABLE?
#9. What does a SLICER do, in relation to PIVOTTABLES?
#10. You can insert a PIVOTCHART if you do not have a PIVOTTABLE.
#11. SMARTART can be used to create ORGANISATION STRUCTURES.
#12. In MICROSOFT EXCEL, you can apply a CELL NAME or RANGE NAME to SELECTED CELL(S).
#13. What does the SUMIF do?
#14. To ADD A NOTE to a CELL in MICROSOFT EXCEL, first select the CELL, then click on:
#15. TRENDLINES are available in MICROSOFT EXCEL, and help show users FREQUENT COMMANDS used by users.
#16. To REMOVE DUPLICATE RECORDS in a WORKSHEET, you can use the following process:
#17. Which WAY(S) can you use to define or create a RANGE NAME?
#18. Which statement(s) are correct for when you should consider inserting a PIVOTTABLE?
#19. MICROSOFT EXCEL cannot insert ONLINE pictures.
#20. When does the AND function return a TRUE value?
Results
Good day,
Thank you for completing our NextGen Online Computer Assessment. You have successfully passed the assessment.
Would you like to challenge yourself further by completing the assessment for the next level of Microsoft Excel?
If you would, you can follow this LINK/URL:
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 2)
Regards
NextGen Training Solutions
