Reggie created a data validation rule for cell B3, which contains a unit price.He wants to use the only the data validation in cell D3.Which of the following should he do?
A) Use the Format Painter to copy the formats from cell B3 to cell D3.
B) Copy cell B3 to cell D3.
C) Copy cell B3 then paste values in cell D3.
D) Copy cell B3 and the paste validation in cell D3.

Question

Quizplus · Accepted Answer

Copying and pasting the validation rule from cell B3 to cell D3 using the "paste validation" option is the best choice because it allows Reggie to apply the same validation rule to cell D3 without carrying over any unwanted formatting or data. Using the Format Painter or copying and pasting the cell or values could potentially carry over unwanted formatting or data, which may not be desired in cell D3.

Reggie Created a Data Validation Rule for Cell B3, Which