#1. You can insert a PIVOTCHART if you do not have a PIVOTTABLE.
#2. To ADD A TITLE to a chart in MICROSOFT EXCEL, click on:
#3. To REMOVE DUPLICATE RECORDS in a WORKSHEET, you can use the following process:
#4. Which of the following STATEMENT(S) are true?
#5. What does the SUMIF do?
#6. MICROSOFT EXCEL can PROTECT SELECTED CELL(S) and not the entire WORKSHEET/WORKBOOK?
#7. Which of the following statement(s) is correct?
#8. Which SHORTCUT KEY(S) are used to create a TABLE?
#9. Which WAY(S) can you use to define or create a RANGE NAME?
#10. What does a SLICER do, in relation to PIVOTTABLES?
#11. What does the TODAY() function do?
#12. 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.
#13. The AVERAGEIF() function will return the average of every cell within a range if the specified criteria are met.
#14. What is the LEN() function used for?
#15. What is the command sequence to ADD A CHART in a WORKBOOK?
#16. On which RIBBON(S) can the FILTER command being found?
#17. On which RIBBON will you find the AUTOSUM function?
#18. To INSERT a BACKGROUND PICTURE, click on:
#19. MICROSOFT EXCEL cannot insert ONLINE pictures.
#20. Which of the following FUNCTION(S) are not available in 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
