Manipulating a Pivot Table in a Delivery Variance Report

Question Title

* 1. What is your name? (First, Last)

Question Title

* 2. What is your Role?

Question Title

* 3. What is your location?

Question Title

* 4. Which of the below postal codes does NOT belong to AGCO Corporation?

L9R 1V2

N0B 1A0

T4V 3T5

H1J 2V7

Question Title

* 5. Under which tab will you find the option to create a Pivot Table in a new sheet?

Insert

Data

Page Layout

View

Question Title

* 6. Which of the following is NOT a box in the Pivot Table Fields List

Rows

Values

Rates

Filters

Question Title

* 7. For the carrier "Loomis Express", what is the count of "assigned" in the "third leg status"?

98

115

243

76

Question Title

* 8. Set your field up with "shipper name" under rows and "Receiver State" under Values and Columns. Which of the following images is correct?

Question Title

* 9. What are the proper steps to creating a Pivot Table?

Select a cell in the range of data you want to summarize

Under Insert select Pivot Table.

Confirm the range of data and select "ok"

Select a cell in the range of data you want to summarize

Under Insert select Pivot Table.

Confirm the range of data and select "ok"

Question Title

* 10. If you add new data to the original worksheet you must click "refresh all" to update the Pivot Table in the separate worksheet.

True

False