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.
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/4Tap an answer to check it instantly. No sign-up needed for these 4.
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).
An employee has BPE of Rs. 20,000 and the applicable DA rate is 35% for the month. Find Dearness Allowance (DA).
BPE is Rs. 16,500 and the HRA rate is 20% for the month. Find House Rent Allowance (HRA).
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).
Sample Questions
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.
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.
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.
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 AllFrequently Asked Questions
What are the important topics in Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy?
How many practice questions are there for Use Of Spreadsheet In Business Applications?
Sources & Official References
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Use Of Spreadsheet In Business Applications
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Formula Sheet
The chapter's formulas in one place
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 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.