Skip to main content
Chapter 35 of 38
Important Questions

Electronic Spread Sheet — Important Questions

NIOS · Class 12 · Accountancy

89 important questions from Electronic Spread Sheet for NIOS Class 12 Accountancy, with answers. Includes multiple choice and multiple correct questions.

89 questions40 flashcards5 concepts

Interactive on Super Tutor

Studying Electronic Spread Sheet? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for important questions and more.

Free trial, no card needed.

89 Questions·
multiple choicemultiple correct

Important Questions from Electronic Spread Sheet

1multiple choice
3 marks

A worksheet contains the mixed reference formula =(A$1+$B2). If A1 = 12 and B2 = 9, what is the value of the formula in the copied position?

Show answer

21

In mixed referencing, only one part is fixed. Here A$1 keeps row 1 fixed, and $B2 keeps column B fixed. So the value is 12 + 9 = 21.

2multiple choice
3 marks

A current worksheet has A1 = 14 and Sheet2 has A2 = 26. Using the formula =A1+Sheet2!A2, what value is obtained?

Show answer

40

The formula adds the value in the current worksheet cell A1 and the value in Sheet2 cell A2. So 14 + 26 = 40.

3multiple choice
3 marks

A spreadsheet has 4 groups of data. Each group has 36 rows and 18 columns. How many cells are there in all groups together?

Show answer

2,592 cells

Cells in one group = 36 × 18 = 648. For 4 groups, 648 × 4 = 2,592.

4multiple choice
3 marks

A pivot report is made from 240 data entries and then expanded into 6 summary groups. How many data entries are represented per group on average?

Show answer

40 entries per group

Average per group = 240 ÷ 6 = 40. The pivot table summarizes large data into groups, so each group represents 40 entries on average.

+85 more questions on Electronic Spread Sheet (NIOS Class 12 Accountancy)

Practise All

Frequently Asked Questions

What are the important topics in Electronic Spread Sheet for NIOS Class 12 Accountancy?
Key topics in Electronic Spread Sheet include Meaning and Basic Features of Electronic Spreadsheet, Spreadsheet Grid, Cell Pointer, Data Entry and Auto Fill, Formulas, Functions and Formula Elements, Relative, Absolute and Mixed Referencing. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How many important questions are there in Electronic Spread Sheet?
Super Tutor has 89 practice questions for Electronic Spread Sheet, including multiple choice, multiple correct questions. A sample with answers is on this page.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

For serious students

Get the full Electronic Spread Sheet chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Accountancy. Free to start, no card needed.