34,940 views
0 votes
0 votes
Create a data validation list and sell D5 that displays quantity, payment type, amount. Do

not use cell references as the source of the list. Be sure to enter a blank space after each, we comma when entering the values.

User George Shaw
by
2.7k points

2 Answers

8 votes
8 votes

Final answer:

To create a data validation list in Excel, select cell D5, go to the Data tab, click on Data Validation, select List, and enter the values for the quantity, payment type, and amount separated by commas.

Step-by-step explanation:

To create a data validation list in cell D5, you can use the Data Validation feature in Microsoft Excel. Here are the steps:

  1. Select cell D5.
  2. Go to the 'Data' tab, and click on 'Data Validation'.
  3. In the 'Settings' tab of the Data Validation dialog box, select 'List' from the 'Allow' dropdown menu.
  4. In the 'Source' field, type in the values for the quantity, payment type, and amount, separated by commas and a space after each value.
  5. Click 'OK' to apply the data validation to the cell D5.

For example, if you want to have the following options: '1, Cash, $10', '2, Credit Card, $20', '3, Debit Card, $30', you would enter '1, Cash, $10, 2, Credit Card, $20, 3, Debit Card, $30' as the source of the validation list.

User Karthik Andhamil
by
3.0k points
16 votes
16 votes

Final answer:

To create a data validation list for cell D5 with the values 'quantity, payment type, amount,' one must access the Data Validation feature in Excel, choose 'List' in the Settings, and manually enter the values separated by a comma and a space.

Step-by-step explanation:

To create a data validation list in Excel without using cell references, you can directly type in the values you want to appear in the list. To do this for cell D5, you would:

  1. Click on cell D5 to make it the active cell.
  2. Go to the Data tab on the ribbon and click on 'Data Validation' in the 'Data Tools' group.
  3. In the Data Validation dialog box, under the Settings tab, choose 'List' from the 'Allow' dropdown menu.
  4. In the 'Source' box, type in "quantity, payment type, amount," making sure to include a blank space after each comma.
  5. Click 'OK' to apply the data validation list to cell D5.

Now, when you click on cell D5, a dropdown list will appear, allowing you to select from "quantity," "payment type," or "amount."

User Zheko
by
3.1k points