Microsoft Excel 2019 Part 3 Pre/Post Assessment Exam Question Title * 1. Please confirm your contact information: Name * Company ZIP/Postal Code * Email Address * Phone Number Question Title * 2. What best describes your role? I am an IT professional responsible for supporting the organization and IT services. I am an HR professional responsible for employee engagement and development. I am a manager or leader helping the organization grow, both in personnel and strategy. I am active duty or retired military dedicated to keeping my skills current. I am unemployed looking to brush up on skills for my next career. I am currently employed looking to move ahead in my career with training and certifications. Question Title * 3. 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. Question Title * 4. 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 Question Title * 5. Which one of the following is NOT a form control? Combo Box Label Group Box Multiple Choice Box Spin Button Question Title * 6. 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 Question Title * 7. In what hidden workbook do you store Macros for use in other workbooks? Macros workbook Hidden Workbook VBA Workbook DIY Workbook Personal Workbook Question Title * 8. In Excel, what is a data range that consist of either a single row or single column of populated cells? Array Sparkline Raster Vector Form Question Title * 9. 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 Question Title * 10. True or False? A two-variable data table may have more that two variables. True False Question Title * 11. What are containers for storing VBA code? Procedures Class objects Modules Standard Objects Methods Question Title * 12. Where would you enable the Developer Tab? Home tab Options Right-click the ribbon REGEDIT Status Bar Question Title * 13. 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 Question Title * 14. 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') Question Title * 15. 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… Question Title * 16. 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 Question Title * 17. 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 Question Title * 18. Which two of the following are NOT required arguments of the HLOOKUP? range_lookup row_index_number column_index_number table_array lookup_value Question Title * 19. 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 Question Title * 20. 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. Question Title * 21. Which is not a valid format to which you can save an Excel workbook? .pdf .txt .xls .xps .jpg Question Title * 22. 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. Question Title * 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? 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 . Question Title * 24. True or False? The Document Inspector can remove all Personal Information, Hidden worksheets containing PivotTables, and Links to Other Files. True False Question Title * 25. 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... Question Title * 26. There are seven major type of errors in Excel. Which one of the following is not errors in Excel? #DIV/0! #NULL! #VALUE? #N/A! #NUM! #VAR! #CONSTANT! #VALUE! #REF! Done