In cell B31 , calculate Total Discounts for Friday for One Double rooms by subtracting Gross Sales from Net Sales . Copy the formula to cell range C31 : H31 .
19 Copy the formulas in cell range B31 : H31 to cell range 5.000
B39 : H39 .
20 Apply Bold to cell ranges B31 : H31 , B39 : H39 , and
4.000
B46 : G46 . Apply AutoFit Column Width for columns A : H . Use the resizing handles to reposition the right side of the logo in row 1 between columns F and G .
21 On the PAGE LAYOUT tab , set Orientation to 4.000
Landscape and set Width to 1 page .
22 In the Documentation worksheet , type ​Completed
1.000 formatting and calculations in the Hotel Discounts worksheet​ in cell C8 .