FORMATTING WORKSHEETS Directions: Do the following procedure as directed.
1. Open a new worksheet.
2. Create a calendar for the month of December in the current year with
Sunday as the first column.
3. Use the AutoFormat, Classic 2
4. Adjust Row height to 60 and Column width to 15.
5. Change the font size to 14 and font style to Times New Roman, Bold,
Center (names of the week)
6. Select the names of the week and apply the horizontal and vertical
alignment.
7. Change the font size of the numerals to 18.
8. Merge and center align the word “December" and change to Times
New Roman Bold, 26 as the font size.
9. Select and format the entire range of data by applying the outline and
inside Borders.
10. Select Sunday column and change the color to red.
11.
Select 25 and 30 being the Holidays and change the color to red.
12.
Apply cell shading to cells 25 and 30 using the Patterns tab and
change the color to pink.
13. Save your work to your folder as "calendar".