Shelly Cashman Excel 365/2021 | Module 2: SAM Project 1a | Help in Homework |

24 / 7 Live Support
[e-mail]
[phone]
[phone]
Roadrunner Online
FORMAT WORKSHEETS
GETTING STARTED
• Save the file SC_EX365_2021_2a_FirstLastName_1.xlsx as SC_EX365_2021_2a_FirstLastName_2.xlsx
o Edit the file name by changing “1” to “2”.
o If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.
• With the file SC_EX365_2021_2a_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.
o If cell B6 does not display your name, delete the file and download a new copy.
PROJECT STEPS
1. Shanice Traynor is the warehouse manager for the Roadrunner Online warehouse in Detroit, Michigan. The warehouse specializes in automobile parts, which consumers buy from Roadrunner Online. Shanice has started to create an Excel workbook to track items in the warehouse inventory. She asks you to format the workbook to make the information clearer and easier to understand before she finishes entering the data.
Go to the Bin worksheet. Change the name of the worksheet tab to Bin List to use a more descriptive name.
2. Bottom Align the contents of the range C3:C13 to match the alignment of the other cells on the worksheet.
3. Format the list of bins to emphasize that the information belongs together as follows:
a. Apply Outside Borders to the range A1:C13.
b. Change the border color to Blue-Gray, Accent 3 (7th column, 1st row of the Theme Colors palette).
4. Apply the Short Date number format to cell B15 to use a more common date format.
5. In Page Layout view, enter Warehouse Bins in the center section of the header to provide a meaningful header when Shanice prints the worksheet.
6. Go to the Inventory List worksheet. To make it stand out, format the worksheet title in cell A1 as follows:
a. In cell A1, change the font to Calibri Light.
b. Change the font size to 20 point.
c. Change the font color to Indigo, Text 2.
d. Bold the worksheet title.
e. Merge and center the worksheet title across the range A1:I1.