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

How is an absolute cell reference indicated? (A) With a # sign before…

How is an absolute cell reference indicated?

(A) With a # sign before the cell
(B) With a $ sign before the column and/or row
(C) With parentheses around the cell
(D) With a $ sign before the column and/or row

Choose the correct answer from the options given below:

Answer & explanation+

Correct answer: option 1

The correct answer is Option (1) → (B) only

An absolute cell reference stays fixed when a formula is copied. It is written with a dollar sign before the column letter and/or the row number, as in $C$4 (both fixed) or $C4 and C$4 (one part fixed, a mixed reference).

(A) With a # sign before the cell Incorrect. The # sign marks an error value in a cell, such as #VALUE!, not a fixed reference.

(B) With a $ sign before the column and/or row Correct. The $ sign holds the column, the row or both constant.

(C) With parentheses around the cell Incorrect. Parentheses enclose the arguments of a function or group parts of a formula; they do not fix a reference.

(D) With a $ sign before the column and/or row Correct. It is the same statement as (B).

Note: Statements (B) and (D) are printed the same, so both state the correct rule. No option offers (B) and (D) together; Option (1), (B) only, is the one option with no wrong statement, since every other option takes in (A) or (C). So Option (1) is taken as the answer.

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. After the elections held in India in the winter of 1945-46, who chose the representatives to the Constituent Assembly?History · Modern India: Framing the Constitution
  2. In a circle with centre O, AD is a diameter and AC is a chord. Point B is on AC such that OB = 7 cm and ∠ OBA = 60^°. If ∠ DOC = 60^°, then…General Aptitude Test · Quantitative Reasoning
  3. Pervasiveness of planning indicates that planning:Business Studies · Planning
  4. Subscription received during the year is ₹20,000; the amount received in advance for the next year is ₹1,200; amount outstanding for the cu…Accountancy Part A · Accounts for Non Profit Organsiation
  5. The Government wants to reduce the demand for electricity. If the elasticity of demand for electricity is 0.5 and it wants to reduce the de…Economics · Micro Economics: Theory of Consumer behaviour
  6. Knowing that the chemistry of lanthanoid is dominated by its (+3) oxidation state, which of the following statement is incorrect?Chemistry · Inorganic: D and F Block Elements
  7. According to Allport, a single trait that dominates an individual's entire personality is known as _________.Psychology · Self and Personality
  8. Which of the following Sultanates emerged around 1490?History · Medieval India: An Imperial Capital: Vijayanagara
  9. Pravasi Bharatiya Divas or NRI Day is formally observed on 9 January to celebrate the day __________.General Aptitude Test · General Knowledge
  10. From the given options, select the most appropriate word to fill in the blank in the given sentence:- Her new book was wonderfully ____ of…English · Fill Blanks