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

Question 1

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.

Answer 1

True

Question 2

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.

Answer 2

True

Question 3

Records have been filtered in the list shown in the accompanying figure.

Answer 3

True

Question 4

Before you complete a sort you need to decide whether you want to put the list in ascending or descending order.

Question 5

You can create at most one Excel table in a worksheet.

Question 6

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

Question 7

You can change the values within the PivotTable because the PivotTable is linked to the source data.

Question 8

When you clear a filter all filters in the worksheet are cleared.

Question 9

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

Question 10

To show items hidden in a PivotTable you click the field arrow button and check the check box for the item you want to show.

Question 11

When you delete a record from a table a dialog box displays to confirm the delete operation

Question 12

You click a filter arrow to open the Filter menu for a field.

Question 13

When you create a table if your data does not contain column headers Excel adds headers with default names.

Question 14

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

Question 15

Excel can summarize data in a range of data by inserting subtotals.

Question 16

The header row must be row 1.

Question 17

If a column consists of day or month labels you can sort them in their correct chronological order using one of the predefined custom lists.

Question 18

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons

Question 19

If you freeze the top row in a worksheet and press Ctrl+Home you will return to the cell directly above the frozen row.

Question 20

To rearrange records in a list you sort based on the data in one or more of the fields.

Question 21

The row of field names across the top of an Excel list is referred to as the header row.

Question 22

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

Question 23

The fields you use to order the data in a list are sort fields.

Question 24

You click the item marked 3 in the accompanying figure to display rows that meet either of two criteria.

Question 25

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

Question 26

The Summary command automatically inserts a subtotal line into the list for each group of data in the list.

Question 27

If a column consists of day or month labels you can sort them in their correct chronological order using one of the predefined custom lists.

Question 28

Each column in a range represents a record that describes some attribute or characteristic of a person place or thing.

Question 29

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.

Question 30

You click the item marked 4 in the accompanying figure to display rows that meet both criteria.

Question 31

Press ____ to return to cell A1 in a worksheet.

A)Ctrl+Home
B)Ctrl+Esc
C)F1
D)Alt+Esc

Question 32

Table names cannot include underscores .

Question 33

When the Subtotals feature "outlines" your worksheet by default the highest level is active.

Question 34

Using Excel you can ____.

A)store data
B)retrieve subsets of data
C)create reports
D)all of the above

Question 35

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

A)boldface
B)change the font of
C)use a different color for
D)any of the above

Question 36

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

A)structure
B)definition
C)map
D)linked

Question 37

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

Question 38

In Excel a collection of similar data can be structured in a(n)____ of rows and columns.

A)index
B)glossary
C)list
D)range

Question 39

Ascending order arranges labels alphabetically from A to Z.

Question 40

You can display or hide filter arrows for an Excel table or a range of data by using the Filter button in the Sort & Filter group on the View tab.

Question 41

To create a table click the ____ tab on the Ribbon and then in the Tables group click the Table button.

A)Design
B)Home
C)Insert
D)View

Question 42

To add a sort field in the Sort dialog box click the ____ button.

A)Add Level
B)Add Field
C)New Sort Field
D)New Level

Question 43

The item marked 1 in the accompanying figure is the ____ button.

A)QuickCorrect
B)AutoSort
C)Quick Filter
D)AutoCorrect Options

Question 44

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

A)dark horizontal and vertical lines
B)marquees
C)different font colors
D)hyperlinks

Question 45

Excel assigns the name ____ to the first Excel table created in a workbook.

A)1
B)1Table
C)NewTable
D)Table1

Question 46

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

A)Filtering
B)Formatting
C)Editing
D)Text

Question 47

The item marked 2 in the accompanying figure is the ____ handle.

A)adjustment
B)sizing
C)AutoSum
D)Total

Question 48

A table can include all of the following EXCEPT ____

A)numbers
B)spaces
C)underscores
D)letters

Question 49

Which of the following is NOT a valid table name?

A)New_table
B)Table2
C)_Newtable
D)2Table

Question 50

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

A)Reverse
B)Major
C)Ascending
D)Descending

Question 51

In Excel a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

A)rows and headers
B)grids and columns
C)rows and columns
D)footers and grids

Question 52

The fields you use to order your data are called sort ____.

A)values
B)fields
C)tags
D)tools

Question 53

You can sort by ____.

A)cell color
B)font color
C)cell icon
D)all of the above

Question 54

As you type in a cell ____ displays any existing entry in the column that matches the characters you typed.

A)QuickFix
B)AutoComplete
C)Column Checker
D)AutoFill

Question 55

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

A)Hiding
B)Freezing
C)Showing
D)Sealing

Question 56

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box and checking the ____ check box.

A)Exact match
B)Match entire cell contents
C)Complete cell
D)Precise match to entire cell

Question 57

When you designate a range as a(n)____ Excel provides the same operations as are available for a structured range of data.

A)table
B)catalogue
C)index
D)roster

Question 58

To sort data in an Excel worksheet you can use the ____.

A)Sort A to Z and Sort Z to A buttons
B)QuickSort options
C)Sort command on the Formulas tab
D)Any of the above

Question 59

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

A)Shift
B)Tab
C)Esc
D)Alt

Question 60

You can use up to ____ sort fields in a single sort.

A)12
B)24
C)32
D)64

Question 61

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

A)Top 10
B)Between
C)Aggregate
D)Range

Question 62

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

A)Does Not Have
B)Is Not
C)Does Not Match
D)Does Not Contain

Question 63

The ____ criteria filter requires the records displayed to have the current date.

A)Current Date
B)This Date
C)This
D)Today

Question 64

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

A)Bottom 10
B)Top 10
C)Custom
D)All

Question 65

The ____ option buttons in the Custom AutoFilter dialog box are used if you want to display rows and columns that meet two conditions for the field.

A)And and Not
B)If and Then
C)And and Or
D)If and While

Question 66

The ____ criteria filter requires the records displayed to start with the specified text string.

A)Origin
B)Begins With
C)Initial
D)Start

Question 67

To delete a sort field in the Sort dialog box click the ____ button.

A)Remove Level
B)Delete Level
C)Descend Level
D)Delete Field

Question 68

In the accompanying figure Installation Sculpture and Textile are all part of the list of ____ options.

A)selection
B)filtering
C)custom
D)query

Question 69

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

A)OR
B)NAND
C)AND
D)IF

Question 70

You use ____ filters to find all objects with a value greater than X or acquired after a certain date.

A)custom
B)criteria
C)index
D)pivot

Question 71

The ____ condition requires that only one of the selected criteria be true for a record to be displayed.

A)NAND
B)OR
C)AND
D)IF

Question 72

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

A)Category
B)View
C)Data
D)Home

Question 73

The ____ list box in the Custom AutoFilter dialog box lets you specify the field value by typing a value or selecting an item from a list.

A)criteria
B)field value
C)operator
D)name value

Question 74

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

A)April May June
B)March April May
C)May June July
D)March April May June

Question 75

After data is filtered you can do all of the following EXCEPT ____ it.

A)sort
B)expunge
C)copy
D)chart

Question 76

You can filter a column of data by all of the following EXCEPT ____.

A)its PivotTable attribute
B)its cell colors
C)a specific date filter
D)by selecting one or more of the exact values by which you want to filter in the column

Question 77

Criteria filters allow you to specify relationships other than those that are "____" the criteria specified in the filter records.

A)in
B)like
C)greater than
D)equal to

Question 78

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

A)Has
B)Is
C)Contains
D)Matches

Question 79

Excel provides ____ predefined custom sort lists.

A)three
B)four
C)six
D)seven

Question 80

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

A)Year to Date
B)Today
C)Current
D)None of the above