CBSE Class 12 Accountancy 2026: question 28
Set in the CBSE Class 12 board exam of 2026, paper 67/1/1, 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
Which of the following is not contained on formula tab on Excel ribbon ?
- (A)Defined names
- (B)Page layout
- (C)Function library
- (D)Calculation
Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/1/1.
Hints
Open one hint at a time and try again before the next.
Hint 1
Picture the Formulas tab: what groups does it show?
Hint 2
One option is the name of another tab.
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.
The Formulas tab has the Function Library, Defined Names, Formula Auditing and Calculation groups.
- 1 mark
Page Layout is a separate tab of the ribbon, not a group on the Formulas tab. Option (B).
Answer: (B) Page layout
Where the marks are
- Page Layout is not on the Formulas tab (1 mark)
Revise the chapter
- Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
More questions from Spreadsheet
- 2026 board paper, set 67/1/1, Q29 · 1 markWhat will be displayed on the screen when Excel does not recognise the text or formula ?
- 2026 board paper, set 67/1/1, Q34 · 6 marksExplain various options available to change the alignment of the text in the cells.
- 2026 board paper, set 67/5/1, Q28 · 1 markHow is navigation conducted from the first to the last cell in a cluster of data in a column by skipping all t…
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.