**SPREADSHEET BASICS**
**Workbook & Worksheet:**
• Workbook = Excel file containing multiple worksheets
• Worksheet = grid of rows and columns; 3 default sheets (Sheet1, Sheet2, Sheet3)
• Active Worksheet = currently selected sheet (name in bold)
• Add/rename sheets via Insert → Worksheet or right-click → Rename
**Cell Structure:**
• Rows: numbered 1–65,536 (vertical position)
• Columns: lettered A–IV (horizontal position)
• Cell Address = Column letter + Row number (e.g., C5, G8)
• Cell = intersection of one row and one column
• Total cells ≈ 16.7 million per sheet
**Data Types:**
• Numeric: numbers (values, prices, quantities)
• Alphanumeric: text and numbers mixed
• Date: dates in various formats
• Excel auto-detects type based on entry
**Values in Cells:**
• Basic Value = independent entry (e.g., Price = 100, Quantity = 5)
• Derived Value = calculated from basic values using formula (e.g., Total = Quantity × Price = 500)
• Arithmetic Expression = formula combining values (e.g., Q×P, A+B-C)
**Cell References:**
• Relative Reference (e.g., C4): changes when formula copied (C4 → D5 when moved right-down)
• Absolute Reference (e.g., $C$4): stays fixed; column ($) and row ($) locked
• Mixed Reference (e.g., $C4 or C$4): either column or row stays constant
• Range (e.g., A1:E2): all cells from top-left to bottom-right; uses colon (:)
**Navigation Shortcuts:**
• Ctrl+Home = jump to A1
• Ctrl+End = jump to last cell with data
• Arrow keys = move one cell (up/down/left/right)
• Tab key = move one cell right; Enter key = move one cell down
**Accounting Use:**
Spreadsheets organise financial data in tabular format; formulas calculate totals, ratios, and derived figures automatically; cell references allow consistent formula reuse across statements.
Q1. Which of the following correctly identifies a cell in Excel 2007?
Answer: B — Cell address format is always Column letter + Row number (e.g., C5), where C is the column and 5 is the row.
Q2. How many rows and columns does Excel 2007 contain in a single worksheet?
Answer: C — Excel 2007 has exactly 65,536 rows (numbered 1–65,536) and 256 columns (lettered A–IV), providing approximately 16.7 million cells per sheet.
Q3. In a spreadsheet, what is the difference between a basic value and a derived value?
Answer: B — Basic values (e.g., Price, Quantity) are independent entries; derived values (e.g., Total = Price × Quantity) are calculated using formulas and functions.
Q4. A Workbook in Excel contains:
Answer: B — An Excel Workbook is a file containing multiple Worksheets (sheets); the default is three sheets (Sheet1, Sheet2, Sheet3), and additional sheets can be added.
Q5. Which cell reference will remain fixed when a formula is copied to other cells?
Answer: B — Absolute reference ($C$4) locks both column and row with dollar signs, so when the formula is copied, this reference does not change; relative references (C4) do change.
Q6. What does the cell range A1:E2 include?
Answer: C — A range with colon notation (A1:E2) includes all cells within the rectangle defined by the top-left corner (A1) and bottom-right corner (E2).
Q7. Which keyboard shortcut moves the cursor directly to cell A1 (top of the worksheet)?
Answer: B — Ctrl+Home (holding Ctrl and pressing Home) jumps directly to cell A1, the starting cell of any worksheet.
Q8. In an accounting spreadsheet, if Quantity is in cell B2 and Price is in cell C2, which formula correctly calculates Total Value as a derived value?
Answer: B — Total Value is derived by multiplying Quantity × Price; therefore, the formula is =B2×C2, which is a multiplication (multiplication symbol is ×).
Q9. Which of the following statements is NOT correct about cell references in spreadsheets?
Answer: C — A mixed reference locks either the column ($C4) or the row (C$4) — not both; if both are locked, it is an absolute reference ($C$4).
Q10. A company accountant enters Purchase Price = 500 in cell A1 and Quantity = 10 in cell A2, then writes the formula =A1*A2 in cell A3. If the formula in A3 is copied to cell B3, what formula will appear in B3, and why?
Answer: B — The formula =A1*A2 uses relative references; when copied to B3 (one column right), both column letters shift right to B1*B2, reflecting the new location.
What is the intersection of a row and column called?
A cell, identified by a unique cell address such as C5 (column letter + row number).
Define a basic value and a derived value in a spreadsheet.
Basic value is an independent entry (e.g., Price, Quantity); derived value is calculated from basic values using a formula (e.g., Value = Quantity × Price).
How many rows and columns are in Excel 2007?
Excel 2007 has 65,536 rows (numbered 1–65,536) and 256 columns (lettered A–IV), totaling approximately 16.7 million cells.
What is a Workbook in Excel?
A Workbook is a file in Excel that contains multiple Worksheets (sheets), and by default it has Sheet 1, Sheet 2, and Sheet 3.
Define an Active Worksheet.
The Active Worksheet is the single worksheet currently available for operations; its name appears in bold in the Sheet Tab at the bottom.
What does a cell range A1:E2 represent?
A cell range A1:E2 includes all cells from the top-left corner (A1) to the bottom-right corner (E2) in a rectangular block.
Distinguish between relative reference and absolute reference.
Relative reference (e.g., C4) changes when copied to another cell; absolute reference (e.g., $C$4) stays fixed and does not change when copied.
What is a mixed cell reference?
A mixed reference holds either the row or column constant (e.g., $C4 or C$4) so that only the unfixed part changes when copied.
How do you move to cell A1 (top of worksheet) using keyboard?
Press Ctrl+Home keys together to jump directly to cell A1.
Why are formulas and functions important in accounting spreadsheets?
Formulas and functions automate calculations (e.g., totalling expenses) and ensure consistency and accuracy across financial statements.
What is a cell? How is it identified in a spreadsheet? Give one example. [2 marks]
Define cell as intersection of row and column; cell address format is column letter + row number (e.g., D7); mention that it is the unit where data or formulas are entered.
Explain the difference between basic values and derived values in a spreadsheet with a suitable example from an accounting context. Show why derived values are important in financial calculations. [5 marks]
Basic value = independent entry (e.g., Unit Price = Rs 100, Quantity = 5); Derived value = formula result (e.g., Total Cost = Quantity × Unit Price = 500). Show that derived values ensure consistency and automate calculations in financial statements like trial balance and profit & loss statements.
Define and distinguish between relative reference, absolute reference, and mixed reference with examples. Explain how each behaves when a formula containing it is copied from one cell to another. Why is understanding these references critical for building financial templates in Excel? [6 marks]
Relative (C5): shifts when copied (C5→D6 if moved right-down); Absolute ($C$5): locks both row and column, never shifts; Mixed ($C5 or C$5): locks only column or row. Show examples of copying formulas. Explain that templates for Balance Sheets, P&L, and Ratios rely on correct references to prevent formula errors and ensure reusability across multiple periods or companies.
You've seen the free preview. Open the full interactive study kit — mind map, instant-graded quiz, progress tracking — free, no sign-in required.
Open Full Study Kit — Free →