Question

Problem 1 (20 points) For this problem, you will use theHarry's Holiday Hotel found in the Exam Workbook. In thisparticular problem, imagine a local business person who operates alocal hotel wishes to have you complete a spreadsheet application for her business. In this spreadsheet you will see a simple form he intends to use to calculate customer totals.

Your task is to complete the following activities:
1) Create an appropriate data validation, appropriate input message, and relevant error alert for all of the fields highlighted in yellow. (2 pts each)
a. Cells C7 should reflect the choice of hotel room (Studio, 1 BR, 2 BR & Penthouse)
b. C11 should reflect the number of nights stayed. (Minimum 2, Maximum is 14)
C G7 should reflect the customer's status in the rewards program. Options listed in
spreadsheet as: None, Silver, or Gold
2) Enter the following values in your spreadsheet
Enter the value of 0 in cell J7, Enter the value of 1.5 in cell K7
. Enter the value of 3 in cell L7, Enter the value of $99 in cell J12
. Enter the value of $129 in cell 313, Enter the value of $149 m cell 114 . Enter the value of $189 in cell. JIS

Answer 1

To create data validation for the highlighted fields in yellow:
For cell C7, select the cell and go to the Data Validation option in the Data tab. In the Settings tab, choose "List" under Allow, and in the Source field, enter the options for hotel room types (Studio, 1 BR, 2 BR & Penthouse) separated by commas. In the Input Message tab, enter a message to inform the user about the available options. In the Error Alert tab, select "Stop" and enter an error message to inform the user to choose a valid option.
For cell C11, select the cell and go to the Data Validation option in the Data tab. In the Settings tab, choose "Whole Number" under Allow, and in the Data field, choose "between" and enter the minimum (2) and maximum (14) number of nights stayed. In the Input Message tab, enter a message to inform the user about the valid range of values. In the Error Alert tab, select "Stop" and enter an error message to inform the user to enter a value within the valid range.
For cell G7, select the cell and go to the Data Validation option in the Data tab. In the Settings tab, choose "List" under Allow, and in the Source field, enter the options for customer status in the rewards program (None, Silver, Gold) separated by commas. In the Input Message tab, enter a message to inform the user about the available options. In the Error Alert tab, select "Stop" and enter an error message to inform the user to choose a valid option.
To enter the values in the spreadsheet:
Select the cells J7, K7, L7, J12, J13, J14, J15 and enter the values as instructed.
Note: Make sure to save your spreadsheet and test the data validation and error alerts by entering invalid or out-of-range values.