Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam
.
- 1.
What is 3-D referencing?
- A.
Calculating using the CUBE functions.
- B.
Referencing the same cells across a range of worksheets.
- C.
Inserting 3-D images in worksheet.
- D.
Referencing the same cells across a range of workbooks.
- E.
Referencing different cells across a range of worksheets.
Correct Answer
B. Referencing the same cells across a range of worksheets. -
- 2.
What is a reference, either direct or indirect, that points to the cell containing the reference?
- A.
Invalid reference
- B.
Circular reference
- C.
Logic error
- D.
Inconsistent formula
- E.
Structured reference
Correct Answer
B. Circular reference -
- 3.
Which one of the following is NOT a form control?
- A.
Combo Box
- B.
Label
- C.
Group Box
- D.
Multiple Choice Box
- E.
Spin Button
Correct Answer
D. Multiple Choice Box -
- 4.
What feature enable multiple users to make changes to multiple workbooks and then merge the workbooks into one workbook.
- A.
Shared Workbook
- B.
Tracked Workbook
- C.
Collaborated Workbook
- D.
Merged Workbook
- E.
3-D Workbook
Correct Answer
A. Shared Workbook -
- 5.
In what hidden workbook do you store Macros for use in other workbooks?
- A.
Macros workbook
- B.
Hidden Workbook
- C.
VBA Workbook
- D.
DIY Workbook
- E.
Personal Workbook
Correct Answer
E. Personal Workbook -
- 6.
In Excel 2016, what is a data range that consist of either a single row or single column of populated cells?
- A.
Array
- B.
Sparkline
- C.
Raster
- D.
Vector
- E.
Form
Correct Answer
D. Vector -
- 7.
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?
- A.
Repetitive calculations
- B.
Iterative calculations
- C.
Circular references
- D.
Iterative references
- E.
Responsive calculations
Correct Answer
B. Iterative calculations -
- 8.
True or False? A two-variable data table may have more that two variables.
- A.
True
- B.
False
Correct Answer
A. True -
- 9.
What are containers for storing VBA code?
- A.
Procedures
- B.
Class objects
- C.
Modules
- D.
Standard Objects
- E.
Methods
Correct Answer
C. Modules -
- 10.
Where would you enable the Developer Tab?
- A.
Home tab
- B.
Options
- C.
Right-click the ribbon
- D.
REGEDIT
- E.
Status Bar
Correct Answer
B. Options -
- 11.
In PowerPivot, what tool is used to populate columns by aggregating data?
- A.
Data Analysis Expression DAX
- B.
Point of Power POP
- C.
Power Differential Features PDF
- D.
PowerPivot Evaluation Mathematical Differential Action Server PEMDAS
- E.
FILTERXML
Correct Answer
A. Data Analysis Expression DAX -
- 12.
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.
- A.
=SUM(Sales Data.xlsx!Quarter1)
- B.
=SUM(Sales Data.xlsx!Sheet1!C7:C13)
- C.
=SUM(SalesData.xlsx!Quarter1)
- D.
=SUM('Sales Data.xlsx'!Quarter1)
- E.
=SUM(Quarter1!'Sales Data.xlsx')
Correct Answer
D. =SUM('Sales Data.xlsx'!Quarter1) -
- 13.
If a link is broken in an external worksheet, what must you click to repair the link?
- A.
Repair Links…
- B.
Edit Links…
- C.
Links Checker…
- D.
Save As…
- E.
Relink…
Correct Answer
B. Edit Links… -
- 14.
What is the Dialog box named that allows you to summarize data from multiple sources, even if the number of rows is inconsistent?
- A.
Summarize Dialog Box
- B.
Subtotals Dialog Box
- C.
Data Validation Dialog Box
- D.
Expansion Packs Dialog Box
- E.
Consolidate Dialog Box
Correct Answer
E. Consolidate Dialog Box -
- 15.
Which tool will not help you to see where your formula's raw data originated?
- A.
Error Checking
- B.
Trace Precedents
- C.
Trace Dependents
- D.
Show Formulas
- E.
Evaluate Formula
Correct Answer
C. Trace Dependents -
- 16.
Which two of the following are NOT required arguments of the HLOOKUP?
- A.
Range_lookup
- B.
Row_index_number
- C.
Column_index_number
- D.
Table_array
- E.
Lookup_value
Correct Answer(s)
A. Range_lookup
C. Column_index_number -
- 17.
True or False? The Watch Window can evaluate formulas, within a worksheet, on different worksheets in a workbook, and between worksheets in different workbooks.
- A.
True
- B.
False
Correct Answer
A. True -
- 18.
Where would you enable a comment so it will print?
- A.
Show All Comments command in the Comments group on the Review tab.
- B.
Print Comments command in the Page Setup group on the Page Layout tab.
- C.
Advanced category form the Option menu on the File tab.
- D.
Comments on the Sheet tab in the Page Setup dialog box.
- E.
Comments can not be printed.
Correct Answer
D. Comments on the Sheet tab in the Page Setup dialog box. -
- 19.
Which is not a valid format to which you can save an Excel workbook?
- A.
.pdf
- B.
.txt
- C.
.xls
- D.
.xps
- E.
.jpg
Correct Answer
E. .jpg -
- 20.
If you want your workbook to be "508 compliant", which is not an option might you choose?
- A.
Alternative text for objects and images.
- B.
Blank cells in datasets to separate columns.
- C.
Meaningful hyperlink text.
- D.
Unique tab name and no blank worksheets.
- E.
Closed captioning.
Correct Answer
B. Blank cells in datasets to separate columns. -
- 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?
- A.
Save As dialog box
- B.
Encrypt with password on the Protect Workbook button in the Info category on the File menu.
- C.
Advanced category on the Options menu on the File menu
- D.
Protect Workbook in the Changes group on the Review tab.
- E.
Protect and Share Workbook in the Changes group on the Review tab .
Correct Answer
A. Save As dialog box -
- 22.
True or False? The Document Inspector can remove all Personal Information, Hidden worksheets containing PivotTables, and Links to Other Files.
- A.
True
- B.
False
Correct Answer
A. True -
- 23.
Which dialog box will allow you to restrict data as Whole numbers, to a certain Text length, or as a List of items?
- A.
Consolidate…
- B.
Text to Columns…
- C.
Scenario Manager...
- D.
Data Validation…
- E.
Data Table...
Correct Answer
D. Data Validation… -
- 24.
There are seven major type of errors in Excel 2016. Which one of the following is not errors in Excel 2016?
- A.
#DIV/0!
- B.
#NULL! #VALUE?
- C.
#N/A! #NUM!
- D.
#VAR! #CONSTANT!
- E.
#VALUE! #REF!
Correct Answer
D. #VAR! #CONSTANT! -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 09, 2020Quiz Edited by
ProProfs Editorial Team -
Jan 09, 2020Quiz Created by
Back to top