Question Title

1. Please confirm your contact information: (Required.)

Question Title

2. What best describes your role? (Required.)

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