Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam

Please wait...
Question 1 / 24
0 %
0/100
Score 0/100
1. What is a reference, either direct or indirect, that points to the cell containing the reference?
Submit
Please wait...
About This Quiz
Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam - Quiz

.

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

Advertisement