Question

Arrange the following steps related to freezing the formula using paste special command in logical sequence
(A) Click on Home Tab and select Copy symbol
(B) In the Paste Special box, under paste select the radio button next to Values and click OK
(C) Select the cell (s) that contains the formula
(D) Click on Paste tab and select Paste Special
Choose the correct sequence from the options given below:

• A. (C), (A), (D), (B)
• B. (B), (A), (C), (D)
• C. (A), (D), (C), (B)
• D. (D), (B), (C), (A)

Hint:

Select the cell first, copy it, open Paste Special, and finally pick Values and click OK.

Answer 1

The Correct Option is A

Step 1: Understand the task.
Freezing a formula means turning the formula into its fixed value. In Excel we copy the cell and then paste only the values using Paste Special.

Step 2: Find the first step.
We cannot copy anything before choosing it. So we first select the cell that contains the formula. That is (C).

Step 3: Find the second step.
After selecting the cell, we click the Home tab and press Copy. That is (A).

Step 4: Find the third step.
Then we click on the Paste option and choose Paste Special. That is (D).

Step 5: Find the last step.
In the Paste Special box, we select Values and click OK. This pastes the value in place of the formula. That is (B).

Step 6: Choose the option.
The order is C, A, D, B. This is option 1. Option 2 starts with the paste dialog before copying. Option 3 copies before selecting the cell. Option 4 starts with paste. So options 2, 3 and 4 are WRONG.

Final Answer:
The correct sequence is (C), (A), (D), (B), option 1.
\[ \boxed{\text{(C), (A), (D), (B)}} \]