Question Title

* 1. Please confirm your contact information:

Question Title

* 2. What best describes your role?

Question Title

* 3. What is 3-D referencing?

Question Title

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

Question Title

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

Question Title

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

Question Title

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

Question Title

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

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?

Question Title

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

Question Title

* 11. What are containers for storing VBA code?

Question Title

* 12. Where would you enable the Developer Tab?

Question Title

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

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.

Question Title

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

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?

Question Title

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

Question Title

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

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.

Question Title

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

Question Title

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

Question Title

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

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?

Question Title

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

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?

Question Title

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

T