Suppose that two of the Deluxe Luxury rooms in the spreadsheet above were being renovated and unavailable for sale on a particular trip. Therefore, cell C6 would change from 20 to 18.
a. Would all, some, or none of the values in column D change based on the change in cell C6? Explain.
b. Would all, some, or none of the values in column E change based on the change in cell C6? Explain.
c. Would all, some, or none of the values in column F change based on the change in cell C6?