Question Title

* 1. Please confirm your contact information:

Question Title

* 2. What best describes your role?

Question Title

* 3. What feature on the ribbon allows you to type into a search box to find particular ribbon commands?

Question Title

* 4. What is a cell, or ranges of cells, referred to when the reference to that cell does not change when moving or copying a formula from one cell to another?

Question Title

* 5. Most functions have arguments. What characters does Excel 2016 use to enclose the arguments?

Question Title

* 6. What object in an Excel 2016 spreadsheet do you input, store, and manipulate data?

Question Title

* 7. What are individual pieces of information about workbook files that can help you search for and identify particular workbook files?

Question Title

* 8. What Microsoft Office feature allows a user to temporarily preview formatting before applying the formatting?

Question Title

* 9. What feature automatically recognizes patterns across row as data is entered and then fills the pattern down a column??

Question Title

* 10. What is Excel 2016's primary task?

Question Title

* 11. Which of the following is the correct answer to this equation? = 2 + 8 / 4 * 3

Question Title

* 12. True or False? All of Excel 2016 features are backwards compatible.

Question Title

* 13. True of False? An excel workbook can have a maximum of 255 worksheets.

Question Title

* 14. Excel 2016 is an XML based format that allows Excel 2016 to compress files when you close them. How much compression is possible?

Question Title

* 15. What feature allows you to copy or fill a series by clicking and dragging the bottom right corner of a cell?

Question Title

* 16. The Clear command, on the Home tab in the Editing group, has all of these commands except one. What is NOT on the Clear command?

Question Title

* 17. True or False? Excel 2016 can reference cells within its worksheet, from another worksheet, and from another worksheet in a different workbook.

Question Title

* 18. Which one of the following is NOT a valid operator in the Excel 2016 environment?

Question Title

* 19. Which reference operator tells Excel to look for a value in the cell where two ranges intersect?

Question Title

* 20. Which of the following is not a way to resize a column?

Question Title

* 21. In Excel 2016, which one of the following is NOT an option in the Find and Replace dialog box?

Question Title

* 22. Which feature would you use when you want to select all of the blank cells within your selection?

Question Title

* 23. True or False? You cannot add another dictionary to Excel 2016.

Question Title

* 24. Which Microsoft Office feature allows you to click on a cell, click the feature, and then apply that formatting to another cell or range of cells?

Question Title

* 25. Which one of the following is NOT a Number Format category?

Question Title

* 26. The Page Setup dialog allow you to do all of the following except which one?

Question Title

* 27. Which is a way that allows you to copy a worksheet to another position in a workbook?

T