Civil Aviation Authority of Nepal2077 BSQuestion 8 of 18
Briefly describe Worksheet, Rows, Columns and Cell in the Electronic Spreadsheet.
5 marks
Question source
- Exam year
- 2077 BS / 2021 AD
- Level
- Level 5 (Prabidhik, IT, Barishtha Sahayak)
- Paper
- Paper II – Sewa Sambandhi
- Section
- Section A
Model answer
Excel organizes data as grid in a workbook (.xlsx) containing sheets.
- Worksheet — One grid page (Sheet1, Sheet2). Holds one table, e.g. salary sheet 2080.
- Rows — Horizontal lines numbered 1, 2, 3... (over 1 million). One row = one record (one employee).
- Columns — Vertical lines lettered A, B, C... (16k+). One column = one field (Name, Salary).
- Cell — Intersection with address like
B5(column B, row 5). Holds one value/formula. Active cell gets input; rangeA1:D10selects blocks for SUM or charts.
Example: C3 holds Ram's salary; =SUM(C2:C20) totals the Salary column.