Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. Go to the Projects by State worksheet. Hwan has created a PivotTable on this worksheet to list projects by state, start date, and category.

image text in transcribed 9. Go to the Projects by State worksheet. Hwan has created a PivotTable on this worksheet to list projects by state, start date, and category. Refresh the PivotTable so it displays the changes you made to the Category data on the Projects worksheet. 10. Reduce the clutter in the PivotTable by modifying it as follows: a. Change the report layout to show the PivotTable in Outline Form. b. Group the Project Start values by Months. 11. Hwan occasionally would like to focus on the project data according to the start date. Add a Timeline Slicer as follows to the Projects by State worksheet: a. Insert a Timeline Slicer based on the Project Start field. b. Move and resize the Timeline Slicer so it covers the range A34:F40. c. Adjust the Timeline Slicer to view all months

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trucking Industry IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304135640, 978-1304135643

More Books

Students also viewed these Accounting questions