Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS