MS Excel
About 6 min · Computer Knowledge · English
Time worked out from the lesson's 348 words at 150 words a minute, plus a minute for each question.
Microsoft Excel is a spreadsheet application used for data organization, calculation, analysis, and visualization. For HSSC CET, Excel questions typically test your knowledge of basic operations, commonly used formulas and functions, cell referencing, and chart creation. Memorize key functions and their syntax.
Key ideas
- Workbook vs Worksheet: A workbook is the entire Excel file (.xlsx), while a worksheet is a single sheet (tab) within that workbook. One workbook can contain multiple worksheets.
- Cell Address: Each cell is identified by its column letter and row number (e.g., A1, B5, C10). This address is used in formulas to reference data.
- Active Cell: The currently selected cell where data entry occurs, shown with a dark border.
- Cell Range: A group of cells referenced together (e.g., A1:A10 means cells A1 through A10; A1:C5 means a rectangular block).
- Relative vs Absolute Reference: Relative references (A1) change when copied to other cells. Absolute references ($A$1) remain fixed. Mixed references ($A1 or A$1) lock either column or row.
Watch out for
- Forgetting the equals sign: Writing SUM(A1:A10) instead of =SUM(A1:A10). Every formula must begin with = sign.
- Confusing COUNT and COUNTA: COUNT counts only numeric cells; COUNTA counts all non-empty cells including text. If a range has names (text), COUNT returns 0.
- Using wrong reference type when copying: Using A1 instead of $A$1 when you want a cell to remain fixed while copying formulas. Press F4 while typing to toggle reference types.
Quick reference
- Every Excel formula starts with = (equals sign)
- Default file extension: .xlsx (macro-enabled: .xlsm)
- Maximum columns: 16,384 (XFD); Maximum rows: 1,048,576
- SUM adds, COUNT counts numbers, COUNTA counts non-empty cells
- $ symbol locks reference — $A$1 is absolute, A1 is relative
Check yourself: 3 questions
1. In MS Excel, what is the correct formula to find the sum of values in cells A1, A2, A3, A4 and A5?
2. In MS Excel, if cell A1 contains the value 15 and cell B1 contains the value 3, what will be the result of the formula =A1*B1+10?
3. In MS Excel, which function is used to find the largest value in a range of cells?
This lesson is cut from the topic's note, not rewritten. Fact-checked on 18 Oct 2026: an AI-assisted check of this note against cited sources; the errors it found were corrected that day. Some errors may remain. The questions are from Shishya's validated question bank.
Read the full noteFlashcards for this topic
Saves this lesson and its 3 questions in this browser on this phone. No sign-in; nothing about you is saved or sent. A saved copy is not updated until you save it again. Parts that load from the server when you use them (the AI tutor, adaptive practice, sign-in) still need a connection.