NCERT solutions for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ chapter 3 - Use of Spreadsheet in Business Applications [Latest edition]

Which of the following options in a financial function indicates the interest for a period?

Which of the following arguments in a financial function represents the total number of payments?

What category of functions is used in this formula: =PMT (C10/12, C8, C9,1)

When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?

Which formulae would result in TRUE if C4 is less than 10 and D4 is less than 100?

Which of these is not an argument of the IF function?

In what cell is the Rate for PMT function where = PMT (C8, C9, C10, C11, C12)?

What is the meaning of PV?

State the usage of FV?

What is the purpose of the DB function?

If 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%?

If a sum of Rs. 1000 is likely to be earned after 3 years, calculate its present value (PV).

What is the difference between the WDV method and the SLM method of depreciation?

Describe the two basic methods of depreciation.

What functions of Excel are used for the computation of depreciation?

Explain the importance of absolute addresses.

Explain the importance of relative addresses.

What is the basis of using a relative address?

What is the basis of using an absolute address?

In 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?

Figure 3.3 (a):

Figure 3.3 (b):

In 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 the relative address of F3 instead of its absolute address will lead to the 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.

Prepare 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.

Use a spreadsheet to prepare a 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.

Prepare 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.

Create 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) as 22.5% of Basic Salary, Provident Fund (PF) as 12% of Basic Salary, and Gross Salary as Basic Salary + DA + HRA. The Income Tax (IT) is 20% of Gross Salary, and Net Salary is Gross Salary – (PF + IT) for each employee. Also calculate Total Salary, Average Salary, Maximum Salary and Minimum Salary paid by the company.

In Section 3.3, the loan instalment is computed for a given loan amount 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.