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 sam project 2

04/12/2021 Client: muhammad11 Deadline: 2 Day

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:

Online Assignment Help
Assignments Hut
Top Class Engineers
Custom Coursework Service
Solutions Store
Professor Smith
Writer Writer Name Offer Chat
Online Assignment Help

ONLINE

Online Assignment Help

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$32 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$27 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$50 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$32 Chat With Writer
Solutions Store

ONLINE

Solutions Store

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$26 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$31 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

Word chapter 1 project 1a simulation training - 7 Principles of Healthcare - NUTRITION - Emperor of china jonathan spence - Neuton lawn mower battery - The naturals page count - Icd 10 code for tertiary hyperparathyroidism - Silver cross 3d system - The importance of format in a professional environment - Little piggy tattoo missing toe - Aseba youth self report - Audit materiality worksheet - CJ 2600 MOD 5 DB - I just wanna be average mike rose - D909o - Education as a social institution essay - Sociology question D9 - I need an essay written in APA format for a psych 130 class - How to calculate pooled variance for t test - Sal maris east liverpool menu - Australian taxation office gpo box 9845 brisbane - Family reunion event proposal - Halo spherical e14 28 35w bulb - Acme fine furniture brisbane - In achebe's things fall apart the oracle _____ - Why should we study film hum 150 - Biology practical questions and answers - Pamela reed's theory of self transcendence - Car - One nibble everyone knows the laws - Like Water for Chocolate movie review - Statistical inference casella berger solutions - Mysql workbench relationship symbols - 5 day hypertrophy program - 6.2 properties of parallelograms - How google search engine works ppt - The end of molasses classes sparknotes - Angewandte chemie impact factor - POWERPOINT PRESENTATION - Project 4 - Why do cheerleaders shrug their shoulders - International business question bank - Trevor noah it's my culture dvd - Eric worre 90 day blitz - Telstra go mobile plus byo plan - Http extensiononline tamu edu certificates audit php - Anglo saxon belt buckle - Services like stitch fix but cheaper - Need someone good in microeconomics class - Ib hl english essay example - Question - Stuart cundy surrey police - Collective noun for yachts - Advanced diploma of building surveying - Trial 1 meiotic division without crossing over pipe cleaners diagram - Activatecard com au tsa - Walt disney mission statement - Palmers planet westgate auckland - Neil ashe net worth - Literature review - Prentice hall web codes list - Swot analysis of jollibee - Dux prodigy pilot light - Math homework Online - The kite runner movie assef - CASES CASE 35 CIRQUE DU SOLEIL* The founder of Cirque du Soleil, Guy Laliberté, after see- ing the firm’s growth prospects wane in recent years, was thinking about expanding his firm in new directions. For three decades, the firm had reinvented and revolutionized the circus. From its beginning in 1984, Cirque de Soleil had thrilled over 150 million spectators with a novel show concept that was as original as it was nontraditional: an astonishing theatrical blend of circus acts and street enter- tainment, wrapped up in spectacular costumes and fairy- land sets and staged to spellbinding music and magical lighting. Cirque du Soleil’s business triumphs mirrored its high- flying aerial stunts, and it became a case study for business school journal articles on carving out unique markets. But following a recent bleak outlook report from a consultant, a spate of poorly received shows over the last few years, and a decline in profits, executives at Cirque said they were now restructuring a - Primary metric for six sigma projects - Society and culture pip guide - Beverly hills ninja palm tree scene song - Six sigma case study example cost reduction - TestOut Networking Pro - Advantages and disadvantages of epidiascope - Hang on sloopy dancer - Riverside bamboo market kyobashi - 4 bit asynchronous down counter using jk flip flop - In what cell organelle does cellular respiration take place - 10419 packard dr fishers in 46037 - Greatergood berkeley edu quizzes take quiz stress_and_anxiety - Aws policy evaluation logic - Career break letter template - Civil service written policy exercise - What does mod mean in medical terms - National geographic explorer magazine - Disadvantages of standardized terminology in nursing - Vicat apparatus initial setting time - Precede proceed model for health promotion planning and evaluation - Roof diaphragm design example - What inventory method does pepsico use - Abb pad mounted transformer - Quién toma fotos margarita ____ toma - Zara fast fashion harvard business school - Go absent without permission crossword clue - Taking a picture of robert the doll without permission - Week II Case study paper - Business and law - Pin fins vs straight fins - Cattell horn's two factor theory 1966 - Kirby drop in refrigeration units - Behaviour change wheel model - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI