Microsoft Excel 2016 Part 2 Pre/Post Assessment Exam

1. Which is NOT a valid cell name?

Cell Name1

CellName1

Cell_Name

Cell_Name_1

2. What is a trendline?

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

The algorithm Excel 2016 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.

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

Trendlines

Charts

Category / Value Axis'

Elements

CubeSet

4. 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.

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

True

False

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

Grouping

Inserting

Placing

Combining

Nesting

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

Control + Shift + Enter

Control + Enter

Alt + Shift + Enter

Alt + Enter

Control + Shift + Alt + Enter

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

=TODAY(Date)

=TODAY()

=TODAY(05/05/2016)

=TODAY(A1)

=TODAY(A1:B2)

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

True

False

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

GREATER THAN

OR

NOT

AND

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

SUBSETS

LOOKUP

SEARCH

SUBTOTAL

VALUE

12. 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.

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

Subtotals

Indentation

Outdent

Collapse / Expand

Outline

14. 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.

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

SUMIF

COUNTIF

OFFSET

SUMIFS

SUBTOTAL

16. Where would you find, and be able to use, all of the functions available to Excel 2016 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.

17. 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

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

PIVOTDATA

SUMPIVOTDATA

ANALYZEPVT

GETPIVOTDATA

ANALYZEPIVOTDATA

19. 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.

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

DATETIME

Timeline

Chronological Filter

Quantum Analysis

ISOWEEKNUM

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.

22. The default calculation method in Excel 2016 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

23. 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

24. 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

25. What is an array?

A range of cells highlighted in Excel 2016.

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 2016.