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: Identify the closing step.
The last action must be confirming the choice in the Paste Special box with OK. That is (B), so (B) belongs at the end. Option 2 has (B) first and option 4 has it second, so both fail.

Step 2: Identify the opening step.
Something has to be selected before any command works. Selecting the formula cell is (C). Option 3 begins with (A), copying with nothing selected, so it fails.

Step 3: Order the middle.
Once the cell is selected, we copy it (A) and only then open Paste Special (D), because paste needs copied content.

Step 4: Write the sequence.
C, then A, then D, then B.
\[ \boxed{\text{(C), (A), (D), (B)}} \]

Final Answer:
Sequence: select the cell, copy, open Paste Special, choose Values and OK (option 1).