Skip to main content
Chapter 36 of 38
Practice Quiz

Use Of Spreadsheet In Business Applications — Practice Quiz

NIOS · Class 12 · Accountancy

4 MCQs on Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy: tap an answer to check it and see why.

87 questions38 flashcards7 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Use Of Spreadsheet In Business Applications? 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: Use Of Spreadsheet In Business Applications

0/4

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

1

A spreadsheet payroll sheet has Basic Pay of Rs. 18,000, NOEDP of 26 days, and NODM of 30 days. Find Basic Pay Earned (BPE).

2

An employee has BPE of Rs. 20,000 and the applicable DA rate is 35% for the month. Find Dearness Allowance (DA).

3

BPE is Rs. 16,500 and the HRA rate is 20% for the month. Find House Rent Allowance (HRA).

4

BPE is Rs. 22,500, DA is Rs. 7,875, HRA is Rs. 4,500, and TRA is Rs. 1,250. Find Total Earnings (TE).

87 Questions·
multiple choicemultiple correct

Sample Questions

1multiple choice
3 marks

BPE is Rs. 19,200 and PF rate is 12%. Find Provident Fund (PF).

Show answer

Rs. 2,304

Use PF = BPE × PF Rate. So PF = 19,200 × 12/100 = Rs. 2,304.

2multiple choice
3 marks

PF is Rs. 2,304, TDS is Rs. 1,500, and LOAN is Rs. 700. Find Total Deductions (TD).

Show answer

Rs. 4,504

Use TD = PF + TDS + LOAN. So TD = 2,304 + 1,500 + 700 = Rs. 4,504.

3multiple choice
3 marks

Total Earnings are Rs. 36,125 and Total Deductions are Rs. 4,504. Find Net Salary (NS).

Show answer

Rs. 31,621

Use NS = Total Earnings - Total Deductions. So NS = 36,125 - 4,504 = Rs. 31,621.

4multiple choice
3 marks

An employee has 30 days in a month, 2 days of leave without pay, and 1 day of unauthorised absence. Find NOEDP.

Show answer

27 days

Use NOEDP = Number of Days in a Month - Leave without Pay - Unauthorised Absence. So NOEDP = 30 - 2 - 1 = 27 days.

+83 more questions on Use Of Spreadsheet In Business Applications (NIOS Class 12 Accountancy)

Practise All

Frequently Asked Questions

What are the important topics in Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy?
Key topics in Use Of Spreadsheet In Business Applications include Payroll Accounting, Payroll Components, Payroll Calculation Elements, Depreciation. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How many practice questions are there for Use Of Spreadsheet In Business Applications?
There are 87 questions on Use Of Spreadsheet In Business Applications. 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 Use Of Spreadsheet In Business Applications chapter — start free.

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