Final answer:
To restrict a user from entering a value outside a specified range, use Excel's Data Validation feature. This allows you to set rules that only permit values between $20 and $100, preventing entries outside this range.
Step-by-step explanation:
To restrict a user from entering any amount greater than $100 or less than $20 in a row in Excel, you would use the Data Validation feature. Data Validation allows you to set specific rules for data entry in a cell or range of cells, and displays an error message if the entry violates these rules. For implementing the restriction, you will have to follow these steps:
- Select the cell or range of cells where you want to restrict the entry.
- Go to the Data tab on the Ribbon.
- Click on 'Data Validation' in the 'Data Tools' group.
- In the Data Validation dialog box, under the 'Settings' tab, choose 'Decimal' in the 'Allow' list.
- In the 'Data' list, select 'between'.
- Enter '20' in the 'Minimum' box and '100' in the 'Maximum' box.
- Click 'OK' to apply the settings.
Now, if a user tries to enter a value outside of the specified range, Excel will prevent the entry and can show an alert explaining the validation rule, ensuring that entries stay within the $20 to $100 range.
Conditional Formatting, Autofill, and Sort and Filter do not offer the functionality to restrict data entry and therefore would not be the correct features to use for this purpose. Conditional Formatting changes the appearance of cells based on their values, Autofill helps to fill in data automatically based on a pattern, and Sort and Filter is used to organize and find data within the sheet.