Question

In a Pivottable on the "Projects by State" worksheet, retrieve the grand total estimate amount for projects in Montana. Retrieve the data for the remaining states to complete this section.

a) Sort the data by state and sum the estimates.

b) Filter the data for Montana and sum the estimates.

c) Use a forμla to calculate the grand total for all states.

d) Retrieve the data for Montana only and sum the estimates.

Answer 1

To retrieve the grand total estimate amount for projects in Montana from a PivotTable, follow these steps: (1) Sort and sum the estimates by state, (2) Filter the data for Montana and sum the estimates, (3) Use a formula to calculate the grand total for all states, (4) Retrieve the data for Montana only and sum the estimates.

Step-by-step explanation:

To retrieve the grand total estimate amount for projects in Montana from a PivotTable on the 'Projects by State' worksheet, follow these steps:

1. Sort the data by state and sum the estimates.
2. Filter the data for Montana and sum the estimates.
3. Use a formula to calculate the grand total for all states.
4. Retrieve the data for Montana only and sum the estimates.