Question Title

* 1. Please confirm your contact information:

Question Title

* 4. What feature in Excel enables users to organize datasets into hierarchical groups?

Question Title

* 5. Which is NOT a valid cell name?

Question Title

* 6. Which of the following is the correct syntax for the TODAY function?

Question Title

* 7. Which of the following is NOT a LOGICAL FUNCTION?

Question Title

* 8. Once you have sorted a table in Ascending order, how do you remove the sort?

Question Title

* 9. You have sorted three columns in sequence. Which one is the primary sort.

Question Title

* 10. To perform and advanced filter, what is one of the two items that needs to be defined in the Advanced Filter dialog box?

Question Title

* 11. True or False? You can identify database functions because the function names are preceded by the letter D.

Question Title

* 12. What function set allows you to perform calculations on subsets of data?

Question Title

* 13. What is a trendline?

Question Title

* 14. What is an array?

Question Title

* 15. What key-stroke combination is required to create an array?

Question Title

* 16. What is a graphical representation of numerical values and relationships in a dataset?

Question Title

* 17. What is a PivotTable?

Question Title

* 18. PivotTable work best with Transactional Data. What is Transactional Data?

Question Title

* 19. True or False? A PivotTable works best when there are no duplicates in any column.

Question Title

* 20. Which function allows you to generate a summary from a PivotTable and place it elsewhere in a worksheet?

Question Title

* 21. Which feature allows you to filter by any date entries in a PivotTable?

Question Title

* 22. You have selected a range of cells across multiples and would like to name each column by it's column label name. Which command would you use?

Question Title

* 23. You are using the Formula AutoComplete to write your functions. Name a method you can use to enter the function or named range into the cell?

Question Title

* 24. The default calculation method in Excel is to Automatically calculate the work book. What other four options are available?

Question Title

* 25. Where would you find, and be able to use, all of the functions available to Excel in one dialog box?

Question Title

* 26. What function adds all of its arguments that meet multiple criteria?

Question Title

* 27. In Excel, what is the term used when placing a function or formula inside of another function or formula?

Question Title

* 28. True or False? To change the data of a chart, you must delete the chart and reinsert it using it's saved Template.

T