Class name Subject Book title Chapter number Content Created at
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 e.g. criteria can be expressed 1500, “1500”, “>1500” or “Books”. Sum_range are the actual cells to sum. e.g. There are sum Asset Values (D2:D5) and...
Class XII Accountancy Computerised Accounting System 2 = ROUNDUP (3.2, 0) Rounds 3.2 up to zero decimal places and the value is 4. = ROUNDUP (76.9, 0) Rounds 76.9 up to zero decimal places and value is ...
Class XII Accountancy Computerised Accounting System 2 2.20 Arguments that are error values or text that cannot be translated into numbers are ignored. If an argument is an array or reference, only numb...
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...
Class XII Accountancy Computerised Accounting System 2 made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). Type is the number 0 or 1 and indicates when payment...
Class XII Accountancy Computerised Accounting System 2 investment. NPV is also related to the IRR function 46 (internal rate of return). IRR is the rate for Figure 2.33 which NPV equals zero: NPV (IRR (...
Class XII Accountancy Computerised Accounting System 2 of four types of data in cells: labels, values, date and formulas and data validation. Figure 2.40 Figure 2.41 • Labels (text) are descriptive data...
Class XII Accountancy Computerised Accounting System 2 names list is referred and restrict the users to select accordingly – e.g. In the organisation for a business application we want to restrict the F...
Class XII Accountancy Computerised Accounting System 2 Criteria and to provide valid data List in the Source where we have to type Name of the Range as =DEPT (Figure 2.44). The two more options also Fig...
Class XII Accountancy Computerised Accounting System 2 commas (Figure 2.43) e.g. as to enter the Sex Code either Male of Female for an Employee we can type as =Male, Female. This method of data validati...
Class XII Accountancy Computerised Accounting System 2 follows: ⬧ We can prevent duplicate entries in a range on the worksheet 54 (Figure 2.50) i.e. suppose we check duplicate employee number or duplica...
Class XII Accountancy Computerised Accounting System 2 Print Multiple Ranges Excel facilitates to print non-contiguous ranges. Selected ranges will print on separate pages. 1. Select the first range to ...
Class XII Accountancy Computerised Accounting System 2 If the data table is column-oriented, type the formula (=A2*C1) in the row (row number 4) above the first value (in cell B5) and one 69 cell to the...
Class XII Accountancy Computerised Accounting System 2 P IVOT TABLES The Pivot Table feature allows us to create a cross tabulation summary of data in which heading can subsequently moved to give differ...
Class XII Accountancy Computerised Accounting System 2 : Pivot Table Toolbar Reprint 2026-27 Spreadsheet Advantages of Pivot Table (Report) A PivotTable report is an interactive way to quickly summarise...
Class XII Accountancy Computerised Accounting System 2 the error. If we click Ignore Error, the error is marked to be ignored for each consecutive check. Figure 2.59 6. Repeat the two previous steps. • ...
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...