ADMN 368v1 Ch

.docx

School

University of British Columbia *

*We aren’t endorsed by this school

Course

368

Subject

Industrial Engineering

Date

Apr 3, 2024

Type

docx

Pages

110

Uploaded by mehaksanay

Report
Chapter 1 PivotTables and PivotCharts The course material shows one way to solve each of the challenges. Often, there are many possible approaches. Challenge 1: Washer and Dryer Data Set Part 1 You may view the finished file at Chapter 1 Resources>Completed Files>Washer and Dryer Data Set PART 1 COMPLETE at [. . .].xlsx. Part A 1. Insert the cursor anywhere in the data. Press Control and “T” simultaneously. Select “My table has headers.” Click OK.
2. Ensure the cursor is placed somewhere in the table (1). Select Table Design from the main menu if needed (2). In the Table Name box, insert “SalesData” (3).
3. Click and drag the cursor to select columns D, E, and F (1). Right-click and select Format Cells (2). Format the three columns as Number with zero decimal places (3) and with 1000s separator (4). Click OK (5).
The following Excel table results.
Part B 1. Right-click on the “a. Sales Data” worksheet tab and select Move or Copy> (move to end). Name the new worksheet “b. Sort by Make.” Name the table “SortByMake” (steps not shown). Select the sort icon in the Make header (1). Then sort all the data from A to Z (2). Ensure that all the makes are selected (3). Click OK (4).
This Excel table shows Make in alphabetical order (red box).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help