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

Critical Thinking Case-Based Questions Case 5-3 As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?

(Multiple Choice)

4.7/5

(45)

Question 21

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion. ____________________

(True/False)

4.8/5

(30)

Question 22

By default, the PivotTable report uses the ____ function for numbers in the Values area.

(Multiple Choice)

4.8/5

(32)

Question 23

The entry 20000 is the ____________________ for the first condition.

(Short Answer)

4.8/5

(34)

Question 24

____ order arranges labels in reverse alphabetical order, from A to Z

(Multiple Choice)

4.9/5

(46)

Question 25

Table names cannot include underscores . ____________________

(True/False)

4.7/5

(37)

Question 26

A table name cannot include ____.

(Multiple Choice)

4.7/5

(39)

Question 27

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.

(Short Answer)

4.7/5

(34)

Question 28

____ order arranges labels in reverse alphabetical order, from Z to A.

(Multiple Choice)

4.9/5

(36)

Question 29

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

(Multiple Choice)

4.8/5

(33)

Question 30

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet one of the criteria.

(Multiple Choice)

4.9/5

(40)

Question 31

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

(Multiple Choice)

4.9/5

(30)

Question 32

If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.

(True/False)

4.8/5

(35)

Question 33

You can split the worksheet window into ____ separate panes.

(Multiple Choice)

4.9/5

(29)

Question 34

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

(Short Answer)

4.9/5

(31)

Question 35

You can use a table's sizing handle to add columns or rows to a table.

(True/False)

4.8/5

(31)

Question 36

Case-Based Critical Thinking Questions Case 5-1 You are a student who is new to the more advanced features of Excel. You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?

(Multiple Choice)

5.0/5

(33)

Question 37

When you click in each cell in the Total row, a(n)____ appears that you can click to open a list of the most commonly used functions.

(Multiple Choice)

4.7/5

(38)

Question 38

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

(Multiple Choice)

4.9/5

(26)

Question 39

The first sort field in a sort is called the major sort field. ____________________

(True/False)

4.9/5

(33)

Question 40

Showing 21 - 40 of 75

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion. ____________________

By default, the PivotTable report uses the ____ function for numbers in the Values area.

The entry 20000 is the ____________________ for the first condition.

____ order arranges labels in reverse alphabetical order, from A to Z

Table names cannot include underscores . ____________________

A table name cannot include ____.

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.

____ order arranges labels in reverse alphabetical order, from Z to A.

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet one of the criteria.

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.

You can split the worksheet window into ____ separate panes.

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

You can use a table's sizing handle to add columns or rows to a table.

When you click in each cell in the Total row, a(n)____ appears that you can click to open a list of the most commonly used functions.

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

The first sort field in a sort is called the major sort field. ____________________

Access 1: Creating Advanced Queries and Enhancing Table Design

Access 2: Using Form Tools and Creating Custom Forms

Access 3: Creating Custom Reports

Access 4: Sharing Integrating and Analyzing Data

Excel 2: Managing Multiple Worksheets and Workbooks

Excel 3: Developing an Excel Application

Excel 4: Working With Advanced Functions

Powerpoint 1: Applying Advanced Formatting to Objects

Powerpoint 2: Advanced Animations and Distributing Presentations

Productivity Apps for School and Work Angel

Word 1: Working With Templates Themes and Styles

Word 2: Using Mail Merge

Word 3: Collaborating With Others and Integrating Data

Filters