FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Exce: Working With Excel Tables Pivottables and Pivotcharts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

A) Expansion
B) Outline
C) Summary
D) Function

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Ascending order arranges labels alphabetically from A to Z.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

You can format cells in a PivotTable the same way as you do cells in the worksheet

You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names.

When you filter your data all records that do not meet your criteria are temporarily hidden from view.

You can use the ____ tab to change the SUM function to a different summary function in a PivotTable.

To freeze a row select the cell below the row(s)you want to freeze click the ____________________ button in the Window group and then click Freeze Top Row.

You can point to any style in a gallery to see a ____ of the PivotTable with that style applied.

The item marked 2 in the accompanying figure is the ____ for the first condition.

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

The PivotTable Field List enables you to change or pivot the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

After Excel displays an existing entry in the column that matches the characters you typed press the ____ key to accept the entry.

Identify the letter of the choice that best matches the phrase or definition.

A data ____ table describes the fields you plan to maintain in a table.

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

The item marked 5 in the accompanying figure is a box for specifying a second condition for the ____________________.

Identify the letter of the choice that best matches the phrase or definition.

The ____ filtering option displays the top or bottom n items in a list.

Excel displays ____ to indicate which rows and columns are frozen.

The QuickFix button shown in the accompanying figure enables you to undo table formatting if for example you had not intended new data to be part of an existing table.