2 Merge and center the Input Area title over the range 5.000
A1 : B1 .
3 Apply bold and Blue , Accent 1 , Lighter 40 % fill color to 5.000 the range A1 : B1 .
4 Apply the Accounting Number Format to cell B2 . 4.000
5 Apply the Percent Style with one decimal place to cells 4.000
B3 : B4 .
6 Use Format Painter to copy the formats of the title in cell 4.000
A1 to D1 .
7 Change the width of column D to 17 . 4.000
8 Indent the Subtotal and Tip Amount labels twice each . 4.000