Class name Subject Book title Chapter number Content Created at
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 is the total of all the above deductions. Thus, TD = PF + TDS + LOAN Reprint 2026-27 Computerised Accounting System The Net Salary (NS) is the amou...
Class XII Accountancy Computerised Accounting System 3 (Emp Type = “Nsup”) are entered in the cells G7 and G8, respectively. • PF Rate (in %) is entered in the cell G9. Notes • In columns I and J, neste...
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. L...
Class XII Accountancy Computerised Accounting System 3 not have a physical dimension such as patents, copyrights, trade mark, etc. The depreciation on fixed assets is provided to recognise the cost of t...
Class XII Accountancy Computerised Accounting System 3 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 Line M...
Class XII Accountancy Computerised Accounting System 3 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: Spreads...
Class XII Accountancy Computerised Accounting System 3 Computerised Accounting System Column Column Heading First line shows Required Formula Second line refers the cell content A Loan Amt. Value entere...
Class XII Accountancy Computerised Accounting System 3 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 fun...
Class XII Accountancy Computerised Accounting System 3 of these is not an argument of the IF function? a. Logical_test. b. Value_if_false. c. Value_when_false. d. Value_if_true. 7. In what cell is the R...
Class XII Accountancy Computerised Accounting System 3 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 ...
Class XII Accountancy Computerised Accounting System 4 G RAPHS AND C HARTS F OR B USINESS DATA Learning Objectives Introduction able to:udying this chapter, you wiIn the previous chapter, you were intro...
Class XII Accountancy Computerised Accounting System 4 mouse click on Start Icon 2. On clicking of Start symbol we will get Programs option; which will provide us access to a list of programs installed ...
Class XII Accountancy Computerised Accounting System 4 the given data by Excel the above steps are essential and important. From the 107 tab on the ribbon we can see that Excel supports many Reprint 202...
Class XII Accountancy Computerised Accounting System 4 are called data markers. Data markers of the same colour constitute a data series. The data series are related data points that are plotted in the ...
Class XII Accountancy Computerised Accounting System 4 the look of a chart. In the Design dialog box, we can click to change chart type, chart layouts and chart styles. One of the options provide for 2-...
Class XII Accountancy Computerised Accounting System 4 that you want, or type a value between 0 (zero) and 360 to specify the angle of the first slice to appear, and then click Close. 17.Click the chart...
Class XII Accountancy Computerised Accounting System 4 we have to present negative values also, which can be put on the opposite side of the axes from origin (Figure 4.10). The intersection of both the ...
Class XII Accountancy Computerised Accounting System 4 Product Lowest Highest (Y-axis). Toothpaste 2345 12344 2. Horizontal (category) axis – Toothbrush 500 5415 (X-axis). 3. Depth (series) axis – (Z-ax...
Class XII Accountancy Computerised Accounting System 4 value to a total while emphasising individual values, but they can contain more than one data series. 4.3 ADVANTAGES IN USING Figure 4.13 GRAPH/CHA...
Class XII Accountancy Computerised Accounting System 4 charts are used to depict the comparison of absolute values of data (e.g. sales, production, etc.) at discrete points (e.g. time intervals, product...