17 Select cell range B34 : B37 . Click and hold the fill handle
5.000 and then expand the selection to include B34 : G37 .
Calculate the Paradise Club discounts for Friday and Saturday night for One Double rooms in cell B43 . Add the Friday Paradise Club discounts to the Saturday Paradise Club discounts using appropriate cells references so the formula can be copied . Use the fill handle to copy cell B43 to cell range B44 : B45 , but do not fill formatting . Copy cell range B43 : B45 to cell range C43 : G45 .
18 Calculate the Net Sales for each room type on each
10.000 night , the total sales and discounts for all room types on each night , the Total Discounts for each room type for both nights , and the Total of each discount type for the weekend . Do this by using AutoSum Sum to calculate totals in cell ranges B30 : G30 , H26 : H30 , B38 : G38 , H34 : H38 , B46 : G46 and H43 : H46 .