Skip to main content
Super TutorResources
Chapter 9 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
NCERT Solutions

Use of Spreadsheet in Business Applications

CBSE · Class 12 · Accountancy

NCERT Solutions for Use of Spreadsheet in Business Applications — CBSE Class 12 Accountancy.

80 questions80 flashcards5 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 ncert solutions and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

22 Questions Solved · 1 Section

11 worked solutions below. Unlock all 22 free in Super Tutor

EXERCISE

1Which of the following options in a financial function indicates the interest for a period?Show solution
In the PMT-related financial functions, the rate means the interest for a period.

Not sure why a step works? check your working in Super Tutor

2Which of the following arguments in a financial function represents the total number of payments?Show solution
The argument Nper stands for the total number of payments.

Not sure why a step works? check your working in Super Tutor

3What category of functions is used in this formula:
=PMT(C10/12,C8,C9,1)Show solution
`PMT` is an Excel financial function used to compute loan instalments, so the category is Financial.

Not sure why a step works? check your working in Super Tutor

4When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?Show solution
When Extend Selection is active, the shortcut for selecting data up to the last row is [Ctrl]+[Shift] as given in the chapter's answer key.

Not sure why a step works? check your working in Super Tutor

5Which formula would result in TRUE if C4 is less than 10 and D4 is less than 100?Show solution
For the result to be TRUE, both conditions must be satisfied: C4 < 10 and D4 < 100. The correct AND formula is `=AND(C4<10, D4<100)`.

Not sure why a step works? check your working in Super Tutor

6Which of these is not an argument of the IF function?Show solution
The IF function uses Logical_test, Value_if_true, and Value_if_false. Value_when_false is not an argument.

Not sure why a step works? check your working in Super Tutor

7In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C11, C12)?Show solution
In `=PMT(C8, C9, C10, C11, C12)`, the first argument is Rate, so the rate is in C8.

Not sure why a step works? check your working in Super Tutor

1What is the meaning of PV?Show solution
PV means Present Value.

Not sure why a step works? check your working in Super Tutor

2State the usage of FV?Show solution
FV is used to calculate the future value of an amount or investment after a given period at a specified interest rate.

Not sure why a step works? check your working in Super Tutor

3What is the purpose of DB function?Show solution
The DB function is used to compute depreciation by the Written Down Value (WDV) method, also called the Declining Balance method.

Not sure why a step works? check your working in Super Tutor

4If an investment of Rs. 1,000 is made today, ascertain its Future Value (FV) after 2 years if the rate of interest is taken as 10%?Show solution
Use the compound amount formula:

FV=PV(1+r)nFV = PV(1+r)^n

Here, PV=1000PV=1000, r=10%=0.10r=10\%=0.10, and n=2n=2.

FV=1000(1+0.10)2=1000(1.1)2=1000×1.21=1210FV = 1000(1+0.10)^2 = 1000(1.1)^2 = 1000 \times 1.21 = 1210

So the future value is Rs. 1,210.

Not sure why a step works? check your working in Super Tutor

5If a sum of Rs. 1000 is likely to be earned after 3 years, calculate its present value (PV).
6What is the difference between WDV method and SLM method of depreciation?
7Describe the two basic methods of depreciation. What functions of Excel are used for computation of depreciation?
8Explain the importance of absolute and relative addresses. What is the basis of using relative address and absolute address?
1In columns F, G, H, I, J, and N of the Payroll spreadsheet shown in Figure 3.3 (a) and Figure 3.3 (b) the absolute addresses are used. What will happen if relative addresses are used instead of absolute addresses?
2In columns g of the spreadsheet shown in Figure 3.8 b for the depreciation calculation using WDV method (i.e. using DB function), the absolute addresses of cell F3 is used. Taking relative address of F3 instead of its absolute address will lead to wrong result when the formula is copied. Explain the reason and write down the values copied along with the correct values, which should have been copied.
3Prepare attendance record in a spreadsheet for a class of 25 student's month wise for 10 months. Calculate the percentage of presence for each student every month. Prepare a month wise summary of every student and calculate the overall percentage of presence.
4Use spreadsheet to prepare class timetable. It should compute and check the total number of lectures, tutorials and lab practical sessions allocated for each subject. It should also compute and check the total number of hours of engagement for each teacher.
5Prepare the worksheets yourself for examples used in sections 3.1, 3.2, 3.3 and 3.4 respectively. Add two new more records in each worksheet (with your own assumed values) and verify whether the computations are correct.
6Create a worksheet to keep a record of employees of M/s Opportunities Company. Employee details should include Name of Employee, Designation and Basic Salary. Enter 50 records. Calculate Dearness Allowance (DA) as 37.5% of Basic Salary, House Rent Allowance (HRA) 22.5% of Basic Salary, Provident Fund (PF) as 12% of Basic Salary, Gross Salary as Basic Salary + DA+HRA. The Income Tax (IT) as 20% of Gross Salary and Net Salary is Gross Salary – (PF+IT) for each employee. Calculate also Total Salary, Average Salary, Maximum Salary and Minimum Salary paid by the company.
7In Section-3.3, the loan instalment is computed for a given amount of loan repayable over a specified period at a specified rate of interest. Modify this exercise by fixing the loan instalment amount and compute the loan period using the PMT function.

11 more solved questions in Use of Spreadsheet in Business Applications

Every remaining exercise is solved step by step in Super Tutor, plus practice quizzes and flashcards for this chapter. Free to start.

Stuck on a step?

Ask Super Tutor AI to explain any solution on this page in a simpler way — free, 24x7.

Ask a Doubt Free

Frequently Asked Questions

What are the important topics in Use of Spreadsheet in Business Applications for CBSE Class 12 Accountancy?
Use of Spreadsheet in Business Applications covers several key topics that are frequently asked in CBSE Class 12 board exams. Focus on the core concepts listed on this page and practise related questions to build confidence.
How to score full marks in Use of Spreadsheet in Business Applications — CBSE Class 12 Accountancy?
Understand the core concepts first, then work through the 80 practice questions available for this chapter. Revise formulas and definitions regularly, and use flashcards for quick recall before the exam.
Where can I get free NCERT Solutions for Use of Spreadsheet in Business Applications Class 12 Accountancy?
This page has free step-by-step NCERT Solutions for every exercise question in Use of Spreadsheet in Business Applications (CBSE Class 12 Accountancy) — written the way examiners award marks: given, formula, working, answer.

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

All 14 chapters — CBSE Class 12 Accountancy NCERT Solutions

For serious students

Get the full Use of Spreadsheet in Business Applications chapter — for free.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan for CBSE Class 12 Accountancy.

Try Super Tutor Free
Try the full chapter — Free