I need help with question 6 given and prepare the worksheet for Excel by the data of customers. Also, please explain or provide the steps of how to do those questions in the new worksheet of Excel.
I need help with question 6 given and prepare the worksheet for Excel by the data of customers. Also, please explain or provide the steps of how to do those questions in the new worksheet of Excel.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
I need help with question 6 given and prepare the worksheet for Excel by the data of customers. Also, please explain or provide the steps of how to do those questions in the new worksheet of Excel.
![O VIEW
Instructions_SC_EX19_8a (2) Protected View Saved to this PC
Page 2 of 11
Insert Draw Design Layout
References Mailings Review
View Help
Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
TION CANCELLED On Sunday, December 25, 2022, most features of Word will be disabled.
6.
1439 words
65°F
Clear
.
Text Predictions: On
7.
a.
Reactivate
Marina also wants to insert a PivotTable that includes other Customer information so
that she can analyze Family plan customer data. Return to the Customers worksheet,
and then create a PivotTable based on the Customers table as follows:
b.
C.
d.
e.
Search (Alt+Q)
8.
Place the PivotTable on a new worksheet, and then use Customers Pivot as the
name of the worksheet.
Display the order location as column headings.
Display the state field and then the customer field as row headings.
Display the years as the values.
Display the plan type as a filter, and then filter the Pivotlable to display customer
information for Family plans only.
f.
Hide the field headers to reduce clutter in the Pivot Table.
Go to the Orders worksheet. The Order_Summary table in the range G4:J15 shows the
sales for three categories of mobile device orders, with each category divided into types
and then into models. Marina wants to display these hierarchies of information in a
chart.
Shelly Cashman Excel 2019 | Module 8: SAM Project la
Enable Editing
a.
CENGAGE
Insert a Sunburst chart to display the hierarchies for Marina as follows:
Insert a Sunburst chart based on the mobile device order data in the range
G4:315.
b.
Resize and position the chart so that it covers the range G16:K34.
C.
Use Mobile Device Orders as the chart title.
Go to the Customers by Plan worksheet, which contains a Pivot Table showing the
Focus
DA
Jeffrey Wang
Co](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb7b9bc12-9bec-475d-bc99-e13d2a9b76e2%2F81125e91-1fd4-4acb-992f-db3ec946ba19%2Fdjhmes_processed.jpeg&w=3840&q=75)
Transcribed Image Text:O VIEW
Instructions_SC_EX19_8a (2) Protected View Saved to this PC
Page 2 of 11
Insert Draw Design Layout
References Mailings Review
View Help
Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
TION CANCELLED On Sunday, December 25, 2022, most features of Word will be disabled.
6.
1439 words
65°F
Clear
.
Text Predictions: On
7.
a.
Reactivate
Marina also wants to insert a PivotTable that includes other Customer information so
that she can analyze Family plan customer data. Return to the Customers worksheet,
and then create a PivotTable based on the Customers table as follows:
b.
C.
d.
e.
Search (Alt+Q)
8.
Place the PivotTable on a new worksheet, and then use Customers Pivot as the
name of the worksheet.
Display the order location as column headings.
Display the state field and then the customer field as row headings.
Display the years as the values.
Display the plan type as a filter, and then filter the Pivotlable to display customer
information for Family plans only.
f.
Hide the field headers to reduce clutter in the Pivot Table.
Go to the Orders worksheet. The Order_Summary table in the range G4:J15 shows the
sales for three categories of mobile device orders, with each category divided into types
and then into models. Marina wants to display these hierarchies of information in a
chart.
Shelly Cashman Excel 2019 | Module 8: SAM Project la
Enable Editing
a.
CENGAGE
Insert a Sunburst chart to display the hierarchies for Marina as follows:
Insert a Sunburst chart based on the mobile device order data in the range
G4:315.
b.
Resize and position the chart so that it covers the range G16:K34.
C.
Use Mobile Device Orders as the chart title.
Go to the Customers by Plan worksheet, which contains a Pivot Table showing the
Focus
DA
Jeffrey Wang
Co
![File Home Insert Draw Page Layout Formulas Data
Pivot Table Recommended Table
Pivot Tables
A4
3
4
5
6
7
8
9
10
11
12
13
14
15
Add-ins
i SUBSCRIPTION CANCELLED On Sunday, December 25, 2022, most features of Excel will be disabled.
Customer-
5010
5015
5019
5020
5023
5025
5027
5029
5031
5033
5037
5039
16
17
18
19
20
21
22
23
24
nr
Tables
4
Ready
LADAY
5102
5104
5106
5108
5110
5112
65°F
Clear
B
Years
4
2
1
3
5
6
4
7
2
3
1
1
3
2
4
6
6
Illustrations
5
4
Customer
3
5114
5116
PLAD
... Plans
Accessibility: Investigate
C
State
DC
NC
DE
DC
NC
MD
DC
VA
DE
VA
DE
VA
MD
DC
NC
Get Add-ins
D
My Add-ins
V
IN1
UN3
UN2
BA3
FA2
S11
UN3
UN2
FA3
FA2
BA3
UN1
FU
DC
VA
MD
DC
VA
Payments by State Pivot Sheet2
E
15
Plan ID
BA2
FA2
FA3
UN2
FA1 Family
S11
UN2
FA3
Mobile Phone Customers
# of Lines
# of Lines
Plan
Plan Type
Type
Review View
b?
Recommended
Charts
Basic
Family
Family
Unlimited
Single
Unlimited
Family
International
Unlimited
Unlimited
Basic
Family
Single
Unlimited
Unlimited
Family
Family
Basic
Unlimited
Customers
F
Q
2
3
6
2
2
1
2
6
1
5
2
4
3
1
1
5
2
6
3
4
1
Orders
Help
DE-A-
dh
XX
V
V
Table Design
V
-
Charts
G
Reactivate
Order Location
Online
Online
EM store
Online
Phone store
Online
Phone store
Online
EM store
Online
Online
Online
EM store
Phone store
Online
Online
EM store
Maps PivotChart
-
H
Payment
$60.00
$120.00
$240.00
$130.00
$80.00
$45.00
$130.00
$240.00
$60.00
$325.00
$130.00
√
de ţ felle poo
Line Column Win/
Loss
Tours
$120.00
$120.00
$45.00
$325.00
$130.00
$240.00
Phone store
$120.00
Phone store
Online
Customers by Plan Sales Pivot Location Pivot
$120.00
$65.00
enn an
J
+
Sparklines
K
ar
Slicer Timeline
L
Filters
HI
M
Link
Links
N
Commen
Comments
0
1211](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb7b9bc12-9bec-475d-bc99-e13d2a9b76e2%2F81125e91-1fd4-4acb-992f-db3ec946ba19%2F2l9da9m_processed.jpeg&w=3840&q=75)
Transcribed Image Text:File Home Insert Draw Page Layout Formulas Data
Pivot Table Recommended Table
Pivot Tables
A4
3
4
5
6
7
8
9
10
11
12
13
14
15
Add-ins
i SUBSCRIPTION CANCELLED On Sunday, December 25, 2022, most features of Excel will be disabled.
Customer-
5010
5015
5019
5020
5023
5025
5027
5029
5031
5033
5037
5039
16
17
18
19
20
21
22
23
24
nr
Tables
4
Ready
LADAY
5102
5104
5106
5108
5110
5112
65°F
Clear
B
Years
4
2
1
3
5
6
4
7
2
3
1
1
3
2
4
6
6
Illustrations
5
4
Customer
3
5114
5116
PLAD
... Plans
Accessibility: Investigate
C
State
DC
NC
DE
DC
NC
MD
DC
VA
DE
VA
DE
VA
MD
DC
NC
Get Add-ins
D
My Add-ins
V
IN1
UN3
UN2
BA3
FA2
S11
UN3
UN2
FA3
FA2
BA3
UN1
FU
DC
VA
MD
DC
VA
Payments by State Pivot Sheet2
E
15
Plan ID
BA2
FA2
FA3
UN2
FA1 Family
S11
UN2
FA3
Mobile Phone Customers
# of Lines
# of Lines
Plan
Plan Type
Type
Review View
b?
Recommended
Charts
Basic
Family
Family
Unlimited
Single
Unlimited
Family
International
Unlimited
Unlimited
Basic
Family
Single
Unlimited
Unlimited
Family
Family
Basic
Unlimited
Customers
F
Q
2
3
6
2
2
1
2
6
1
5
2
4
3
1
1
5
2
6
3
4
1
Orders
Help
DE-A-
dh
XX
V
V
Table Design
V
-
Charts
G
Reactivate
Order Location
Online
Online
EM store
Online
Phone store
Online
Phone store
Online
EM store
Online
Online
Online
EM store
Phone store
Online
Online
EM store
Maps PivotChart
-
H
Payment
$60.00
$120.00
$240.00
$130.00
$80.00
$45.00
$130.00
$240.00
$60.00
$325.00
$130.00
√
de ţ felle poo
Line Column Win/
Loss
Tours
$120.00
$120.00
$45.00
$325.00
$130.00
$240.00
Phone store
$120.00
Phone store
Online
Customers by Plan Sales Pivot Location Pivot
$120.00
$65.00
enn an
J
+
Sparklines
K
ar
Slicer Timeline
L
Filters
HI
M
Link
Links
N
Commen
Comments
0
1211
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 10 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.