e01_grader_h1_HotelDisc_YourOffice (solution) Homework | Page 3

image to span columns C: F and to be the height of row 1.
4 Apply the Heading 4 cell style to cells A2, A12, A24, and
5.000
A41. Apply the Heading 3 cell style to cells A3: G3 and A7: G7.
5 Change the font color in cells A4: A5 and A8: A10 to Dark
5.000
Blue, Text 2 and apply Bold. Format the range B8: G10 as Percent Style with one decimal place.
6 Apply Table Styles as follows: 4.000
Format cells A25: H31 as Table Style Medium 2 with My table has headers. Select the First Column and Last Column Table Style Options. Then Convert to Range the table you just formatted.