CUETMOCK
  • Pricing
  • Mentors
Log inStart freeStart free mocks→

First test, then trust

Try a free CUET mock test.

Join 5,00,000+ students who rehearsed exam day on the exact NTA screen before sitting CUET. On the web and on Android.

Start free mocks →Get the Android app
CUETMOCK

India's #1 CUET Mock Test Platform. Original NCERT-based questions on the exact NTA exam screen — trusted by 5,00,000+ students since CUET 2022.

Get it onGoogle PlayScan to download the CUETMOCK app

Mock tests

  • CUET mock test series
  • Browse all papers
  • Commerce mocks
  • Humanities (Arts) mocks
  • Science mocks
  • Languages & GAT mocks
  • Free practice questions
  • Pricing

Resources

  • CUET exam guide
  • CUET syllabus
  • Universities accepting CUET
  • Expert blogs
  • News & notifications
  • Webinars & counselling
  • CUET score calculator
  • How we estimate your rank
  • FAQs

Company

  • About us
  • Our leadership & team
  • Our toppers
  • Mentors
  • For schools
  • Contact us
  • Terms
  • Privacy
  • Refund policy

Talk to us

+91 7696 6630 56info@cuetmock.comWhatsApp us

Our other platforms

  • JEE Mock — For IIT-JEE aspirants
  • NEET Mock — For NEET aspirants

Newsletter

Exam updates, study material and offers — no spam.

© 2026 NYC Ventures Pvt. Ltd.

701-702, Royal Business Park, Zirakpur, Punjab - 140603

  • Terms of use
  • Privacy policy
  • Refund policy
  • Contact us

iCUETMOCK is an independent preparation platform, not affiliated with the National Testing Agency (NTA). Always check exam details on the official NTA website.

  • Home
  • Mock tests
  • CUET guide
  • Pricing
  • Log in
Home/Practice questions/Accountancy Part C
Accountancy Part CSpreadsheet

Arrange the following steps related to freezing the formula using pas…

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:

Answer & explanation+

Correct answer: option 1

The correct answer is Option (1) → (C), (A), (D), (B)

To freeze a formula, its result is copied and pasted back as a plain value, in this order.

(C) Select the cell (s) that contains the formula — first: choose what is to be frozen.

(A) Click on Home Tab and select Copy symbol — next: copy the cells.

(D) Click on Paste tab and select Paste Special — then: open the Paste Special box.

(B) In the Paste Special box, under paste select the radio button next to Values and click OK — last: paste only the values, which removes the formula.

NCERT (2026-27 edition):
Freezing the Formula

Extract from the NCERT textbook

Advertisement

Practise more on Spreadsheet

Chapter-wise mocks on the real NTA exam screen, with solutions and your rank. Your first mocks are free.

Start free mocks →

Advertisement

Next questions

  1. Given a function f(x)=ax+displaystyleb/x;\ agt0,\ bgt0 , thenMatch List-I with List-IIList-IList-II(A) f(x) has local maxima at x is equal…Maths. Section B1 · Applications of Derivatives
  2. Why do the boiling points of alcohols decrease with increase of branching in the carbon chain?Chemistry · Organic: Alcohols, Phenols and Ethers
  3. The function f(x) = x^3 - 3x^2 - 9x + 4 has a local maximum atMaths. Section A · Applications of Derivatives (Section A)
  4. A partner is admitted and the following steps are to be followed while calculating his share of goodwill. Arrange them in a sequence:(A) Ca…Accountancy Part A · Admission of a Partner
  5. Using the matrix method, the solution of the system of equations 2x - y = 4,\ x + 3y = 9 isApplied Maths. Section B2 · Algebra
  6. Which of the following statements about web publishing as a source of recruitment is NOT correct?Business Studies · Staffing
  7. Which of the following can be the probability of an event?General Aptitude Test · Quantitative Reasoning
  8. __________ states that, situation and circumstance in which one is placed influence one’s behaviour.Psychology · Variations in Psychological Attributes
  9. Every business carries some business risk. On which of the following does the business risk of a firm depend?Business Studies · Financial Management
  10. Renu takes a loan of Rs. 12,00,000 with 12% annual interest for 10 years on flat rate basis.Match the List-I with List-IIList-IList-II(A) P…Applied Maths. Section B2 · Financial Mathematics