Format the worksheet title as follows to use a consistent design throughout the workbook:
a. Fill cell C2 with the Teal, Accent 6, Lighter 40% shading color.
b. Change the font color to White, Background 1.
C. Merge and center the contents of cell C2 across the range C2:12.
d. Use AutoFit to resize row 2 to its best fit.
To format the worksheet title as described, follow these steps:
a. Select cell C2.
b. Go to the Home tab in the Excel ribbon.
c. Click on the Fill Color button in the Font group.
d. In the drop-down menu, choose Teal, Accent 6, Lighter 40% shading color.
e. Go back to the Home tab and click on the Font Color button in the Font group.
f. In the drop-down menu, choose White, Background 1.
To merge and center the contents of cell C2 across the range C2:12, follow these steps:
a. Select cell C2.
b. Hold down the Shift key on your keyboard.
c. Use the arrow keys to extend the selection to cell C12.
d. With the range C2:C12 still selected, go to the Home tab.
e. Click on the Merge & Center button in the Alignment group.
To use AutoFit to resize row 2 to its best fit, follow these steps:
a. Select row 2 by clicking on the row header, which is the number 2 on the left side of the worksheet.
b. Go to the Home tab.
c. In the Cells group, click on the Format button.
d. In the drop-down menu, choose AutoFit Row Height.