www. tutorialoutlet. com
www. tutorialoutlet. com
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