Public Service Commission (PSC)2081 BSQuestion 2 of 9
What is an electronic spreadsheet? Differentiate between workbook and worksheet in MS Excel.
6 marks
Question source
- Exam year
- 2081 BS / 2024 AD
- Level
- Level 4
- Paper
- Paper II – Subjective
- Section
- Section A: Short Answer Questions (5 × 6 = 30 marks)
Model answer
An electronic spreadsheet is a computer application that allows users to organize, analyze, and store data in a tabular format of rows and columns. Each intersection of a row and column is called a cell.
Difference between Workbook and Worksheet:
| Basis | Workbook | Worksheet |
|---|---|---|
| Definition | A complete Excel file (.xlsx) | A single sheet/tab within a workbook |
| Contains | One or more worksheets | Cells organized in rows and columns |
| File extension | .xlsx, .xls | N/A (part of workbook) |
| Default count | One workbook per file | 1 sheet by default (can add more) |
| Navigation | Open/close via File menu | Switch using sheet tabs at bottom |
| Example | "SalesReport.xlsx" | "January", "February" tabs within it |