Class name Subject Book title Chapter number Content Created at
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 into required cells by copying or importing to Excel worksheet. These data files may be either in text files or non-text files format. Text files c...
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 and delete records. Reprint 2026-27 Computerised Accounting System drop-down lists or using data input form. Using a data form can make data entry ...
Class XII Accountancy Computerised Accounting System 2 2.3 DATA FORMATTING Formatting of spreadsheets makes easier to read and understand he important information (e.g. conditional formatting, number fo...
Class XII Accountancy Computerised Accounting System 2 to the current selection is shown at the top of the box. Select the Category required i.e. Currency. The right hand side of the box shows the diffe...
Class XII Accountancy Computerised Accounting System 2 digit numbers or one hundred digit numbers will be display with a comma sign which makes it Figure 2.52(g) easier to read. Excel also allows more p...
Class XII Accountancy Computerised Accounting System 2 allow us to add decorative and explanatory material to worksheet and chart. How the Illustrations Tools or Text Tools can be used; let us understan...
Class XII Accountancy Computerised Accounting System 2 Cell Styles. 2. Click New Cell Style. 3. In the Style name box, type an appropriate name for the new 60 cell style. 4. Click Format. Reprint 2026-2...
Class XII Accountancy Computerised Accounting System 2 it easy to highlight interesting cells or ranges of cells, emphasise unusual values, and visualise data by using data bars, colour scales, and icon...
Class XII Accountancy Computerised Accounting System 2 conditional format, click New Rule. The New Formatting Rule dialog box is displayed. ▪ To change a conditional format, do the following: Figure2.52...
Class XII Accountancy Computerised Accounting System 2 Maximum Value. The formula must return a number, date, or time value. Start the formula with an equal sign (=). It’s a good idea to test the formul...
Class XII Accountancy Computerised Accounting System 2 to format the newly added cells to match the original ones. • Use of AutoFormat Option To quickly apply a number of formatting features to a spread...
Class XII Accountancy Computerised Accounting System 2 Page Setup. The Page Setup dialog box appears. 3. Select the Sheet tab. 4. In the Print Area text box, type the range of cells you want to print or...
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 negative value, we can display the value by formatting the cell with a format that is not a date or time format. 1. On the Home tab, in the Cells g...