Skip to content

How are 'absolute… (Class 12 Accountancy SQP 2026-27, Q28)

questionbuddy.in/q/cbse-12-accountancy-2026-27-sqp-q28-how-absolute-cell-reference-mixed

AccountancyCBSE Class 12 · Sample paper, session 2026-27 · 1 mark · MCQ

CBSE Class 12 Accountancy sample paper 2026-27: question 28

From the official CBSE sample question paper for 2026-27, section B-II, question 28, for 1 mark. Try it first; the hints and our step-by-step solution are below.

Q28 · 1 mark · MCQSpreadsheet

How are 'absolute cell reference' and 'mixed cell reference' identified in Excel ?

  1. (A)Using # sign
  2. (B)Using ~ sign
  3. (C)Using $ sign
  4. (D)Using £ sign

Source: official sample paper from cbseacademic.nic.in (PDF). See it in the full Sample paper 2026-27.

Hints

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

Hint 1

What do you type to stop a reference changing when you copy it?

Hint 2

Press F4 in a reference and watch what appears.

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. A $ placed before the column letter and/or row number fixes that part of the reference when the formula is copied.

  2. 1 is absolute; 1 are mixed references. Option (C).

    1 mark

Answer: (C) Using $ sign

Where the marks are

  • The dollar sign fixes references (1 mark)

Revise the chapter

  • Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
Practise this chapterBoard-style questions from Spreadsheet, one at a time, marked against the answer key and marking points.Back to the full paperSample paper 2026-27: 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.