Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam

SettingsSettings
Please wait...
  • 1/24 Questions

    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
Please wait...
Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam - Quiz
About This Quiz

.


Quiz Preview

  • 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...

    Correct Answer
    A. Data Validation…
  • 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

    Correct Answer
    A. Iterative calculations
  • 4. 

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

    • True

    • False

    Correct Answer
    A. True
  • 5. 

    What are containers for storing VBA code?

    • Procedures

    • Class objects

    • Modules

    • Standard Objects

    • Methods

    Correct Answer
    A. Modules
  • 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

    Correct Answer
    A. True
  • 7. 

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

    • True

    • False

    Correct Answer
    A. True
  • 8. 

    Where would you enable the Developer Tab?

    • Home tab

    • Options

    • Right-click the ribbon

    • REGEDIT

    • Status Bar

    Correct Answer
    A. Options
  • 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

    Correct Answer
    A. Shared 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')

    Correct Answer
    A. =SUM('Sales Data.xlsx'!Quarter1)
  • 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…

    Correct Answer
    A. Edit Links…
  • 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!

    Correct Answer
    A. #VAR! #CONSTANT!
  • 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.

    Correct Answer
    A. Referencing the same 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

    Correct Answer
    A. 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

    Correct Answer
    A. Trace Dependents
  • 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

    Correct Answer
    A. Data Analysis Expression DAX
  • 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.

    Correct Answer
    A. Blank cells in datasets to separate columns.
  • 18. 

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

    • .pdf

    • .txt

    • .xls

    • .xps

    • .jpg

    Correct Answer
    A. .jpg
  • 19. 

    Which one of the following is NOT a form control?

    • Combo Box

    • Label

    • Group Box

    • Multiple Choice Box

    • Spin Button

    Correct Answer
    A. Multiple Choice Box
  • 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

    Correct Answer
    A. Vector
  • 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 .

    Correct Answer
    A. Save As dialog box
  • 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

    Correct Answer
    A. 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

    Correct Answer(s)
    A. Range_lookup
    A. Column_index_number
  • 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.

    Correct Answer
    A. Comments on the Sheet tab in the Page Setup dialog box.

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
Back to Top Back to top
Advertisement