Class name Subject Book title Chapter number Content Created at
Class XII Accountancy Computerised Accounting System 1 and also ensures data integrity. Basically, this feature is similar to Audit Trail. Data Vault: Software provides additional security through data ...
Class XII Accountancy Computerised Accounting System 2 as “Active Worksheet” and that worksheet is available to a user for carrying out operations. An active worksheet’s name will be shown in bold lette...
Class XII Accountancy Computerised Accounting System 1 information about changes in the cost that takes place during the period under review. Reprint 2026-27 Overview of Computerised Accounting System 1...
Class XII Accountancy Computerised Accounting System 1 an integration of various sub-systems such as: (i) cash sub-system, (ii) sales and accounts receivable sub-system, (iii) inventory sub-system, (iv)...
Class XII Accountancy Computerised Accounting System 1 (c) Keeping data and information secured 14 (d) None of the above. Reprint 2026-27 Overview of Computerised Accounting System 7. Method of Codifica...
Class XII Accountancy Computerised Accounting System 1 is best suited? 7. Define the term transaction and elaborate with the help of examples how the transaction will be shown in chart of accounts by hi...
Class XII Accountancy Computerised Accounting System 2 S PREADSHEET Learning Objectives Introduction After studying this chapter you will A spreadsheet is a configuration of rows and able to understand:...
Class XII Accountancy Computerised Accounting System 2 quote or a database value. The value rule according to computer scientist Alan Kay implies in spreadsheet. It states that a cell’s value relies sol...
Class XII Accountancy Computerised Accounting System 2 In case any basic values are for mula bar modified, the derived values as a result are revised accordingly. This feature of Spreadsheets enables us...
Class XII Accountancy Computerised Accounting System 2 identifies the calculation needed to place the result in the cell it is 22 contained within. A cell E3 containing a formula, therefore it has two d...
Class XII Accountancy Computerised Accounting System 2 sections, functions library, defined names, formula auditing and calculation. Figure 2.8(a) 2.1.3 F UNCTIONS A function is a special key word which...
Class XII Accountancy Computerised Accounting System 2 get the sum of. If we want answer in the cell G5 (Figure 2.9(b) use the mouse to click in the cell G5 and click AutoSum button then from keyboard t...
Class XII Accountancy Computerised Accounting System 2 the result 238. Reprint 2026-27 Spreadsheet We will now use these two Named Ranges to calculate the Balance (in cell B7) after using the formula ta...
Class XII Accountancy Computerised Accounting System 2 to be true or false; this requires the usage of a logical operator. A logical operator is one used to perform a comparison between two values and p...
Class XII Accountancy Computerised Accounting System 2 logical_test box ( e.g. E4 > 10000 ) 5. In the value_if_true box type the require value (e.g. 10%) if the logical test condition is met. 6. In the ...
Class XII Accountancy Computerised Accounting System 2 IF() function inside of another. Such as : = IF (logical_test, value_if_true, value_if_false) simple if statement. Let us substitute other IFs IF (...
Class XII Accountancy Computerised Accounting System 2 serial number is the date-time code used by Excel for date and time calculations. Times are represented as fractions of a day. By default January 1...
Class XII Accountancy Computerised Accounting System 2 ignored. (e.g. A2:B5) Reprint 2026-27 Computerised Accounting System Criteria are the form of a number, expression, cell reference, or text that de...
Class XII Accountancy Computerised Accounting System 2 a single text item. The text items can be text strings, numbers, or 34 single-cell references. Figure 2.22(a) Example combining First Name, Reprint...
Class XII Accountancy Computerised Accounting System 2 is between 1 and 100. Otherwise, it displays FALSE. b. =IF(AND(A3>1, A3<100), Displays the number in cell “The value is A3,“The value is out of if ...
Class XII Accountancy Computerised Accounting System 2 array. The Look Up function can be used as an alternative to the IF function for elaborate tests or tests that exceeds the limit for nesting of IF ...
Class XII Accountancy Computerised Accounting System 2 6.39 blue name of Colour respectively. The results of the use of Figure 2.23 LOOKUP function. Function Description (Result) =LOOKUP (4.19, A2:A6, B...
Class XII Accountancy Computerised Accounting System 2 is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). For example, if we want to save Rs. 50,000 to pay...
Class XII Accountancy Computerised Accounting System 2 (pmt * nper) + pv + fv = 0 (1+rate) −1 + fv = C  rate    43 Reprint 2026-27 Computerised Accounting System An annuity is a series of constant...
Class XII Accountancy Computerised Accounting System 2 pv, [fv], [type]) where rate is the interest rate per period, nper is the number of periods, pv is the present value or the amount the future payme...