Question 1

Item ____ in the accompanying figure indicates the fields you want to summarize.

Accepted Answer

A)  1
B)  2
C)  3
D)  4E) All of the above
F) None of the above

Question 2

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.

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Enables you to specify various conditions in addition to those that are based on an "equals" criterion

Accepted Answer

The Answer of freeze and field name and data definition is...

Question 4

Match between columns
                        Premises: Documentation that lists the fields to be maintained for each record

Accepted Answer

The Answer of filter and field name and table and is...

Question 5

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

Accepted Answer

A)  COUNT
B)  AVERAGE
C)  MIN
D)  SUME) B) and C)
F) A) and D)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Typically you want to sort by the numbers text or dates stored in the cells which are all ____________________.

Accepted Answer

The answer of Typically you want to sort by the...

Question 8

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

Accepted Answer

A)  sort
B)  expunge
C)  copy
D)  chartE) C) and D)
F) A) and B)

Question 9

Which of the following is NOT a valid table name?

Accepted Answer

A)  New_table
B)  Table2
C)  _Newtable
D)  2TableE) B) and C)
F) C) and D)

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

In PivotTable terminology the fields that you summarize are known as ____________________ fields.

Accepted Answer

The answer of In PivotTable terminology the fields that you...

Question 12

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

Accepted Answer

A)  QuickFix
B)  AutoComplete
C)  Column Checker
D)  AutoFillE) A) and D)
F) None of the above

Question 13

A table can include all of the following EXCEPT ____

Accepted Answer

A)  numbers
B)  spaces
C)  underscores
D)  lettersE) B) and C)
F) A) and D)

Question 14

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

Accepted Answer

A)  index
B)  glossary
C)  list
D)  rangeE) B) and C)
F) A) and D)

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: A range of related data managed independently from the data in other rows and columns in the worksheet

Accepted Answer

The Answer of custom list and field name and criteria is...

Question 18

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

Accepted Answer

A)  NAND
B)  OR
C)  AND
D)  IFE) All of the above
F) B) and D)

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

Accepted Answer

A)  Display Function
B)  Insert Function
C)  Add Function
D)  New FunctionE) None of the above
F) B) and C)

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

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

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

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

Correct Answer
verified

Item ____ in the accompanying figure indicates the fields you want to summarize.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

Correct Answer
verified

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

Correct Answer
verified

A table can include all of the following EXCEPT ____

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Which of the following is NOT a valid table name?

Correct Answer
verified

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.

Correct Answer
verified

Typically you want to sort by the numbers text or dates stored in the cells which are all ____________________.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

In PivotTable terminology the fields that you summarize are known as ____________________ fields.

Correct Answer
verified

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

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

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

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

Correct AnswerverifiedShow Answer

Item ____ in the accompanying figure indicates the fields you want to summarize.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table can include all of the following EXCEPT ____

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is NOT a valid table name?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Typically you want to sort by the numbers text or dates stored in the cells which are all ____________________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In PivotTable terminology the fields that you summarize are known as ____________________ fields.

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