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

Sam excel project

31/12/2020 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:

Top Essay Tutor
University Coursework Help
Helping Hand
Smart Accountants
A Grade Exams
Accounting Homework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$45 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$42 Chat With Writer
Helping Hand

ONLINE

Helping Hand

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.

$40 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

I feel, I am the best option for you to fulfill this project with 100% perfection. I am working in this industry since 2014 and I have served more than 1200 clients with a full amount of satisfaction.

$35 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

Hi, I have read the instructions carefully and I clearly understand what is required of the project. I always make sure I proofread and edit papers well to ensure they are free of typos, plagiarism, and grammar mistakes. Hire me for a timely delivery of a quality content.

$35 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

I can help you with your homework & assignments to get A grade. I have helped several students multiple fields such as marketing, SWOT, PESTEL, Finance, Law, Sociology and Psychology. I know how to structure and format content with different writing styles such as MLA, APA, & Harvard. Please try me once at least. You will be satisfied.

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

Week 5 - Identifying hazards in occupational environments ati - EP Wk3 - Post code new zealand - What is a statutory merger - Forster's market case study - Projecto o Dossier - Cambridge international examinations answers - David hume moral distinctions not derived from reason - John o groat journal acknowledgements - Prejudice in Psychology - Policy, Legal, Ethics and Cmplc - Network design proposal for school - Gentile's multidimensional classification system - Jack russell terrier club south africa - Fiu refworks - Research methods Discussion question 1 - Discussion: Restorative Justice as Treatment - Killing us softly 4 jean kilbourne full video - Robin williams 10 key values of us culture - 3x 6y 30 y 6x 34 - How do i critically evaluate something - Law extension committee past exam papers - Vik muniz american flag - Corporate social responsibility: OD Pactitioner - Irac example duty of care - What is dr seuss real name - Bac si huy richmond - Case Study Analysis - Ballarat arms and militaria collectors society - Final Project -Human Nutrition - Smithline reinforced composites llc - Organizational structure of domino's pizza - Resume writing assignment - Discussion post - Chase meadow health centre - Gerald corey theory and practice of counseling and psychotherapy pdf - 120 west 45th street suite 2700 new york ny 10036 - Week 1_Study Questions - Comparative cost analysis template - Mis primas son . marcus y yo somos . mi tía es - Smiley face braces orlando fl 32818 - Determine the centroid x y of the shaded area - The art of public speaking chapter 5 - Hida with cck or without - GOVT 480 DB FORUM 1 2 REPLIES DUE 8/31/2020 - Mountainaire avian rescue society - Visual aid speech topic ideas - Hnc lewis dot structure - Myoplex shred fruity cereal review - Second grade math minutes - Nfpa natl fire protect - Http www artchive com ftp_site htm - Julius caesar no fear shakespeare act 2 - Relational messages are usually expressed nonverbally - Technology for management - Don't throw stones at blackbirds meaning - 135 st vincent street port adelaide - Whistleblowing and professional responsibility sissela bok - Describe the use of factual texts - Describe the japanese feudal system - Ethical hacking rules of engagement - Kite runner chapter 6 - Last Assignment - Hydrogen gas is collected by water displacement - Wendy Lewis 1 - Vce physics motion cheat sheet - Castle clash walla walla traits - 2.5 litres to ml - Matweb aluminum 6061 t6 - Culture and Environment Analysis - Economics - Trends & issues in executive management for health care administrators - How does mccarthyism relate to the salem witch trials - Four basic metaparadigm concepts in nursing - Bombardier erp implementation case study - Johnny cash four horsemen - Rotational vibrational spectrum of hcl lab report - Improving Healthcare - Earth science - Website analysis memo - Http purl org dc elements 1.1 - Multidimensional 2 Discussion - ESSAY #7 ART HIST - Gps and gsm based vehicle tracking system using arduino code - Christian Worldview - I NEED THIS AFTER 6HRS (OVERDUE): Week 7 Case Study - Regression Model (Case Study #4) - Electron configuration diagram of sodium fluoride - Greg lynn folding in architecture - Networks an introduction 2nd edition - Apa ethics code 2017 - Week 10 - How to write a chemistry lab report introduction - California gold rush worksheets - Ballarat health services education - 6 edinburgh circuit bundoora - Field hockey attacking tactics - Wendy kaufman balancing life's issues - Tkam chapter 16 questions and answers - How children develop siegler 4th edition