Microsoft Excel 2016 Part 3 Pre/Post Assessment Exam

Please wait...
Question 1 / 24
0 %
0/100
Score 0/100
1. True or False? The Watch Window can evaluate formulas, within a worksheet, on different worksheets in a workbook, and between worksheets in different workbooks.
Submit
Please wait...
About This Quiz
Microsoft Excel 2016 Part 3 Pre/Post Assessment Exam - Quiz

.

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. True or False? The Document Inspector can remove all Personal Information, Hidden worksheets containing PivotTables, and Links to Other Files.
Submit
3. What are containers for storing VBA code?
Submit
4. True or False? A two-variable data table may have more that two variables.
Submit
5. What feature enable multiple users to make changes to multiple workbooks and then merge the workbooks into one workbook.
Submit
6. Which is not a valid format to which you can save an Excel workbook?
Submit
7. Which dialog box will allow you to restrict data as Whole numbers, to a certain Text length, or as a List of items?
Submit
8. What is a reference, either direct or indirect, that points to the cell containing the reference?
Submit
9. If a link is broken in an external worksheet, what must you click to repair the link?
Submit
10. Where would you enable the Developer Tab?
Submit
11. There are seven major type of errors in Excel 2016. Which one of the following is not errors in Excel 2016?
Submit
12. In PowerPivot, what tool is used to populate columns by aggregating data?
Submit
13. What is 3-D referencing?
Submit
14. What is repetitive mathematical operations that calculate an approximate solution by using the output of the previous calculations as part of the input for the following calculations?
Submit
15. What is the Dialog box named that allows you to summarize data from multiple sources, even if the number of rows is inconsistent?
Submit
16. In what hidden workbook do you store Macros for use in other workbooks?
Submit
17. Which of the following is a valid link to the workbook Sales Data? The linked workbook contains a range of cells C7:C13 named Quarter1.
Submit
18. If you want your workbook to be "508 compliant", which is not an option might you choose?
Submit
19. In Excel 2016, what is a data range that consist of either a single row or single column of populated cells?
Submit
20. Which tool will not help you to see where your formula's raw data originated?
Submit
21. Which one of the following is NOT a form control?
Submit
22. Where would you enable a comment so it will print?
Submit
23. Where can you set a password to protect the document from opening and, at the same time, add a password for modifying the document?
Submit
24. Which two of the following are NOT required arguments of the HLOOKUP?
Submit
View My Results

Quiz Review Timeline (Updated): +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 23, 2016
    Quiz Created by
Cancel
  • All
    All (24)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
True or False? The Watch Window can evaluate formulas, within a...
True or False? The Document Inspector can remove all Personal...
What are containers for storing VBA code?
True or False? A two-variable data table may have more that two...
What feature enable multiple users to make changes to multiple...
Which is not a valid format to which you can save an Excel workbook?
Which dialog box will allow you to restrict data as Whole numbers, to...
What is a reference, either direct or indirect, that points to the...
If a link is broken in an external worksheet, what must you click to...
Where would you enable the Developer Tab?
There are seven major type of errors in Excel 2016. Which one of the...
In PowerPivot, what tool is used to populate columns by aggregating...
What is 3-D referencing?
What is repetitive mathematical operations that calculate an...
What is the Dialog box named that allows you to summarize data from...
In what hidden workbook do you store Macros for use in other...
Which of the following is a valid link to the workbook Sales Data? The...
If you want your workbook to be "508 compliant", which is not an...
In Excel 2016, what is a data range that consist of either a single...
Which tool will not help you to see where your formula's raw data...
Which one of the following is NOT a form control?
Where would you enable a comment so it will print?
Where can you set a password to protect the document from opening and,...
Which two of the following are NOT required arguments of the HLOOKUP?
Alert!

Advertisement