Microsoft Excel 2019 Part 2 Pre/Post Assessment Exam Survey

Question Title

* 1. Please confirm your contact information:

Name *

Company

ZIP/Postal Code *

Email Address *

Phone Number

Question Title

* 2. What best describes your role?

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