I85PREP
⌘ K
Assam ASSEB HSLC NSQF IT/ITeS (Level 2) study materials
Assam ASSEB HSLC NSQF IT/ITeS (Level 2) study resources

Assam ASSEB HSLC NSQF IT/ITeS (Level 2): Spreadsheet Applications and Data Handling

Assam ASSEB HSLC NSQF IT/ITeS (Level 2) · Work through your exam, one topic at a time.

All guide sections

Spreadsheet Applications and Data Handling

This section covers Spreadsheet Applications and Data Handling. The exam tests cells, rows, columns, formulas, functions, references, charts, sorting, filtering, and basic data validation.

Core rules and concepts

  • A cell is the intersection of a row and column, such as B4. A range such as B2:B5 includes B2, B3, B4, and B5.
  • Every formula starts with =. Functions include SUM, AVERAGE, COUNT, MAX, MIN, and IF.
  • Relative references change when copied; absolute references use $, such as $B$2, and stay fixed.
  • Sorting reorders data; filtering hides rows that do not match a condition. Charts should match the data type: column/bar for comparison, line for trend, pie for parts of a whole.
  • Numbers align right by default; text aligns left. Text that looks numeric can break calculations.

Worked example

Cells B2 to B5 contain 10, 20, 30, and 40. Find the total and average.

Reasoning: =SUM(B2:B5) returns 100. =AVERAGE(B2:B5) returns 25 because 100 ÷ 4 = 25. If the formula is copied down and B2 must stay fixed, write $B$2. A circular reference occurs if a formula refers to its own cell.

Traps that cost marks

Do not type SUM(B2:B5) without =. Do not confuse COUNT with SUM. Do not use a pie chart for time trends. Do not ignore hidden rows after filtering. Do not assume a number stored as text will calculate.