Excel Data Analysis with Pivot Tables

Excel Data Analysis with Pivot Tables

Time limit: 0

Quiz Summary

0 of 12 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 12 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12

Current
Review
Answered
Correct
Incorrect

Question 1 of 12

1. Question

Which of the following is NOT true about PivotTable source data?

Data must have unique column headings

Data can be on different sheets

Data must be in Excel

Data should not have summaries or subtotals

Correct

Incorrect
Question 2 of 12

2. Question

What must be done in order to use multiple tables in a Data Model?

Set up a Data Connection

Create a relationship between tables

Use the Recommended PivotTables option

Create the PivotTable on a new worksheet

Correct

Incorrect
Question 3 of 12

3. Question

What is NOT a method for adding or removing fields on a PivotTable?

Use the checkbox beside the field name

Drag the field to or from the corresponding location

Type or delete the field name in the desired location

Correct

Incorrect
Question 4 of 12

4. Question

What is the default location for a PivotTable?

New worksheet

New workbook

Existing worksheet

New window

Correct

Incorrect
Question 5 of 12

5. Question

Which dialog box allows you to change the summary function?

Insert Formulas

Value Field Settings

Show Values

Function Arguments

Correct

Incorrect
Question 6 of 12

6. Question

Which of the following will NOT filter the PivotTable?

Report filter

Slicer

Drill down

Timeline

Correct

Incorrect
Question 7 of 12

7. Question

To which area can you add a field multiple times?

Filter

Column

Row

Value

Correct

Incorrect
Question 8 of 12

8. Question

Which of the following statements is true about the PivotTable design?

You cannot remove the Grand Totals

You can move the Subtotals

You can insert table columns

You cannot modify the styles

Correct

Incorrect
Question 9 of 12

9. Question

Double clicking a data cell in a PivotTable does which of the following?

Shows source data for that cell in a separate table

Filters the PivotTable to show source data for the cell

Shows the original source data sheet in a table format

Creates a new sheet with a filtered PivotTable

Correct

Incorrect
Question 10 of 12

10. Question

Which of the following is true about updating PivotTable data?

When you change the source data the PivotTable will automatically update

You must edit the data in the data source and directly in the PivotTable

Once a PivotTable is created, the data cannot be updated

You can set the PivotTable to refresh the data manually or automatically

Correct

Incorrect
Question 11 of 12

11. Question

Why would you use the option to Show Report Filter Pages?

To see how you are currently filtering the PivotTable

To create additional PivotTables filtered by a Report Filter field

To copy source data to a new table filtered by the Report Filter field

To view additional options for filtering the PivotTable

Correct

Incorrect
Question 12 of 12

12. Question

A PivotChart must be on the same sheet as the PivotTable.

True

False

Correct

Incorrect

ATS eLearning

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.