Skip to main content
Chapter 35 of 38
Practice Quiz

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.

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 practice quiz and more.

Free trial, no card needed.

Quick Quiz: Electronic Spread Sheet

0/4

Tap an answer to check it instantly. No sign-up needed for these 4.

1

A worksheet has 125 rows of entered data and 48 columns of entered data. How many cells are there in the data region?

2

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?

3

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?

4

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?

89 Questions·
multiple choicemultiple correct

Sample Questions

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 practice questions are there for Electronic Spread Sheet?
There are 89 questions on Electronic Spread Sheet. Try the 4-question sample quiz on this page first; each answer shows an explanation when you tap it.

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.