Question

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.

Answer 1

Validating the cell D5 would ensure that the cell D5 do not accept invalid inputs

How to create data validation?

To create data validation in the cell D5, we perform the following steps

• Select the cell D5 in the Microsoft Excel sheet
• Go to data; select data validation
• Go to the Settings tab, then select the Whole number option under Allow
• Next, goto data then select condition.
• Set all necessary conditions
• Go to the Input Message tab, then enter a custom message that displays when the user enters an invalid input.
• Check the Show input message

• Set the error style under the Error Alert tab
• Click OK.

The above steps validates the cell D5, and would ensure that the cell D5 do not accept invalid inputs.

Read more about data validation at:

https://brainly.com/question/25895973