PROJECT STEPS

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.

Bottom Align the contents of the range $C3$:$C13$ to match the alignment of the other cells on the worksheet.

Format the list of bins to emphasize that the information belongs together as follows:

a$.$ Apply Outside Borders to the range A$1$:C$13.$

b$.$ Change the border color to Blue$-$Gray, Accent $3(7$th column, $1$st row of the Theme Colors palette$).$

Apply the Short Date number format $($in the Number Format dropdown menu$)$ to cell B$15$ to use a more common date format.

In Page Layout view, enter Warehouse Bins in the center section of the header to provide a meaningful he$$der when Shanice prints the worksheet.

Go to the Inventory List worksheet. To make it stand out, format the worksheet title in cell A$1$ as follows:

a$.$ In cell A$1,$ 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 A$1$:I$1.$

Shelly Cashman Excel $2019|$ Module $2$: SAM Project la

$7.$ Resize the width of column B using AutoFit to display the full text of the descriptions.

$8.$ Shanice asks you to find any duplicate entries and then delete them. Respond to her request as follows:

a$.$ In the range A$5$:A$16,$ use Conditional Formatting Highlight Cells Rules to highlight duplicate values in Light Red Fill with Dark Red Text.

b$.$ Delete the row containing the second duplicate value.

$9.$ Shanice wants to keep a running count of the items in inventory.

In cell B$3,$ enter a formula that uses the COUNTA function to count the values in the