educational course/tutorialoutlet.com educational course/tutorialoutlet.com | Page 106

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