Question Title

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

Question Title

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

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 use to enclose the arguments?

Question Title

6. What object in an Excel 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'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 features are backwards compatible.

Question Title

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

Question Title

14. Excel is an XML based format that allows Excel 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 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 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, 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.

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