Microsoft Excel 2019 Part 2 Pre/Post Assessment Exam Survey

Question Title

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

Name *

Company

ZIP/Postal Code *

Email Address *

Phone Number

Question Title

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

Question Title

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

Subtotals

Indentation

Outdent

Collapse / Expand

Outline

Question Title

4. Which is NOT a valid cell name?

Cell Name1

CellName1

Cell_Name

Cell_Name_1

Question Title

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

=TODAY(Date)

=TODAY()

=TODAY(05/05/2016)

=TODAY(A1)

=TODAY(A1:B2)

Question Title

6. Which of the following is NOT a LOGICAL FUNCTION?

GREATER THAN

NOT

AND

Question Title

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

Click Clear Sort in the Sort command in the Sort & Filter group on the Data tab.

Right-click and choose Remove Sort.

Use the Undo command.

Save the workbook, close it and reopen it.

Sort another column.

Question Title

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

First column you sorted

Second column you sorted

Third column you sorted

None of the columns are sorted

You must use the Sort command to perform this task

Question Title

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

Cell Range

Worksheet Range

Named Range

List Range

Question Title

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

True

False

Question Title

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

SUBSETS

LOOKUP

SUBTOTAL

VALUE

Question Title

12. What is a trendline?

A graphical representation which follows the exact placement of data points.

The algorithm Excel uses when saving documents in 97-2003 format.

The line in a cell that represents a graphical representation of drifts (trends) or variations in a data series.

A line connecting data labels to their respective data points.

A line which conforms to a Company's Standards and Guidelines.

Question Title

13. What is an array?

A range of cells highlighted in Excel.

Multiple worksheets grouped together.

A visual depiction of values from a range of cells.

The individual values saved in a range of individual cells.

A range of data entered into a computer's memory and accessed by Excel.

Question Title

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

Control + Shift + Enter

Control + Enter

Alt + Shift + Enter

Alt + Enter

Control + Shift + Alt + Enter

Question Title

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

Trendlines

Charts

Category / Value Axis'

Elements

CubeSet

Question Title

16. What is a PivotTable?

An interactive table that summarizes, organizes, and compares large amounts of worksheet data.

A chart with embedded data which can be manipulated.

An Excel tool which allows you to pivot between a Word Table and an Excel spreadsheet.

A static table that summarizes, organizes, and compares large amounts of worksheet data.

An Excel element that allows you to filter data in a static worksheet.

Question Title

17. PivotTable work best with Transactional Data. What is Transactional Data?

Raw data that has been summarized.

Data with both column labels and row labels.

Summarized data with row labels.

Raw data with column labels.

Summarized data with column labels.

Question Title

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

True

False

Question Title

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

PIVOTDATA

SUMPIVOTDATA

ANALYZEPVT

GETPIVOTDATA

ANALYZEPIVOTDATA

Question Title

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

DATETIME

Timeline

Chronological Filter

Quantum Analysis

ISOWEEKNUM

Question Title

21. 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?

Define Name in the Defined Names group on the Formulas tab.

Use in Formula in the Defined Names group on the Formulas tab.

Name Manger in the Defined Names group on the Formulas tab.

Create from Selection in the Defined Names group on the Formulas tab.

Use Label Names in the Defined Names group on the Formulas tab.

Question Title

22. 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?

Click once on the function or named range.

Highlight the function or named range and press the Tab key.

Highlight the function or named range and press the Enter key.

Highlight the function or named range and press the right arrow key.

Question Title

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

Automatic Except for Data Tables

Manual

Calculate Now

Calculate on Save

Calculate Sheet

Question Title

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

More Functions in the Function Library group on the Formulas tab

More Functions in the Function Library group on the Data tab

Insert Function in the Function Library group on the Formulas tab

Insert Function in the Function Library group on the Data tab

Click Help and type Functions.

Question Title

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

SUMIF

COUNTIF

OFFSET

SUMIFS

SUBTOTAL

Question Title

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

Grouping

Inserting

Placing

Combining

Nesting

Question Title

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

True

False

Microsoft Excel 2019 Part 2 Pre/Post Assessment Exam

Question Title

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

Question Title

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

Question Title

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

Question Title

* 4. Which is NOT a valid cell name?

Question Title

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

Question Title

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

Question Title

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

Question Title

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

Question Title

* 9. 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

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

Question Title

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

Question Title

* 12. What is a trendline?

Question Title

* 13. What is an array?

Question Title

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

Question Title

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

Question Title

* 16. What is a PivotTable?

Question Title

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

Question Title

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

Question Title

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

Question Title

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

Question Title

* 21. 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

* 22. 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

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

Question Title

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

Question Title

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

Question Title

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

Question Title

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

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

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

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

4. Which is NOT a valid cell name?

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

6. Which of the following is NOT a LOGICAL FUNCTION?

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

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

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

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

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

12. What is a trendline?

13. What is an array?

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

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

16. What is a PivotTable?

17. PivotTable work best with Transactional Data. What is Transactional Data?

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

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

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

21. 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?

22. 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?

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

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

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

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

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