Electronic Spread Sheet — Practice Quiz
NIOS · Class 12 · Accountancy
Try a 4-question quiz on Electronic Spread Sheet for NIOS Class 12 Accountancy: tap an answer to check it and see why.
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 practice quiz and more.
Free trial, no card needed.
Quick Quiz: Electronic Spread Sheet
0/4Tap an answer to check it instantly. No sign-up needed for these 4.
A worksheet has 125 rows of entered data and 48 columns of entered data. How many cells are there in the data region?
In a workbook, 3 worksheets each contain 24 rows of figures and 15 columns of figures. How many figures are there in all three worksheets?
A formula in cell C1 is =(A1+B1) and it is copied to cell C2. If A1 = 18 and B1 = 27, what does the copied formula become and what is its value?
A cell in a worksheet uses the absolute formula =($A$1+$B$1). If A1 = 32 and B1 = 18, what value does the formula give after it is copied to another cell?
Sample Questions
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 practice questions are there for 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
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
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.