Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel module 1 creating a worksheet and a chart

08/01/2021 Client: saad24vbs Deadline: 24 Hours

Shelly Cashman Excel 2016 | Module 1: SAM Project 1a


Blooming Everywhere Delivery CREATING A WORKSHEET AND A CHART


GETTING STARTED


• Open the file SC_EX16_1a_FirstLastName_1.xlsx, available for download from the SAM website.


• Save the file as SC_EX16_1a_FirstLastName_2.xlsx by changing the “1” to a “2”.


o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.


• With the file SC_EX16_1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.


o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.


PROJECT STEPS


1. Bob is the co-owner of Blooming Everywhere Delivery, a floral delivery service accessed exclusively through mobile apps, and is preparing a report for his business partner on the company’s financials for the years 2018-2020.


Open the Company Analysis worksheet and use AutoFit to adjust the width of column A.


2. Select cell A1, enter the text Blooming Everywhere Delivery, and then center the merged range A1:D1.


3. Apply the Heading 1 cell style to the merged range A1:D1.


4. Enter the text Revenue in cell A2, and then merge and center the range A2:D2.


5. Clear the contents of cell E3.


6. Enter the data shown in Table 1 below into the range B7:D7.


Table 1: Data for the Range B7:D7


Cell B7 C7 D7


Value 1800 1950 2020


Shelly Cashman Excel 2016 | Module 1: SAM Project 1a


7. Using the Fill Handle, copy the formula in cell B8 into the range C8:D8.


8. Merge and center the range A10:D10.


9. Select the range B12:D16, and then apply the Accounting number format with two decimal places and $ as the symbol.


10. The Expenses table shows all of the company’s expenses from 2018 to 2020. Bob wants to calculate the total expenses by adding up the total expenses from each year.


In cell E16, create a formula using the SUM function to calculate the total expenses from 2018 to 2020 (B16:D16).


11. Update the formatting of the merged range A18:D18 as described below:


a. Bold the contents of the merged range.


b. Change the font to Calibri.


c. Change the font size to 13 pt.


d. Change the font color to Green, Accent 6, Darker 25% (10th column, 5th row of the Theme Colors palette).


12. The company’s competition and taxes have increased through the years, and Bob will only recommend continuing to grow the business if the profit increases every year.


In cell B20 create a formula without using a function that calculates the profit earned in 2018 by subtracting the total expenses in 2018 (cell B16) from the total revenue in 2018 (cell B8).


Using the Fill Handle, fill the range C20:D20 with the formula from cell B20.


13. Change the tab color of the Company Analysis worksheet to Orange (3rd column, 1st row of the Standard Colors palette).


14. Select the clustered column chart with the title Blooming Everywhere Delivery 2018 – 2020 Revenue. Update the chart as described below:


a. Change the chart style of the clustered column chart to Style 5.


b. Move the chart to its own chart sheet. Use 2018-2020 Revenue as the name for the new chart sheet.


15. Switch back to the Company Analysis worksheet. Select the non-adjacent ranges A12:A15 and D12:D15, and then create a 3-D Pie chart. Update the chart as described below:


a. In the title placeholder, enter Expenses in 2020 as the chart title.


b. Change the chart style of the 3-D pie chart to Style 3.


c. Move the chart to its own chart sheet, using 2020 Expenses as the name for the new chart sheet.


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.


Shelly Cashman Excel 2016 | Module 1: SAM Project 1a


Final Figure 1: Company Analysis Worksheet


Final Figure 2: 2018-2020 Revenue Worksheet


Shelly Cashman Excel 2016 | Module 1: SAM Project 1a


Final Figure 3: 2020 Expenses Worksheet

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quick Mentor
Best Coursework Help
Homework Guru
Coursework Assignment Help
Helping Hand
Writer Writer Name Offer Chat
Quick Mentor

ONLINE

Quick Mentor

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$55 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$62 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$55 Chat With Writer
Helping Hand

ONLINE

Helping Hand

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism as I am a master writer with 5 years experience in similar ps and research writing projects. Kindly send me more information about your project. You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$55 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Strategic perspective of compensation - Sven hedin my life as an explorer - Space exploration through the social science lens - Peter thieriot - Colloidal silver ppm meter - Direct financing lease vs sales type - Chemistry all around us - U.S. Health Care Systems for Small Populations, Part 1 - CT3 - Today i am grateful for - Cisco 1941 end of life - Openvellum ecollege - MKT/435 WEEK 3 - In the zzzz best case, barry minkow was charged with: - Jacob's ladder toy explained - Chapter 1 foundations of information systems in business - Entering the academic conversation - 520 fe - What to do with missing data in spss - How much does a sonic franchise make - Discussions and Assignmnt. - Problems in the World Today - What is self reference criterion - Political context of othello - Understanding the business side of healthcare - Concepts of database management 8th edition chapter 5 answers - Relyx ceramic primer instructions - I tituba black witch of salem chapter 1 summary - Th by month)Filter by: initial post Something went wrong Try to reload widget. If the problem persists, please contact us at semrush-email@semrush.com dmaic report example - 1910 sears catalog buying credit folly - Multiplicity of an einstein solid - Dc motor characteristics ppt - Ephesians 3 14 21 nlt - Ch3cl polar or nonpolar - 560- POST AND RESPONSES DB-4 - Ikea self service concept - Haine and smith tetbury - POLSCI 499L Paper - What will a patient from the mexican culture explain to the nurse as the cause of an illness? - Forensic tools that can examine mac ipod and iphone - Judge capella bronx part rules - Case analysis help - Single system design - Essay for English - Hot bed in horticulture - Maximo meter based pm - I'm not scared niccolo ammaniti - Course Research Project part 3 - Writing assignment - Food and nutrition a level syllabus - Sticks and stones and other student essays 8th edition - The newsroom america is not the greatest - Arya samaj rig veda - Cue club 2 cheats - Apps det wa edu au dest - Balance sheet in good form sample - How to get professional assignment proofreading in Canada - Fedex harmonized code list - I was never yours blair holden read online - Underbelly characters real life - 6 page summary paper (in your own words) on Chapters 1, 2, 3, 4 of textbook "Health Policymaking in the United States - Holes read and respond - Wages expense vs salaries expense - Beowulf where does grendel live - Ktea 3 academic skills battery - Ids 100 project 3 presentation space exploration - Plumbing symbols used in working drawings - Spellingcity com hang mouse - Position paper introduction example - Utas word count penalty - Lse phd economics requirements - Math 59 Questions - Lord of the flies pig head - Research Project Assignment-Public Budgeting and Finance - Le chatelier's principle lab worksheet answers - Hamilton mercury air instructions - Www crescentbakerysurgery nhs uk - Year 7 history ancient china - Reflection paper on human relations - Found voices - Narrative Essay Rough Draft (SLO#1-8) - Karla tanner opens a web consulting business income statement - Hia standard building contract victoria - How psychologists do research worksheet answers - Air preheater efficiency calculation - Long term strategic objectives - CRISPR ASSIGNMENT - Www outofservice com bigfive big five - Florida institute of technology mechanical engineering faculty - Classify each pollutant based on the category that best describes its impact on waterways. - Cognitive development interview questions - Objective writing - When you have 5 minutes to whip up a powerpoint - Direct and indirect sunlight seasons - Risk management pmp ppt - Pdf principles and characteristics of forensic accounting - IT Strategy and Project Management - Iowa waste reduction center - Why are ethics considered so important when studying organizational behavior - Southampton vts planned movements