14. Amir also wants to compare the estimated sales of January and June of next year. Insert a chart that provides this information as follows: a. b. C. Create a Clustered Column chart based on the nonadjacent ranges A21:825 and G21:G25. Enter Estimated Sales: Jan and June as the chart title. Resize and reposition the chart so that its upper-left corner is in cell A33 and its lower-right corner is in cell E45. d. Change the chart layout to Layout 5 to display a data table with the chart. Your workbook should look like the final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter13: Web Site Applications
Section: Chapter Questions
Problem 3E
icon
Related questions
Question
I need help questions # 14 to prepare and do the clustered column chart for the cells tables given and please show how to do the work for those in Excel.
File
AutoSave off SC EX19_3b_JeffreyWang_2
5.
e
d
Undo
A34
19
20
21
26
Home Insert
X
27
28
29
Paste
35
V
Clipboard
36
37
A
-
Service Category
22
Market research
$
23 Retail merchandising $
24 Product promotion $
25
$
Social marketing
Total
Ready
TN
Draw Page Layout Formulas
ν Α Α΄
Gill Sans MT
30
Amount
31
Net Amount
32 Net Commission%
33
34
BIU
U
X✓ fx
74°F
Sunny
$
B
$
$
Documentation
Accessibility: Investigate
v
4
January
Font
11
✓
78,000 $
58,500 $
January
81,000 $
52,000 $
269,500 $
V
Sales Report
V
4,581.50 $
1,970.05 $
43%
с
Data
IN
February
Review View Help
==
79,000 $
56,500 $
89,000 $
55,000 $
279,500 $
February
7,267.00 $
3,124.81 $
D
20
March
Y
€
ab
Alignment
80,000 $
50,000 $
90,000 $
56,000 $
276,000 $
O Search (Alt+Q)
Estimated Sales
April
Wrap Text
Merge & Center
March
7,176.00 $
3,085.68 $
E
Y
82,000 $
52,800 $
91,000 $
58,000 $
283,800 $
Estimated Commissions
April
7,378.80 $
3,172.88 $
General
$ % 9 508 00
M
F
May
Number
84,000 $
54,000 $
93,000 $
59,500 $
290,500 $
May
7,553.00 $
3,247.79 $
5
hp
G
June
Conditional Format as Cell
Formatting Table Styles
Styles
ME
June
7,839.00
3,370.77
H
85,500 $
61,000 $
95,000 $
60,000 $
301,500 $ 1,700,800
Total
488,500
332,800
539,000
340,500
Trend
$
$
€
X H
Insert Delete Format
M
m
Total
Cells
Avg. Clients
40
58
20
22
35
m
41,795.30
17,971.98
J
Projections
Jeffrey Wang JW
Σ 27
6
Sort & F
Filter Se
Editing
K
Transcribed Image Text:File AutoSave off SC EX19_3b_JeffreyWang_2 5. e d Undo A34 19 20 21 26 Home Insert X 27 28 29 Paste 35 V Clipboard 36 37 A - Service Category 22 Market research $ 23 Retail merchandising $ 24 Product promotion $ 25 $ Social marketing Total Ready TN Draw Page Layout Formulas ν Α Α΄ Gill Sans MT 30 Amount 31 Net Amount 32 Net Commission% 33 34 BIU U X✓ fx 74°F Sunny $ B $ $ Documentation Accessibility: Investigate v 4 January Font 11 ✓ 78,000 $ 58,500 $ January 81,000 $ 52,000 $ 269,500 $ V Sales Report V 4,581.50 $ 1,970.05 $ 43% с Data IN February Review View Help == 79,000 $ 56,500 $ 89,000 $ 55,000 $ 279,500 $ February 7,267.00 $ 3,124.81 $ D 20 March Y € ab Alignment 80,000 $ 50,000 $ 90,000 $ 56,000 $ 276,000 $ O Search (Alt+Q) Estimated Sales April Wrap Text Merge & Center March 7,176.00 $ 3,085.68 $ E Y 82,000 $ 52,800 $ 91,000 $ 58,000 $ 283,800 $ Estimated Commissions April 7,378.80 $ 3,172.88 $ General $ % 9 508 00 M F May Number 84,000 $ 54,000 $ 93,000 $ 59,500 $ 290,500 $ May 7,553.00 $ 3,247.79 $ 5 hp G June Conditional Format as Cell Formatting Table Styles Styles ME June 7,839.00 3,370.77 H 85,500 $ 61,000 $ 95,000 $ 60,000 $ 301,500 $ 1,700,800 Total 488,500 332,800 539,000 340,500 Trend $ $ € X H Insert Delete Format M m Total Cells Avg. Clients 40 58 20 22 35 m 41,795.30 17,971.98 J Projections Jeffrey Wang JW Σ 27 6 Sort & F Filter Se Editing K
AutoSave
Page 2 of 4
Instructions SC EX19 3b (1) Protected View Saved to this PC V
File Home Insert Draw Design Layout
References Mailings Review
View
Help
PROTECTED VIEW
Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
SUBSCRIPTION CANCELLED On Thursday, December 15, 2022, most features of Word will be disabled.
Reactivate
926 words Text Predictions: On
56°F
Cloudy
a.
Shelly Cashman Excel 2019 | Module 3: SAM Project lb.
14. Amir also wants to compare the estimated sales of January and June of next year. Insert
a chart that provides this information as follows:
b.
O Search (Alt+Q)
C.
Create a Clustered Column chart based on the nonadjacent ranges A21:825 and
G21:G25.
Enter Estimated Sales: Jan and June as the chart title.
Resize and reposition the chart so that its upper-left corner is in cell A33 and its
lower-right corner is in cell E45.
4+
Enable Editing
d.
Change the chart layout to Layout 5 to display a data table with the chart.
Your workbook should look like the Final Figures on the following pages. Save your changes,
close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your
completed project.
to 144
D-II
JAARVER
fio DDI
ins
M
Focus
68
Commer
6
Transcribed Image Text:AutoSave Page 2 of 4 Instructions SC EX19 3b (1) Protected View Saved to this PC V File Home Insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. SUBSCRIPTION CANCELLED On Thursday, December 15, 2022, most features of Word will be disabled. Reactivate 926 words Text Predictions: On 56°F Cloudy a. Shelly Cashman Excel 2019 | Module 3: SAM Project lb. 14. Amir also wants to compare the estimated sales of January and June of next year. Insert a chart that provides this information as follows: b. O Search (Alt+Q) C. Create a Clustered Column chart based on the nonadjacent ranges A21:825 and G21:G25. Enter Estimated Sales: Jan and June as the chart title. Resize and reposition the chart so that its upper-left corner is in cell A33 and its lower-right corner is in cell E45. 4+ Enable Editing d. Change the chart layout to Layout 5 to display a data table with the chart. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. to 144 D-II JAARVER fio DDI ins M Focus 68 Commer 6
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
Microsoft Windows 10 Comprehensive 2019
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning