e01_grader_h1_HotelDisc_YourOffice (solution) Homework | Page 7

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.