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

Black and decker corporation case study - Can c&h recover the liquidated damages from sun ship - Crofton and sharlston medical practice - Custom dlp policy office 365 - Worksafe victoria job safety analysis worksheet - Why were athletes originally given olive wreaths as a reward - The tools of formal analysis help us to - Discussion: RESPONSE - NEED IN 12 HOURS or LESS PLAGIARISM FREE - The prodiscover utility makes use of the proprietary _______________ file format. - Sun microsystems products and services - Research Paper - Aruba clearpass ordering guide - Roland tan tong meng - Can i get a powerpoint presentation done by the end of today sept 27th 2020 the scope of the assignment is listed below - St josephine bakhita mississauga mass times - Nhs london leadership academy - Urinary Disorders - My choice children's homes - Actron air am24 1 - Factor tree of 40 - Do flatworms have a closed circulatory system - Discussion (350 words) - The logical problem of evil - Lois kerschen romeo and juliet - Create a scenario summary report excel 2013 - Sandvik 621 loader specs - Coraline chapter 3 summary - We mortals are but shadows and dust - For the following questions determine the blood type being tested - Star wars clone wars planetary forces game - Atomic theory development timeline - Elements of a fairy tale graphic organizer - Initiating the Project-10 - Sample codebook for content analysis - Discussion: Philosophy of Science - Hydraulic - Standardization of 0.1 m sodium hydroxide - Pan europa foods case study answers - Layers of the earth model - Capitec bank balance enquiry - Priority nursing diagnosis for renal failure - ENG106_Proposal as a guest editorial - Celebrating diversity in early years - Orographic rainfall definition geography - Career development interventions 5th edition apa citation - Dissolving solid sodium hydroxide in water is exothermic or endothermic - Grams per litre to moles per litre - Timber skillion roof construction - Discussion Board - Use the data in gpa for this exercise - Chatty pink job - Week 2 - Security Architecture and Design - Project 1: Subnetting - Oxford brookes induction week - Need a project report and presentation - How to find p value on calculator ti 84 - Statistics - Discussion Question - Www look4them org uk - Elite dangerous mining engineering - Week - Greasy lake questions and answers - Is pos a gatekeeper or open access - Box hill tafe email - Composition and resolution of forces - Write a policy memo( (2,500-3,000 words) - Discuss how employee mobility differs from traditional upward mobility in organizations with alternative mobility paths (Exhibit 6.2). - Dragon age inquisition ritual puzzle - Customer service professional summary - Metro east web academy - Zin zin zin a violin reading rainbow - Need ASAP - 1.17 unit test working with data part 1 - Finanance and blockchain - Gorilla playing drums cadbury advert - Fun home graphic novel pdf - At what point does the curve have maximum curvature - 11 Paragraph Essay Due by midnight - Autoways prestige car sales - Blackpool council bulky matters - What should be included in child observation - Advantages and disadvantages of correlational research - Apc smart-ups rt 1000va 230v - probability - Which of the following has zero dipole moment - Biology animal kingdom notes - Annals of biomedical engineering format - Discussion - Research methods in the social sciences frankfort nachmias pdf - How to get phstat on excel - Wk8 discussion 6052 - Cushing ok wti spot price fob - Clayton hotel zhengzhou standard - Presentation on email and wifi policies - Coca cola trade secret case study - Download 100 tambola tickets free - Saddle stitcher sd 511 - Ethical teachings in the ten commandments - Discussion