Skip to content

Give the meaning of the… (Class 12 Accountancy 2026, Q33a)

questionbuddy.in/q/cbse-12-accountancy-2026-67-5-1-q33a-give-meaning-cell-reference-relative

AccountancyCBSE Class 12 · Board exam 2026, set 67/5/1 · 4 marks · Long answer

CBSE Class 12 Accountancy 2026: question 33(a)

Set in the CBSE Class 12 board exam of 2026, paper 67/5/1, section B-II, question 33(a), for 4 marks. Try it first; the hints and our step-by-step solution are below.

Q33(a) · 4 marks · Long answerSpreadsheet

Give the meaning of the following :
(i) Cell reference
(ii) Relative cell reference
(iii) Absolute cell reference
(iv) Mixed cell reference

Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/5/1.

Hints

Open one hint at a time and try again before the next.

Hint 1

Start with what a cell address is.

Hint 2

Think about what happens to each reference when a formula is copied down.

Step-by-step solution

Each step shows the marks it earns, as an examiner would award them. Checked by an independent re-solve from the question paper.

  1. (i) Cell reference identifies a cell or range by its column letter and row number (its address), e.g. B5, for use in formulas.

    1 mark

  2. (ii) Relative reference (e.g. A1) changes to match the new position when a formula is copied to another cell; this is the default.

    1 mark

  3. (iii) Absolute reference puts a dollar sign before both the column letter and the row number of the address (A1 written with a dollar sign before "A" and before "1"). It stays fixed on the same cell however the formula is copied.

    1 mark

  4. (iv) Mixed reference puts the dollar sign before only the column letter or only the row number, so one part stays fixed and the other changes when the formula is copied.

    1 mark

Answer: Cell reference = cell address; relative changes when copied; absolute stays fixed; mixed fixes only the row or only the column

Where the marks are

  • Each meaning (1 mark each)

Revise the chapter

Practise this chapterBoard-style questions from Spreadsheet, one at a time, marked against the answer key and marking points.Back to the full paper2026 board paper, set 67/5/1: every question, by section.

The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error? Write tosupport@questionbuddy.in.