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 2016 module 11 sam project 1a

28/10/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:

Instant Homework Helper
Top Writing Guru
Solutions Store
Top Class Results
Calculation Master
Financial Assignments
Writer Writer Name Offer Chat
Instant Homework Helper

ONLINE

Instant Homework Helper

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$17 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

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.

$48 Chat With Writer
Solutions Store

ONLINE

Solutions Store

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.

$16 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$19 Chat With Writer
Calculation Master

ONLINE

Calculation Master

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

$26 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

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.

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

Call me ishmael some years ago - I want to be australian superwog - 2009 dodge nitro spark plug wire order - Hayward ecostar sp3400vsp pump stalled - Bucking bronco urban dictionary - Suppose the following bond quote for iou corporation - Research and evaluation in counseling erford pdf - Descriptive statistics in nursing - As/nzs 3500.5 free download - Thermal decomposition of potassium chlorate - Hno3 + koh ionic equation - Compare and contrast two mental health theories - Project work breakdown structures and coding systems - Aurasa2002 apply safe working practices in an automotive workplace answers - Certificate 4 in plumbing - Discussion 7 - Interviewing principles and practices 15th edition pdf free - Jamaica has a comparative advantage in the production of - Jamba juice cups for sale - John deere steel plow - Goal setting by margaret hockett answers - Job requirement matrix template - Karen horney our inner conflicts pdf - Building vocabulary: angiosperm reproduction - Perdue farms case study - Www ustaxcourt gov electronic_access htm - Trade support loan eligibility - What does macduff do in macbeth - Business and law - How long is an extended response - E.v - Signature assignment environmental scan paper - Negative and positive rules - Three types of survivorship curves - Short mood and feelings questionnaire - Wiring schematic symbols chart - Certificate iv in professional writing and editing rmit - Hematologic Disorder - Chap 2 and 3 assignment - Care of the Aging Population on Global Health - Dorothea orem contributions to nursing - 6 3 1 reflection assignment - Consider the following decision tree - Strategic Plan, Part 3: Strategic Evaluation - Portfolio Assignment: The Role of the Nurse Informaticist in Systems Development and Implementation - Poststructuralism in international relations - How to find lcm using euclidean algorithm - Design an ERP Solution with Emerging Technologies - Cheerleader tryout at coach's house - Deliverable 5 - Corporate Social Responsibility Presentation Power Point Presentation/ with Speaker Notes - POSOLOGY - Saum song bo - Film Analysis - PLUGGED IN - Total internal reflection project - Tanx 1 cotx cotx 1 tanx 1 tanx cotx - Information systems infrastructure evolution and trends articles - Mitel 5320e ip phone quick reference guide - Racial and ethnic groups 15th edition schaefer pdf - How to bend a 3 point saddle - How to measure customer profitability - Marianne moore the paper nautilus - Galvanic cell experiment lab report - BUS 322 Week 3 Assignment 1 What Makes ____ the Best Place to Work and Why? - Report SEC 10-K - A wall of fire rising - Sam capstone project 1a - 10_Imoprtance of strategic IT planning - Maths genie surds answers - I need 2-3 pages assessment in Human Resource Management - Thesis statement on fake news - Unsuccessful job application email - Composition of potassium chlorate lab answers - Cisco switch configuration commands ppt - Week 11 Assignment - Privilege power and difference chapter 7 summary - List of all conversion factors - Vital Signs - (DQ) Biz News - Place! - Unholy Blades Company: Crafting Exquisite Custom Handmade Damascus Knives - What does credo mean in english - Www counton org games - Practice with Commentary - Good will hunting psychological disorder - Nasopharyngeal Swab Education for COVID-19 - Add voiceover to prezi - Video database program - Ego Integrity Presentation - Bright star if i were as steadfast - Bsbmgt502 - City west water new connection - Titration gizmo answer key - Myitlab excel chapter 12 grader project - WEEK7-Final Portfolio Project-Data Science & Big Data Analy - Assignment 3 - How to install arulesviz package in r - 4 page assignment must be ORIGINAL or will not PAY!!! Follow instructions care fully - Hendrick hudson v rowley case brief - Physiotherapy frimley park hospital - What is a salon in history - What is the fundamental niche of chthamalus