Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam

1. What is a reference, either direct or indirect, that points to the cell containing the reference?

Invalid reference

Circular reference

Logic error

Inconsistent formula

Structured reference

2. Which dialog box will allow you to restrict data as Whole numbers, to a certain Text length, or as a List of items?

Consolidate…

Text to Columns…

Scenario Manager...

Data Validation…

Data Table...

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?

Repetitive calculations

Iterative calculations

Circular references

Iterative references

Responsive calculations

4. True or False? A two-variable data table may have more that two variables.

True

False

5. What are containers for storing VBA code?

Procedures

Class objects

Modules

Standard Objects

Methods

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.

True

False

7. True or False? The Document Inspector can remove all Personal Information, Hidden worksheets containing PivotTables, and Links to Other Files.

True

False

8. Where would you enable the Developer Tab?

Home tab

Options

Right-click the ribbon

REGEDIT

Status Bar

9. What feature enable multiple users to make changes to multiple workbooks and then merge the workbooks into one workbook.

Shared Workbook

Tracked Workbook

Collaborated Workbook

Merged Workbook

3-D Workbook

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.

=SUM(Sales Data.xlsx!Quarter1)

=SUM(Sales Data.xlsx!Sheet1!C7:C13)

=SUM(SalesData.xlsx!Quarter1)

=SUM('Sales Data.xlsx'!Quarter1)

=SUM(Quarter1!'Sales Data.xlsx')

11. If a link is broken in an external worksheet, what must you click to repair the link?

Repair Links…

Edit Links…

Links Checker…

Save As…

Relink…

12. There are seven major type of errors in Excel 2016. Which one of the following is not errors in Excel 2016?

#DIV/0!

#NULL!#VALUE?

#N/A!#NUM!

#VAR!#CONSTANT!

#VALUE!#REF!

13. What is 3-D referencing?

Calculating using the CUBE functions.

Referencing the same cells across a range of worksheets.

Inserting 3-D images in worksheet.

Referencing the same cells across a range of workbooks.

Referencing different cells across a range of worksheets.

14. In what hidden workbook do you store Macros for use in other workbooks?

Macros workbook

Hidden Workbook

VBA Workbook

DIY Workbook

Personal Workbook

15. Which tool will not help you to see where your formula's raw data originated?

Error Checking

Trace Precedents

Trace Dependents

Show Formulas

Evaluate Formula

16. In PowerPivot, what tool is used to populate columns by aggregating data?

Data Analysis Expression DAX

Point of Power POP

Power Differential Features PDF

PowerPivot Evaluation Mathematical Differential Action Server PEMDAS

FILTERXML

17. If you want your workbook to be "508 compliant", which is not an option might you choose?

Alternative text for objects and images.

Blank cells in datasets to separate columns.

Meaningful hyperlink text.

Unique tab name and no blank worksheets.

Closed captioning.

18. Which is not a valid format to which you can save an Excel workbook?

.pdf

.txt

.xls

.xps

.jpg

19. Which one of the following is NOT a form control?

Combo Box

Label

Group Box

Multiple Choice Box

Spin Button

20. In Excel 2016, what is a data range that consist of either a single row or single column of populated cells?

Array

Sparkline

Raster

Vector

Form

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?

Save As dialog box

Encrypt with password on the Protect Workbook button in the Info category on the File menu.

Advanced category on the Options menu on the File menu

Protect Workbook in the Changes group on the Review tab.

Protect and Share Workbook in the Changes group on the Review tab .

22. What is the Dialog box named that allows you to summarize data from multiple sources, even if the number of rows is inconsistent?

Summarize Dialog Box

Subtotals Dialog Box

Data Validation Dialog Box

Expansion Packs Dialog Box

Consolidate Dialog Box

23. Which two of the following are NOT required arguments of the HLOOKUP?

Range_lookup

Row_index_number

Column_index_number

Table_array

Lookup_value

Submit

24. Where would you enable a comment so it will print?

Show All Comments command in the Comments group on the Review tab.

Print Comments command in the Page Setup group on the Page Layout tab.

Advanced category form the Option menu on the File tab.

Comments on the Sheet tab in the Page Setup dialog box.

Comments can not be printed.

Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam

1. What is a reference, either direct or indirect, that points to the cell containing the reference?

2.

What first name or nickname would you like us to use?

2. Which dialog box will allow you to restrict data as Whole numbers, to a certain Text length, or as a List of items?

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?

4. True or False? A two-variable data table may have more that two variables.

5. What are containers for storing VBA code?

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.

7. True or False? The Document Inspector can remove all Personal Information, Hidden worksheets containing PivotTables, and Links to Other Files.

8. Where would you enable the Developer Tab?

9. What feature enable multiple users to make changes to multiple workbooks and then merge the workbooks into one workbook.

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.

11. If a link is broken in an external worksheet, what must you click to repair the link?

12. There are seven major type of errors in Excel 2016. Which one of the following is not errors in Excel 2016?

13. What is 3-D referencing?

14. In what hidden workbook do you store Macros for use in other workbooks?

15. Which tool will not help you to see where your formula's raw data originated?

16. In PowerPivot, what tool is used to populate columns by aggregating data?

17. If you want your workbook to be "508 compliant", which is not an option might you choose?

18. Which is not a valid format to which you can save an Excel workbook?

19. Which one of the following is NOT a form control?

20. In Excel 2016, what is a data range that consist of either a single row or single column of populated cells?

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?

22. What is the Dialog box named that allows you to summarize data from multiple sources, even if the number of rows is inconsistent?

23. Which two of the following are NOT required arguments of the HLOOKUP?

24. Where would you enable a comment so it will print?