Mark the steps as checked when you complete them.

Open the workbook BlueLake$-01.$xIsx start file. If the workbook opens in Protected View, click Enable Editing in the security bar.

The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it$.$

Apply the Office theme to the worksheet.

Edit worksheet data.

a$.$ Edit the title in cell A$2$ to display First Period Sales by Department.

b$.$ Edit the value in cell D$6$ to $1950.$

Unmerge cells and reformat data.

a$.$ Select cells A$1$:A$2.$

b$.$ Click the Merge & Center button arrow $[$Home tab, Alignment group$].$

c$.$ Choose Unmerge Cells. The cells are no longer merged but the cells still have Center alignment.

d$.$ Click the Align Left button $[$Home tab, Alignment group$].$

e$.$ Change the font size to $16.$

f$.$ Set the row height for rows $1$:$2$ to $24.$

Reset Progress

Back t