question archive Shelly Cashman Excel 2019 Module 2:SAM Project 1b Edgerton-Norris Shelly Cashman Excel 2019 | Module 2: SAM Project 1b Format Worksheets GETTING STARTED Open the file SC_EX19_2b_FirstLastName_1
Subject:MS ExcelPrice:19.87 Bought3
Shelly Cashman Excel 2019 Module 2:SAM Project 1b
Shelly Cashman Excel 2019 | Module 2: SAM Project 1b
Open the file SC_EX19_2b_FirstLastName_1.xlsx, available for download from the SAM website.
Save the file as SC_EX19_2b_FirstLastName_2.xlsx by changing the “1” to a “2”.
If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
Middle Align the contents of cell A1 to improve the appearance of the worksheet title.
Format the billing section to show that the information belongs together as follows:
Add Outside Borders to the range A2:F4.
Change the border color to Green, Accent 4 (8th column, 1st row of the Theme Colors palette).
Apply the Short Date number format to cell F3 to use a more common date format.
In cell A1, change the font to Franklin Gothic Medium.
Change the font size to 18 point.
Change the font color to White, Background 1.
Merge the worksheet title across the range A1:I1.
Resize the width of column A and column B using AutoFit to display all the text in the column.
Delete the row containing the first duplicate value.
Wrap the contents of cell E4 to display the text on two lines.
In cell A3, decrease the number of decimal places to 2 to format the value as a dollar amount.
Apply the 40%—Accent3 cell style to the range A4:I4 to indicate those cells contain column headings.
Apply the Accounting number format to the range D5:D15 to show that the values are dollar amounts.
Check the Spelling in the workbook to identify and correct any spelling errors.
Purchased 3 times