Class name Subject Book title Chapter number Content Created at
Class XII Accountancy Computerised Accounting System 2 then click Show Calculation Steps if it appears. Reasons and Solutions a. Missing data, and #N/A or NA() has been entered in its place. b. Giving a...
Class XII Accountancy Computerised Accounting System 2 that a comma separates the two ranges (SUM (A1:A10, C1:C10)). Ranges do not intersect ▪ If there are no squares at each corner of the colour-coded ...
Class XII Accountancy Computerised Accounting System 2 by other formulas, or pasting moved cells over cells referred to by other formulas. ▪ Change the formulas, or restore the cells on the worksheet by...
Class XII Accountancy Computerised Accounting System 2 ENTER. ▪ Select the cell or range of cells that contains the array formula (array formula: A formula that performs multiple calculations on one or ...
Class XII Accountancy Computerised Accounting System 2 row position, for example B4 is the intersection of column b and row 4. • In the earliest spreadsheets, cells were a simple two-dimensional grid. O...
Class XII Accountancy Computerised Accounting System 2 all the cells in the range A1 through to A6. A formula such as “=SUM (A1:A6)” would add all the cells specified and put the result in the cell cont...
Class XII Accountancy Computerised Accounting System 2 every 5 minutes. The first time we save, go to the File Menu and pull to Save, make sure the document is in the correct folder and on the correct d...
Class XII Accountancy Computerised Accounting System 2 Centre d. Decimal 12. Which function automatically totals a column or row of values? a. TOTAL b. ADD c. SUM 82 d. AVG Reprint 2026-27 Spreadsheet 1...
Class XII Accountancy Computerised Accounting System 2 how they are created? 19. Write down the differences between formula and function? Q3. S KILL R EVIEW A. You had started your own online business t...
Class XII Accountancy Computerised Accounting System 2 to Rs. 45,000, micro wave ovens, water coolers, geezers and air coolers are from Rs. 8,000 to Rs. 25,000 and Air Conditioners are from Rs. 18,000 t...
Class XII Accountancy Computerised Accounting System 2 c Reprint 2026-27
Class XII Accountancy Computerised Accounting System 3 U SE OF S PREADSHEET IN B USINESS A PPLICATIONS After studying this chapter you will bentroduction able to use spreadsheet for: In the previous cha...
Class XII Accountancy Computerised Accounting System 3 the pay scale plus Grade Pay, but does not include Special Pay. ▪ Grade Pay (GP) : It is the pay to be added to the Basic Pay according to the Desi...
Class XII Accountancy Computerised Accounting System 3 signified by the employee for deduction on account of any loan taken up by him/her. ▪ Any Other Deduction : It may include any other deduction not ...
Class XII Accountancy Computerised Accounting System 3 is the total of all the above deductions. Thus, TD = PF + TDS + LOAN 89 Reprint 2026-27 Computerised Accounting System The Net Salary (NS) is the a...
Class XII Accountancy Computerised Accounting System 3 Nonsupervisory (Emp Type = “Nsup”) are entered in the cells G7 and G8, respectively. • PF Rate (in %) is entered in the cell G9. Notes • In columns...
Class XII Accountancy Computerised Accounting System 3 = G12+H12+I12+J12 N Provident Fund PF = BPE * PF Rate (in %) = G12*$I$9 O Tax Deduction at Source TDS Value entered directly P Loan Repayment Inst....
Class XII Accountancy Computerised Accounting System 3 do not have a physical dimension such as patents, copyrights, trade mark, etc. The depreciation on fixed assets is provided to recognise the cost o...
Class XII Accountancy Computerised Accounting System 3 may use either of the method and applicable rates. Let us now understand the computation of depreciation using the two methods. 3.2.2.1 Straight Li...
Class XII Accountancy Computerised Accounting System 3 Value Salvage Val Value entered directly I Life of Asset in Years Life in Yrs Value entered directly K Depreciation Amount Depr. =SLN(G5,H11,I11) F...
Class XII Accountancy Computerised Accounting System 3 End Date is entered in cell-F3 • First-Half Year End Date is entered in cell-I3 Column Column Abbre. Ref First line shows Requir ed For mula Headin...
Class XII Accountancy Computerised Accounting System 3 3.8 a; while second part shows columns H to M are shown in Figure 3.8 b. The “Asset Name” is repeated in both the figures: Figure 3.8 a : Partial S...
Class XII Accountancy Computerised Accounting System 3 Figure 3.10 a; while second part shows columns F to K are shown in Figure 3.10 b. The “Asset Name” is repeated in both the figures: Figure 3.10 a: ...
Class XII Accountancy Computerised Accounting System 3 2026-27 Computerised Accounting System Column Column Heading First line shows Required Formula Second line refers the cell content A Loan Amt. Valu...
Class XII Accountancy Computerised Accounting System 3 is determined whether a direct value is to be entered or else it is to be computed using a formula. • Excel has a rich library of various built-in ...