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.
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.
Important Questions from Electronic Spread Sheet
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.
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.
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.
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 AllFrequently Asked Questions
What are the important topics in Electronic Spread Sheet for NIOS Class 12 Accountancy?
How many important questions are there in Electronic Spread Sheet?
Sources & Official References
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Electronic Spread Sheet
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.