CBSE Class 12 Accountancy 2026: question 30(a)
Set in the CBSE Class 12 board exam of 2026, paper 67/1/1, section B-II, question 30(a), for 1 mark. Try it first; the hints and our step-by-step solution are below.
Q30(a) · 1 mark · MCQSpreadsheet
What is the outcome of an arithmetic expression or function called ?
- (A)Horizontal value
- (B)Derived value
- (C)Basic value
- (D)Vertical value
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
Compare a value you type into a cell with a value that a formula works out.
Hint 2
A value obtained from other values is said to be ____ from them.
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.
Verified: two independent solves agree and the official marking scheme matchesChecked 2026-11-01
A cell holds either a basic value, which is typed in directly, or a derived value, which Excel calculates from a formula, expression or function.
- 1 mark
The outcome of an arithmetic expression or function is therefore called a derived value, option (B).
Answer: (B) Derived value
Where the marks are
- Selects option (B), Derived value (1 mark)
Revise the chapter
- Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
- Topic: Formulas, Functions and Cell References
Want more questions like this?
Practise CBSE Class 12 Accountancy questions free, marked against the answer key, with hints when you are stuck.
More questions to try
- Sample paper 2026-27, Q33(B) · 4 marksWhat is meant by internal margin while using MS Excel? State the options available.
- 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 ?
- Same paper, Q30(b) · 1 markWhat value of range look up in VLOOKUP ( ) and HLOOKUP ( ) is used for returning only exact value ?
The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error?Report it in one tapand a person will check it.