Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

When you want to see all the data in a filtered table you can ____________________ or remove the filters.

Accepted Answer

The answer of When you want to see all the...

Question 3

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person place or thing.

Accepted Answer

The answer of Each column in a range represents a(n)____________________...

Question 4

Using Excel you can ____.

Accepted Answer

A)  store data
B)  retrieve subsets of data
C)  create reports
D)  all of the aboveE) C) and D)
F) B) and D)

Question 5

Match between columns
                        Premises: To temporarily hide all the records that do not meet your criteria

Accepted Answer

The Answer of filter and sort and table and data is...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  selection
B)  filtering
C)  custom
D)  queryE) A) and D)
F) B) and D)

Question 8

Item ____ in the accompanying figure indicates a field used to filter the report by selecting one or more items enabling you to display a subset of data in a PivotTable report.

Accepted Answer

A)  1
B)  2
C)  3
D)  4E) C) and D)
F) A) and B)

Question 9

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

Accepted Answer

A)  QuickCorrect
B)  AutoSort
C)  Quick Filter
D)  AutoCorrect OptionsE) All of the above
F) A) and B)

Question 10

The header row must be row 1.

Accepted Answer

A) True 
 B)False

Question 11

Excel provides ____ predefined custom sort lists.

Accepted Answer

A)  three
B)  four
C)  six
D)  sevenE) A) and B)
F) A) and C)

Question 12

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

Accepted Answer

A)  OR
B)  NAND
C)  AND
D)  IFE) B) and C)
F) A) and B)

Question 13

Match between columns
                        Premises: Indicates the sequence in which you want data ordered

Accepted Answer

The Answer of criteria filter and freeze and data definition is...

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  Current Date
B)  This Date
C)  This
D)  TodayE) All of the above
F) B) and C)

Question 17

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

Accepted Answer

The answer of The benefit of a(n)____________________ is that it...

Question 18

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

Accepted Answer

A)  operator
B)  criterion
C)  handle
D)  pivot pointE) A) and D)
F) A) and C)

Question 19

You can sort by ____.

Accepted Answer

A)  cell color
B)  font color
C)  cell icon
D)  all of the aboveE) A) and B)
F) B) and C)

Question 20

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

Accepted Answer

A)  Design
B)  Home
C)  Insert
D)  ViewE) C) and D)
F) B) and D)

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

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

Correct Answer
verified

When you want to see all the data in a filtered table you can ____________________ or remove the filters.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person place or thing.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

Correct Answer
verified

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

The header row must be row 1.

Correct Answer
verified

Excel provides ____ predefined custom sort lists.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Item ____ in the accompanying figure indicates a field used to filter the report by selecting one or more items enabling you to display a subset of data in a PivotTable report.

Correct Answer
verified

You can sort by ____.

Correct Answer
verified

Using Excel you can ____.

Correct Answer
verified

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

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

Correct AnswerverifiedShow Answer

When you want to see all the data in a filtered table you can ____________________ or remove the filters.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person place or thing.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

Correct AnswerverifiedShow Answer

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

The header row must be row 1.

Correct AnswerverifiedShow Answer

Excel provides ____ predefined custom sort lists.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Item ____ in the accompanying figure indicates a field used to filter the report by selecting one or more items enabling you to display a subset of data in a PivotTable report.

Correct AnswerverifiedShow Answer

You can sort by ____.

Correct AnswerverifiedShow Answer

Using Excel you can ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified