Spreadsheet Class 12 Notes: Formulas, Functions and Excel Basics

These Spreadsheet Class 12 notes revise Chapter 2 of the NCERT Class 12 Accountancy book, Computerised Accounting System, for the 2026-27 session (Rationalised NCERT). A spreadsheet is a configuration of rows and columns — also called a worksheet — used to record, calculate and compare numerical or financial data.

Every value in it is either basic (typed independently) or derived (computed from other values through an arithmetic expression or a function).

One edition note matters before revision: the chapter teaches MS-Excel 2007 with 65,536 rows, 256 columns, the Ribbon interface and the Office Button. Later Excel versions provide more than a million rows and use a File tab instead of the Office Button, but every concept here — cell references, formulas, functions, named ranges, what-if analysis — works the same way in current versions.

The grounded scope of these notes runs from page 17 to page 50 of the chapter.

What a Spreadsheet Is, and the Chapter Roadmap

A spreadsheet is recorded, calculated and compared data arranged as rows (horizontal vectors) and columns (vertical vectors). A spreadsheet application is the computer program that lets you enter and process that data; the book explains everything through MS-Excel, a member of the Microsoft Office Suite (NCERT, p. 17).

Excel 2007 uses a redesigned interface built around a series of horizontal tabs called the Ribbon. The Office Button (upper-left corner) handles opening an old workbook, creating a new one, saving, and printing — jobs the old File menu used to do (NCERT, p. 17-18).

Figure 2.1 shows the Excel 2007 window: the Ribbon of horizontal tabs across the top organises commands, and the Office Button in the upper-left opens, creates, saves and prints workbooks. The chapter then teaches a small number of building blocks that this page follows in the same order:

• Worksheet basics — workbook, sheets, active worksheet
• Cells and references — row/column addresses, relative, absolute and mixed references
• Values and labels — basic versus derived values, auto-detected data types
• Formulas — the mandatory = sign and the order of operations
• Functions — SUM, AVERAGE, COUNT and the twelve-category function library
• Named ranges and IF / nested IF — readability and conditional logic
• Function groups — date, mathematical, text, logical, lookup and financial
• Data entry, fill options and importing text data

If you are revising the whole book, read the overview of the computerised accounting system first (Chapter 1), then this chapter, then graphs and charts (Chapter 3). Browse all subjects from our CBSE notes index, or jump straight to the Class 12 notes and the Class 12 Accountancy notes hub.

Workbook, Worksheets and the Active Sheet

Understand the file structure first: a workbook is simply an Excel file, and it holds a collection of worksheets (NCERT, p. 18). By default, three sheets — Sheet 1, Sheet 2, Sheet 3 — are available. Only one worksheet can be active at a time, and the active worksheet is the one you can operate on.

Figure 2.2 shows the sheet tabs at the bottom of the workbook window. The name of the active worksheet appears in bold on its Sheet Tab at the bottom left.

• Add a sheet: click the Insert Worksheet icon next to the tabs.
• Rename a sheet: right-click the sheet name, then choose Rename.

Cells, Cell Addresses, Ranges and Navigation

In Excel 2007, rows are numbered 1 to 65,536 from top to bottom, and columns are lettered A to IV from left to right — 256 columns in all. That gives roughly 1,65,00,000 cells per sheet, the book’s own approximation (NCERT, p. 19).

Figure 2.3 shows the grid: row numbers run down the left, column letters across the top. A cell is the intersection of a row and a column — the first cell, A1, sits at row 1 under column A. Each cell has a unique cell address (a letter plus a number, such as G8).

When Excel starts, the cursor points at A1; that cell is the active cell (NCERT, p. 19).

A range is a group of cells named by its upper-left and lower-right corners separated by a colon — A1:E2 tells Excel to include every cell between A1 and E2. Cell references are used in formulas, functions, charts and other Excel commands (NCERT, p. 19).

The three reference types, and what copying does to each

Think of a relative reference as directions — “two cells above me” — and an absolute reference as a fixed landmark that never moves. The default is relative: copy a formula and its references adjust to the new location. Lock a cell with dollar signs ($C$4) to keep it fixed.

A mixed reference locks only one part: $C4 fixes the column, C$4 fixes the row (NCERT, p. 19).

Navigating the worksheet with keystrokes

The mouse handles almost everything except data entry, but these key strokes move the cursor faster (NCERT, p. 20):

Values, Labels and the What-If Idea

The chapter’s first idea is the difference between a basic and a derived value (Box 2.1, NCERT p. 18). If quantity Q of an item is bought at price P, then \[ V = Q \times P \]

P and Q are basic values (entered directly); V is the derived value because it is obtained by multiplying Q with P; and Q × P is called an arithmetic expression. An arithmetic expression may itself contain one or more functions (NCERT, p. 18).

Excel also auto-detects what you type. Enter 306 and it is taken as numeric; enter Asset and it is alpha-numeric; enter 12/07/08 and it is treated as a date (NCERT, p. 20-21).

Figure 2.5 illustrates exactly that: the same worksheet shows a number, a text word and a date, each recognised by its own nature. Labels (NCERT, p. 22) are the text or descriptive entries — anything beginning with A-Z, such as Principal Amount or Maturity Amount — and they cannot be used in arithmetic: labels cannot be multiplied or subtracted.

The value rule, credited to computer scientist Alan Kay (NCERT, p. 21), states that a cell’s value relies solely on the formula the user typed into that cell. That formula may depend on other cells, but those are likewise restricted to entered data or formulas.

There are no side effects: the only output is the calculated result displayed in the cell, and nothing else is modified unless you change it manually.

A what-if scenario is what this rule makes possible: change one or more input (basic) values and all derived values revise themselves automatically, so you can examine the cause (if) and effect (what) of variations in inputs (NCERT, p. 22). Think of a spreadsheet as a calculator with visible wiring: touch any input and every connected output recalculates instantly.

The chapter’s planning step matters before you type anything: decide which cells will hold values and which cells will hold the relationships (formulas), and only then enter the data (NCERT, p. 21).

Reading Figure 2.6: The Compound Interest Worksheet Layout

The book’s running example — compound interest and maturity amount on a fixed deposit — is the best demonstration of that planning step. Six cells are defined with column headings (NCERT, p. 21):

• Principal Amount (PA) — column B
• Rate of Interest (r) — column C
• Period of Compounding (CP) — column D
• Period in years (NY)
• Maturity Amount (MA) — column E
• Compound Interest (CI) — column F

Figure 2.6 shows the finished fixed-deposit layout for yearly compounding. The basic values are typed directly into B4 (principal), C4 (rate) and D4 (compounding periods). The derived values MA and CI are computed by formulas in E4 and F4, and when you select a derived cell, its formula is visible in the formula bar.

Change any basic value (say, the rate in C4) and E4 and F4 revise automatically — that automatic recalculation is the mechanism behind every what-if scenario.

The chapter’s formulas, in the book’s notation, are (NCERT, p. 21-22):

\[ MA = PA \times \left(1 + \frac{R}{100 \times CP}\right)^{R \times CP} \]

\[ CI = MA – PA \]

Symbol meanings: PA = principal amount in rupees, R = annual rate of interest in percent, CP = compounding periods per year, MA = maturity amount, CI = compound interest. The planning lesson: define cell headings first, enter basic data, then enter the relationships — the order is the method.

Formulas and the Order of Mathematical Operations

A formula is a mathematical calculation on a set of cells, and it must start with an = sign (NCERT, p. 22). In the book’s example the cell E3 holds =D1+E1/F1*G1 and displays the value 16.

A formula cell has two display components: when you click the cell, the formula bar shows the formula itself; at all other times the cell shows the resulting value (NCERT, p. 22-23).

Figure 2.7 shows the two components side by side: the formula bar carries =D1+E1/F1*G1 while the cell displays the computed 16. A spreadsheet without any formulas is only a row-and-column list of data, like a calendar or timetable (NCERT, p. 23).

Excel follows the rules of algebra for the order of operations (NCERT, p. 23):

1. Operations inside brackets are carried out first.
2. Exponents come next.
3. Division and multiplication are equal in importance and run left to right.
4. Addition and subtraction are equal and also run left to right.

Why the order matters: in 2+3*4, multiplication runs first, so the result is 14 — not 20. The three mnemonics the book lists (GEMS, PEMDAS, BEMDAS) all describe the same five-step order:

The Formula tab of the ribbon contains four sections: functions library, defined names, formula auditing and calculation (NCERT, p. 23). Functions live in the first of these, covered next.

Functions: Excel’s Built-In Formulas

A function is a special key word you enter into a cell to process the data written inside its brackets — in effect a built-in set of formulas, entered as =FunctionName(Data) (NCERT, p. 23-24). Every function involves four issues you should be able to state for any function you use:

• Name of the function
• Purpose of the function
• The arguments (data) it needs to do its job
• The result it returns

SUM, AVERAGE and COUNT are the easiest functions. Each applies to a range of cells containing numbers (blank cells are allowed but text is not) and returns, respectively, the arithmetic total, the average (mean) value, or the quantity of values in the range (NCERT, p. 24). The AutoSum (Σ) button automates summation.

In the book’s example, clicking AutoSum at G5 and typing the range D1:G1 puts the answer 17 in G5 — the formula bar then shows =SUM(D1:G1) (NCERT, p. 24).

Figure 2.9(b) shows that AutoSum result: the range D1:G1 is marked, the total 17 appears in G5, and =SUM(D1:G1) is visible in the formula bar. AutoSum also offers AVERAGE, MIN, MAX and COUNT.

Excel 2007 provides twelve categories of functions on the ribbon (NCERT, p. 25). The book flags six of them as useful in computerised accountancy:

Figure 2.13 shows the categorised function library on the Formula tab, where the twelve categories appear grouped on the ribbon. Each family is examined in its own section below.

Named Ranges: Working with Names Instead of Cell Addresses

A named range replaces a cell range with a descriptive name, which saves time when writing complex formulas and makes them readable: =SUM(Numbers) is easier to remember than =SUM(B1:F1) (NCERT, p. 25). Behind the name, Excel still hides the cell references.

The steps for defining a name (NCERT, p. 25-26):

1. Select the cells to be named (for example B1:F1).
2. Click the Formula tab on the ribbon.
3. Select Define Name and click it.
4. In the New Name dialog, type the name (say, Numbers) in the Name window; the Refers to window shows $B$1:$F$1.
5. Click OK; the name now appears in the Name Box.
6. To use it, click Apply Names and choose the range name.

Figure 2.10(d) shows that New Name dialog: the Name window holds the descriptive name and the Refers to window shows the absolute address $B$1:$F$1. The grounded results to remember from the book’s sequence:

• =SUM(Numbers) in D3 totals the named range B1:F1 (NCERT, p. 26).
• =SUMIF(Numbers, “<6”) adds only the numbers less than 6 in that range and returns 9 (NCERT, p. 26).
• With two named ranges, =SUM(Monthly_Totals) (cells B2:B5) returns 1158 and =SUM(Monthly_Tax) (cells C2:C5) returns 238 (NCERT, p. 26-27).
• The balance cell B7 holds =Total_of_Month – Total_of_Tax, where those two names refer to B6 and C6 (NCERT, p. 27).

To stop recalculation and keep the present calculated values, freeze the formulas: select the formula cells (B6:C6, B7), go to Home → Copy → Paste Special, choose the Values radio button and click OK. This permanently removes the formulas and keeps only the current results (NCERT, p. 27) — the standard way to save a snapshot that must not change.

IF and Nested IF: Building Conditions into Cells

The IF function returns one value if a specified condition evaluates to TRUE and a different value if it evaluates to FALSE. Its format (NCERT, p. 27-28):

=IF(logical_test, value_if_true, value_if_false)

• logical_test — the value or expression judged true or false; it requires a logical operator ( =, <, <=, <>, >, >= ). There is no middle result: something is either true or false.
• value_if_true — returned when the test is true; can be a value, text, expression, formula, or a reference to another cell.
• value_if_false — returned when the test is false; same possibilities.

Book examples to recognise instantly: =IF(A1<20,”Yes”,”No”) returns Yes when A1 is below 20; =IF(C2>B2,(C2+D2)/2,(B2+D2)/2) returns (C2+D2)/2 if C2>B2, otherwise (B2+D2)/2 (NCERT, p. 28). The book’s saving-percentage table decides a value column: when the total crosses ₹10,000 the entry shows 10%, otherwise 5%, written as =IF(E4>10000, 10%, 5%) (NCERT, p. 28).

Figure 2.12(b) shows the Function Arguments dialog that walks a user through IF: type the condition in logical_test, the true-branch value, then the false-branch value, and click OK. This dialog is how the ribbon builds IF expressions step by step.

Nested IF for several conditions

When one condition is not enough, put an IF inside another IF: =IF(logical_test, IF(logical_test, IF(…), value_if_false), value_if_false) (NCERT, p. 29).

The book’s marks example, where E2 holds the marks and F2 the result, is =IF(E2<96, IF(E2<91, IF(E2<55,”Fail”,”C Grade”), “B Grade”), “A Grade”) Trace it: below 55 → Fail; 55-90 → C Grade; 91-95 → B Grade; 96 or more → A Grade.

The critical rule about nesting: if a nested function is used as an argument, it must return the same type of value that the argument uses. If the argument expects a TRUE/FALSE result and the nested function returns something else, Excel displays the #VALUE! error in the cell (NCERT, p. 29).

Date, Mathematical and Text Functions

Date and time functions

Excel stores dates as serial numbers so they can be calculated. By default, January 1, 1900 is serial number 1; January 1, 2009 is 39814 because it is 39,814 days later (NCERT, p. 30).

• TODAY() — returns the serial number of the current date.
• NOW() — like TODAY but includes the current time (times are fractions of a day).
• DAY(serial_number) — the day of the date, an integer 1 to 31 (a date of 16-Apr-2009 gives 16).
• MONTH(serial_number) — the month, 1 (January) to 12 (December).
• YEAR(serial_number) — the year, 1900 to 9999.
• DATEVALUE(date_text) — converts a date written as text into a serial number; =DATEVALUE(“16-04-2009”) returns 39919 (NCERT, p. 30).

The book’s age example divides the difference of two dates by 365.25 — the fraction allows for leap years — to convert days into years (NCERT, p. 31).

Figure 2.17 shows that age layout: the date difference sits in D3, and dividing it by 365.25 expresses the age in years, leap years included.

Mathematical functions

SUMIF(range, criteria, sum_range) adds only the cells that satisfy a criterion. The criteria can be a number, an expression or text — for example 1500, “>1500” or “Books” (NCERT, p. 31).

The book’s grounded depreciation example: asset values are in D2:D5 and their depreciation in E2:E5, and =SUMIF(D2:E5, “>150000”, E2:E5) adds the depreciation of asset values above ₹1,50,000 and returns ₹63,000 (NCERT, p. 31).

Figure 2.18 shows the depreciation worksheet behind that formula: the range D2:D5 holds asset values, E2:E5 the related depreciation, and the SUMIF result 63,000 appears in E7.

ROUND(number, num_digits) rounds a number to a specified number of digits (NCERT, p. 31). The three cases for num_digits:

• Greater than 0 — round to that many decimal places: =ROUND(3.14159, 2) gives 3.14.
• Equal to 0 — round to the nearest integer: =ROUND(21.5, 0) gives 22.
• Less than 0 — round to the left of the decimal point: =ROUND(147, -2) gives 100.

ROUNDUP rounds away from zero (3.2 → 4 at 0 digits) while ROUNDDOWN rounds toward zero (3.2 → 3), and both accept negative num_digits the same way ROUND does (NCERT, p. 32).

The COUNT family decides what counts (NCERT, p. 32-33):

• COUNT counts only cells containing numbers — dates count as numbers; text, blank cells, logical values and error values are ignored.
• COUNTA counts every non-blank entry, including text, logical values and errors.
• COUNTBLANK counts only the empty cells.
• COUNTIF(range, criteria) counts cells in a range that meet one criterion, written as 32, “>32”, “apples” or a cell reference (NCERT, p. 33-34).

Two dimension functions support array work: ROWS(array) returns the number of rows and COLUMNS(array) the number of columns in a reference or array. An array is a group of arguments arranged in rows and columns; an array formula performs multiple calculations and is enclosed in braces { } and entered by pressing CTRL+SHIFT+ENTER (NCERT, p. 33).

Text functions

TEXT(value, format_text) converts a numeric value to text in a specific number format (NCERT, p. 34). If cell L1 holds 23.5, then =TEXT(L1, “Rs 0.00”) displays Rs 23.50. CONCATENATE(text1, text2, …) joins 2 to 255 text items into one text string — the book’s example builds each employee’s Full Name from First Name, Middle Name and Last Name cells (NCERT, p. 34-35).

Logical and Lookup Functions: AND, OR, LOOKUP, VLOOKUP, HLOOKUP

AND and OR

AND returns TRUE only if every argument is TRUE; OR returns TRUE if any argument is TRUE. Both accept up to 255 logical values (NCERT, p. 35-36). The classic exam-style combination wraps AND inside IF as the logical test:

=IF(AND(A2>1, A2<100), A2, “The value is out of range.”) With A2 holding 50, the function returns 50; for a value outside 1-100 it returns the message (NCERT, p. 35).

LOOKUP: vector and array forms

The vector form, LOOKUP(lookup_value, lookup_vector, result_vector), searches a one-row or one-column range and returns a value from the same position in a second range (NCERT, p. 36). Two rules decide its results:

• The lookup_vector must be in ascending order (-2, -1, 0, 1, 2 or A-Z), otherwise LOOKUP may return a wrong value (NCERT, p. 37).
• If no exact match exists, LOOKUP matches the largest value less than or equal to the lookup value; if the lookup value is smaller than the smallest vector value, it returns #N/A (NCERT, p. 37).

The book’s colour-frequency table (NCERT, p. 37) shows this: =LOOKUP(4.19, A2:A6, B2:B6) returns orange; =LOOKUP(5.00, …) also returns orange (the largest value ≤ 5.00 is 4.19); =LOOKUP(0, …) returns #N/A.

The array form, LOOKUP(lookup_value, array), searches the first row or first column of the array depending on its shape — if the array is wider than tall it searches the first row, otherwise the first column (NCERT, p. 37-38).

VLOOKUP and HLOOKUP

VLOOKUP (vertical lookup) searches the first column of a table and returns a value from any cell on the same row (NCERT, p. 38).

=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• lookup_value — the value searched in the first column; if it is smaller than the smallest first-column value, VLOOKUP returns #N/A.
• table_array — two or more columns of data; use a range reference or a range name.
• col_index_num — the column of the table to return from (1 = first column, 2 = second, and so on). Less than 1 gives #VALUE!; greater than the number of columns gives #REF! (NCERT, p. 38-39).
• range_lookup — FALSE demands an exact match (the first column need not be sorted; if two values match, the first found is used). TRUE or omitted permits an approximate match, but then the first column must be sorted ascending or results go quietly wrong (NCERT, p. 39).

The employee example (NCERT, p. 39) uses =VLOOKUP(A3, A1:D7, 4, FALSE): for employee code 3456 in A3, the fourth column (Basic Pay) returns 3,453.00.

HLOOKUP (horizontal lookup) is the twin that searches the first row of a table and returns a value from the same column in another row (NCERT, p. 40). Its syntax is =HLOOKUP(lookup_value, table_array, row_index_num, range_lookup). The book’s budget example pulls each quarter’s budget from Worksheet 1 into Worksheet 2:

=HLOOKUP(C4, Budget!$A$1:$E$2, 2, FALSE) Read it: C4 is the quarter, Budget! is the sheet holding the table, $A$1:$E$2 is the absolute table array, 2 is the row to return, and FALSE asks for an exact match (NCERT, p. 40-41).

The chapter’s caution applies to all lookup functions: table arrays should be converted to absolute cell references so the range does not shift when formulas are copied (NCERT, p. 41).

Financial Functions for Accountancy

Business input frequently contains dates, interest rates and tax percentages, while output needs age, depreciation, future value and net present value — exactly what the financial library provides (NCERT, p. 29). Two cross-cutting rules govern all of them:

• Match units: rate and nper must use the same time unit. A monthly payment plan over 48 months needs the monthly rate 10%/12 with nper = 48 (NCERT, p. 43).
• Sign encodes direction: money you pay out is entered negative, money you receive positive. The book’s car-loan example enters pmt = -263.33 for a monthly payment (NCERT, p. 43).

Excel solves one financial argument in terms of the others through this underlying equation (NCERT, p. 43):

\[ pv \times (1 + rate)^{nper} + pmt \times (1 + rate \times type) \times \frac{(1 + rate)^{nper} – 1}{rate} + fv = 0 \]

When rate is 0, the same equation reduces to pmt × nper + pv + fv = 0 (NCERT, p. 43). This is why a negative pmt balances a positive pv — signs are the equation’s built-in direction code.

Function-by-function reference

The formula behind ACCRINT, as the book prints it, is (NCERT, p. 42):

\[ ACCRINT = par \times \frac{rate}{frequency} \times \sum \frac{A’}{NL} \]

And NPV is built from the discounted sum of the cash flows (NCERT, p. 46):

\[ NPV = \sum_{i=1}^{n} \frac{values_i}{(1 + rate)^i} \]

Which function to reach for

Also note the PV-versus-NPV distinction the book draws: PV requires constant cash flows through the investment, while NPV accepts variable cash flows, which is why NPV is the tool for uneven project returns (NCERT, p. 46).

Data Entry, Fill Options and Importing Text Data

Input data — payroll parameters such as month name, working days or DA% — must be correct, accurate and in proper format before the software processes it (NCERT, p. 47). Two defaults to memorise:

• Numbers are right-aligned in a cell by default.
• Text is left-aligned by default.

Excel also recognises a date, currency or percentage value on entry. Type 16/04/1980 and the spreadsheet treats it as a date and acts accordingly (NCERT, p. 47).

Filling a series with the fill handle

The fill handle is the small black square in the lower-right corner of a selection; when you point at it, the pointer becomes a black cross. Dragging it fills adjacent cells with a continued series (NCERT, p. 47-48). The book’s example: if A1 holds 10 and A2 holds 20, dragging the fill handle from A2 down to A10 produces 10, 20, 30, … 100 in steps of 10.

Figures 2.34 and 2.35 show that drag method: 10 and 20 are already entered, and dragging the handle continues the series to 100. The same effect is available through Home → Fill → Series, where Step Value 10 and Stop Value 100 fill the range automatically (NCERT, p. 48-49). Date series fill the same way once the cells are formatted as dates via Format Cells.

Importing data from a text file

Data can also be copied or imported from text files, which a text editor such as Notepad reads directly. Such files often carry the extension .txt or .csv — Comma Separated Values (NCERT, p. 49). The outline of the import route:

1. Create the data file in Notepad: one line = one row; entries separated by commas = columns; the first line can hold the column names.
2. Open a new Excel worksheet from the Office Button.
3. Select the Data tab on the ribbon.
4. Choose Get External Data → From Text and select the Notepad file.
5. Excel places each comma-separated value into its own column and row (NCERT, p. 49-50).

Figure 2.40 shows the From Text step of that process — the dialog that locates the .csv file and converts it into worksheet rows and columns. This import idea leads to the chapter’s final classification: a cell holds four kinds of data (NCERT, p. 50):

• Labels (text) — descriptive data such as names and months; left-aligned.
• Values (numbers) — whole or decimal values, right-aligned. A trailing zero note: entering 246.70 displays as 246.7 unless you change the display format.
• Formulas — instructions for Excel to perform calculations.
• Dates — entering 16/12 displays as 16-Dec while the formula bar shows 16/12/2008 (the exact format depends on the country-specific format setting).

Spreadsheet Definitions at a Glance

Revise every key term from one table. Meanings are given in student-friendly wording, each with a concrete example and the chapter page for lookup.

Formula and Function Syntax to Memorise

This consolidated reference groups every formula and function signature in the chapter. Function names are written in capitals exactly as Excel expects them.

Core model formulas

General functions

Financial functions

Where a printed signature differs from what you remember, check the official NCERT PDF of this chapter (leca102.pdf) on ncert.nic.in — these tables follow its printed syntax.

Worked Examples: Solving with Original Numbers

Example 1: Stock value and total using V = Q × P, SUM and ROUND

Method: plan the cells first — enter basic values in columns B and C, then put the relationship (formula) in column D, exactly as the chapter’s planning step teaches.

A stationery list has four items with quantities and rates:

Example 2: IF-based sales incentive

Method: use IF to apply two commission rates — 8% for monthly sales of ₹50,000 or more, else 4%.

Example 3: VLOOKUP pay lookup

Method: retrieve an employee’s basic pay from a code table with an exact-match VLOOKUP.

The employee table occupies A2:D6:

Common Mistakes Students Make in Spreadsheet Work

Each trap below is stated as mistake → correction → reason, with the chapter page that explains the fix.

How to Write Good Answers on This Chapter

The questions this chapter produces fall into a few shapes. These presentation rules work for all of them.

1. Definition questions: open with the textbook-level definition in your own words, then attach one concrete detail that proves you know the behaviour, not just the wording. For “active cell”, add: “the active cell is A1 when Excel starts” (p. 19). For “label”, add: “labels begin with A-Z and cannot be used in arithmetic” (p. 22).
2. Difference-between questions (relative vs absolute, COUNT vs COUNTA, PV vs NPV): answer in two columns. Define each term, then state the behavioural consequence — what happens on copy, what gets counted, which cash flows each function allows (p. 19, p. 33, p. 46). A difference answer without a consequence is a list, not a comparison.
3. Write-the-steps questions: quote the ribbon path exactly as the chapter uses it — Formula tab → Define Name (p. 25), Home tab → Copy → Paste Special → Values (p. 27), Home tab → Fill → Series (p. 48), Data tab → Get External Data → From Text (p. 49). State the step before the path: select the cells, then choose the command, then confirm.
4. Apply-the-function questions: write =FUNCTION(arguments) with the function name in capitals, list every argument in order separated by commas, substitute the actual cell references, and close with the result in rupees with commas and two decimals where relevant. Never jump from the question straight to the final value — the formula is the answer’s core.
5. Questions that refer to the compound interest worksheet (Figure 2.6): structure the answer in the chapter’s own order — planning step → basic value cells → derived value cells → formula bar → what-if revision (p. 21-22). This one structure answers every question the layout can produce.

Two-Minute Revision Recap

The chapter’s ideas build as one chain: spreadsheet → workbook → worksheet → cell / cell address → basic versus derived values → labels → formulas (= sign, order of operations) → functions → named ranges → IF / nested IF → function library (date, mathematical, text, logical, lookup, financial) → data entry and import. If you can narrate that chain in your own words, you know the chapter’s skeleton.

Frequently Asked Questions

What is the difference between COUNT and COUNTA in Excel?

COUNT counts only cells that contain numbers — dates count as numbers, but text, blank cells, and error values are ignored. COUNTA counts every non-blank entry, including text, logical values (TRUE/FALSE) and errors. A column of employee names therefore returns 0 with COUNT but their full count with COUNTA (NCERT, p. 32-33).

Why does my VLOOKUP return #N/A or a wrong value?

With range_lookup set to FALSE, #N/A means no exact match exists, or the lookup value is smaller than the smallest value in the first column.

Wrong values usually come from omitting FALSE: with TRUE (or omitted), Excel performs an approximate match and returns the next largest value below the lookup value — which is correct only when the first column is sorted ascending. Also check col_index_num: less than 1 gives #VALUE!, and larger than the number of columns gives #REF! (NCERT, p. 38-39).

When should a cell reference be absolute instead of relative?

Use an absolute reference when the same fixed cell must be used after the formula is copied — typically a rate, tax percentage or other constant. Relative references like C4 shift with the new location (copying one cell down makes them C5); absolute references like $C$4 never change; mixed references fix only one part, $C4 or C$4 (NCERT, p. 19).

What are basic values and derived values in a spreadsheet?

A basic value is entered directly, like price P and quantity Q. A derived value is calculated from other values, like V in V = Q × P. When a basic value changes, every derived value that depends on it recalculates automatically — that mechanism is what makes what-if analysis possible (NCERT, p. 18, 22).

How do I keep the calculated value of a formula when the formula is removed?

Select the formula cells, then use Home tab → Copy → Paste Special, choose the Values radio button and click OK. This removes the formulas and keeps the current results — the standard way to freeze a snapshot that should not recalculate later (NCERT, p. 27).

Reference: NCERT Class 12 Accountancy textbook, chapter Spreadsheet.