Question

In cell B3 in the Bonnet sheet, create a validation rule with these specifications: • Whole number less than or equal to $350. • Input message title Professional Membership and input message Enter the amount of the annual professional membership dues. • Error alert style Warning, alert title Too Expensive, and error message The amount you tried to enter exceeds $350. Please select a less expensive membership.

Answer 1

Answer:

Spread sheet application (eg Microsoft Excel).

Explanation:

Data validation is a very power tool in spread sheet applications like Excel. It is used to determine the type of data that should be inputted in a cell or group of cells or an entire column. To create a data validation rule, select the area or column(s), locate and click on the data tab in the ribbon menu, then locate data validation.

To input numbers, select the number tab on the new window, then whole number and range of the input value (it can also be customised). A message for the user can be set with a title and body, to alert the user of the needed input. For wrong input, an error message with a title and body, can be set to alert users of wrong entries.