Solved by Expert Tutors
Shelly Cashman Excel 2016 | Module 1: SAM Project 1a Blooming Everywhere Delivery CREATING A WORKSHEET AND A CHART GETTING STARTED Open the file...
Solved by Expert Tutors
Question

computer science question. I can provide login information for cengage

if needed. I need this done asap. Good tip awaits a great and timely answer.

Shelly Cashman Excel 2016 | Module 1: SAM Project 1a Blooming Everywhere Delivery CREATING A WORKSHEET AND A CHART GETTING STARTED Open the fle SC_EX16_1a_ FirstLastName _1.xlsx , available For download From the SAM website. Save the fle as SC_EX16_1a_ FirstLastName _2.xlsx by changing the “1” to a “2”. o IF you do not see the .xlsx fle extension in the Save As dialog box, do not type it. The program will add the fle extension For you automatically. With the fle SC_EX16_1a_ FirstLastName _2.xlsx still open, ensure that your frst and last name is displayed in cell B6 oF the Documentation sheet. o IF cell B6 does not display your name, delete the fle and download a new copy From the SAM website. PROJECT STEPS 1. Bob is the co-owner oF Blooming Everywhere Delivery, a ±oral delivery service accessed exclusively through mobile apps, and is preparing a report For his business partner on the company’s fnancials 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 Valu e 1800 1950 2020
Background image of page 1
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% (10 th column, 5 th 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 pro±t increases every year. In cell B20 create a formula without using a function that calculates the pro±t earned in 2018 by subtracting the total expenses in 2018 (cell B16 ) from the total revenue in 2018 (cell B8 ). Using the Fill Handle, ±ll the range C20:D20 with the formula from cell B20. 13. Change the tab color of the Company Analysis worksheet to Orange (3 rd column, 1 st 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.
Background image of page 2
Show entire document
Author: Note: Do not edit this she
Background image of page 01
Campus Fitness Center MODIFY A SERVICE REPORT AND CREATE A CHART Peter Mbome Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a eet. If your name does not appear in cell B6, please download a new copy of the Fle from the SAM website.
Background image of page 02
Show entire document
Sign up to view the entire interaction

Step-by-step answer

ec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam laacinia pulvi

ipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pe

gue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis

SC_EX16_CS1-3a_PeterMbome_2 (1).xlsx
at, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit ec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question