#1. MICROSOFT EXCEL cannot insert ONLINE pictures.
#2. What does the TODAY() function do?
#3. The following SHORTCUT KEYS opens the HYPERLINK DIALOG BOX.
#4. What is the command sequence to ADD A CHART in a WORKBOOK?
#5. In MICROSOFT EXCEL, you can apply a CELL NAME or RANGE NAME to SELECTED CELL(S).
#6. To REMOVE DUPLICATE RECORDS in a WORKSHEET, you can use the following process:
#7. Which statement(s) are correct for when you should consider inserting a PIVOTTABLE?
#8. TRENDLINES are available in MICROSOFT EXCEL, and help show users FREQUENT COMMANDS used by users.
#9. What does the SUMIF do?
#10. You can insert a PIVOTCHART if you do not have a PIVOTTABLE.
#11. To ADD A NOTE to a CELL in MICROSOFT EXCEL, first select the CELL, then click on:
#12. Which of the following STATEMENT(S) are correct:
#13. Can MICROSOFT EXCEL PROTECT SELECTED CELL(S) and not the entire WORKSHEET/WORKBOOK?
#14. The SYNTAX for the MID() function is:
#15. The AVERAGEIF() function will return the average of every cell within a range if the specified criteria are met.
#16. What does a SLICER do, in relation to PIVOTTABLES?
#17. When would you use the TRIM() function?
#18. LOGICAL OPERATORS are used to compare two values against one another to see if they meet a specified logical condition.
#19. When does the AND function return a TRUE value?
#20. The following FUNCTION(S) are not supported by MICROSOFT EXCEL:
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
