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

Match List-I with List-IIList-IList-II(A)Ranges(I)Holds either row or…

Match List-I with List-II

List-IList-II
(A)Ranges(I)Holds either row or column constant when the formula or function is copied to another location
(B)Mixed reference(II)Used when we want a cell reference to stay fixed on specific cell
(C)Absolute reference(III)As a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the new location
(D)Default reference(IV)Identified by cell references of the cells from the upper left to lower right

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 2

The correct answer is Option (2) → (A) - (IV), (B) - (I), (C) - (II), (D) - (III)

A cell reference can stay fixed, move with the formula, or do a bit of both when the formula is copied.

(A) Ranges — this matches (IV) Identified by cell references of the cells from the upper left to lower right. A range such as A1:E2 is named by its two corner cells.

(B) Mixed reference — this matches (I) Holds either row or column constant when the formula or function is copied. Only one part is fixed, as in $C4 or C$4.

(C) Absolute reference — this matches (II) Used when we want a cell reference to stay fixed on specific cell. Both the column and the row are fixed, as in $C$4.

(D) Default reference — this matches (III) the cell references change to reflect the new location. By default a reference is relative, so it moves with the formula.

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. Which of the following battles was NOT fought by Babur?General Aptitude Test · General Knowledge
  2. Which of the following statements are true:A. WTO facilitates international trade by levying TariffB. WTO facilitates international trade b…Economics · Indian Economic Development: Liberalisation, Privatisation and Globalisation - An Appraisal
  3. 'McDonaldisation' is an example of which of the following phenomena?Political Science · Contemporary World Politics: Globalisation
  4. What will be the break even point in rupees?Entrepreneurship · Business Arithmetic
  5. The differential equation of the family of parabolas having a vertex at origin and axis along the negative y-axis is given by :Maths. Section A · Differential Equations
  6. India has declared Net Zero Pledge, to achieve a net zero emissions goal by which year?General Aptitude Test · Current Affairs
  7. When electricity is passed through molten AlCl3, 13.5 g of Al is deposited. What is the number of faradays involved? (Al = 27 g mol−1)Chemistry · Physical: Electro Chemistry
  8. At 5 p.m. on a sunny day, Sameer starts walking from a park gate with his shadow falling exactly behind him. After 20 m, he turns left and…General Aptitude Test · Verbal Reasoning
  9. Which among the following is used to induce mutation in plant cells?Biology · Strategies for enhancement in Food production
  10. The theory of natural selection was proposed by:Biology · Evolution