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

Shelly cashman excel 2016 module 3 sam project 1a

22/11/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:

Top Writing Guru
Unique Academic Solutions
Math Exam Success
Finance Master
24/7 Assignment Help
Innovative Writer
Writer Writer Name Offer Chat
Top Writing Guru

ONLINE

Top Writing Guru

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$25 Chat With Writer
Unique Academic Solutions

ONLINE

Unique Academic Solutions

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$28 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$31 Chat With Writer
Finance Master

ONLINE

Finance Master

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$26 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$43 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

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

Photoelectric smoke sensor arduino - Auxiliary fuel tank electric pump - Fayol's 14 principles of management ppt - Which quotation shows that appearances do not always reflect reality - What is st christina the patron saint of - Urban remedy macro bowl costco - 4 question criminal justice - IWOCDQ1 - How do repressive regimes interact with civil society - Prepare a schedule of cost of goods manufactured - Social work case studies foundation year 2013 pdf - 49ers season tickets price - Tlp logixpro simulator software download - Charity organization society today - Most successful rugby union team - Beowulf translated by seamus heaney pdf - Submission file format: Word document with all the answers, clearly identifying all steps, results, and including comments besides each answer. - Worksheet on electronic configuration - The following categories are on a classified balance sheet - Rats in the ranks documentary - 23 PPA 400 WORDS APA POST - Updated for week 7 and 8 - Lección 4 contextos describir audio - Discussion on the “Develop a broad vision, an architecture, and a detailed plan of action that follows a life cycle concept” - Checking account and debit card simulation - Owl writing the basic business letter - What is xl and xc in physics - Designing the training program in hrm - Sankey diagram for a hair dryer - Global business policies temple university - ABsignifacance_of_study - Ewles and simnett model - Hendon prep term dates - Cys6paper - Audi a4 b6 cruise control coding - What is the management research question hierarchy - How far is venus from the sun in km - Connected mcgraw hill com lesson 3 - Electrical Safety - Order 2436104: Student Code of Conduct - Glass ladder and co marilyn mini - Ielts speaking band descriptors - The fill volume of an automated filling machine - Gen 499 week 1 assignment - Differentiate between oxidizing agent and reducing agent - How long did the frankish empire last - NURSING CONCEPT SUBSTANCE ABUSE - Blood brothers act 1 scene 1 - I should have been a pair of ragged claws meaning - How many ml in a small styrofoam cup - Bdo belgar right answer - Farewell to manzanar chapter 4 pdf - Weighted average number of shares outstanding - Bsbwor502 lead and manage team effectiveness assessment answer - How to build bridges with friends - Virtual water quality lab - Price is right tube top incident unedited - The energizer bunny slogan - Ethics in Accounting - Third person biography example - All or none law - Mg car club newcastle - Is geronimo a slur - Book Review of "Parcels by Mike Anastario" - Con este aparato appliance puedes ver películas - Boq com au internet banking - Finite difference vs finite volume - Ernie dances to the didgeridoo youtube - Discussion Forum Week 5: economies of scale - Process Recording - Self driving cars informative speech - Gordon rush geoffrey leather chelsea boot - Characteristics of a faithful disciple - Duraglas milk bottle dating - Iicl exam sample questions - The Challenge: Communication, Criticism and Discipline, Leadership, Motivation, Rules and Policies - Social Process Theories - Whoever marries a divorced woman commits adultery - Cost accounting case studies with solutions - Activity 1 bony landmark analysis answers - Gcse biology revision notes pdf 9 1 - Sun protection policy child care - Project report - Aon hewitt graduate scheme - Significant landscape overlay schedule 23 - Textbook of ayurveda pdf - Week 1 for jessica - The parable of the sadhu - Calculate the molar mass of baking soda - Analyzing and Visualizing Data - Hundred flowers slaughter confusing a gentleman's heart - Farewell to manzanar short summary - Paradise corporation budgets on an annual basis - Aspirin or acetylsalicylic acid is synthesized by reacting - Curtis v chemical cleaning - Arnold prank calls drunk guy - Computer Science, Disaster Recovery Plan: Types of Testing - Social Work Assignment: Project: Agency Visit Paper - Graduate Education Assistance - Mkt630 DQ3