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

Which cell reference is used when we want a cell reference to stay fi…

Which cell reference is used when we want a cell reference to stay fixed on a specific cell, which means that when a formula or function is copied and pasted to other cells, it does not change?

Answer & explanation+

Correct answer: option 4

The correct answer is Option (4) → Absolute cell reference

NCERT (2026-27 edition):
Cell Reference

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. _________ of a chart/ graph is an identifier of a piece of information shown in the chart/ graph.Accountancy Part C · Graphs and Charts for Business Data
  2. Choose the most appropriate option to replace the underlined phrase in the given sentences:-The sprawling palaces of Indian royal families…English · Grammar: Idioms
  3. How much of the profits earned by a company will be distributed as profit and how much will be retained in the business is affected by many…Business Studies · Financial Management
  4. Match the LIST-I with LIST-IILIST-ILIST-IIA. Floor PriceI. Decrease in supplyB. Price ceilingII. Setting the minimum priceC. Leftward shift…Economics · Micro Economics: Market Equilibrium
  5. Choose the alternative which closely resembles the water image of the given combination of alphabets in the Figure (X).General Aptitude Test · Non-Verbal Reasoning
  6. The Financing Decisions are affected by:(A) Floatation Costs(B) Cash Flow Position of the Company(C) Fixed Operating Costs(D) Taxation Poli…Business Studies · Financial Management
  7. Mukesh Ltd. offered 4,00,000 shares, of Rs. 10 each to the public for subscription, to be received as Rs. 2 on application, Rs. 3 on allotm…Accountancy Part A · Accounting for Shares
  8. In a game, A can give 20 points to B, A can give 32 points to C and B can give 15 points to C. How many points make the game?Applied Maths. Section B2 · Numbers, Quantification and Numerical Applications
  9. Biolistics method is suitable for introduction of DNA into:Biology · Biotechnology -Principles and Processes
  10. If A:B=2/9:1/6 , B:C=2/7:5/21 and D:C=7/10:3/5 , D:E=5/7:3/14 thenMatch the List-I with List-IIList-IList-IIA. C : AI. 32 : 7B. D : BII. 24…General Aptitude Test · Numerical Ability