#1. When NAMING a NAME RANGE, one can have SPACES in the NAME.
#2. Which of the following statement(s) is correct?
#3. When would you use the TRIM() function?
#4. You can insert a PIVOTCHART if you do not have a PIVOTTABLE.
#5. The AVERAGEIF() function will return the average of every cell within a range if the specified criteria are met.
#6. Which statement(s) are correct for when you should consider inserting a PIVOTTABLE?
#7. What process do you follow to REMOVE a SLICER?
#8. To ADD A NOTE to a CELL in MICROSOFT EXCEL, first select the CELL, then click on:
#9. What is the command sequence to ADD A CHART in a WORKBOOK?
#10. SMARTART can be used to create ORGANISATION STRUCTURES.
#11. What does the NOW() function do?
#12. What is the LEN() function used for?
#13. The following FUNCTION(S) are not supported by MICROSOFT EXCEL:
#14. When does the AND function return a TRUE value?
#15. What is the ALT TEXT used for?
#16. What does the TODAY() function do?
#17. Which SHORTCUT KEY(S) are used to create a TABLE?
#18. 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.
#19. To ADD A TITLE to a chart in MICROSOFT EXCEL, click on:
#20. What does the SUMIF do?
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
