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:
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:
Solution
To convert formulas into fixed values, first select the cells containing the formula (C). Then copy them from the Home tab (A). Next open the Paste drop down and choose Paste Special (D). Finally, in the dialog box select the Values option and confirm with OK (B).
Sequence: (C), (A), (D), (B).
Related questions:
2026: 13 May Shift 2
2023: 29 May Shift 2
2022: 20 July Shift 1
2025: 3 June Shift 1
2025: 31 May Shift 1