Question

Which of the following functions can be performed with the help of spreadsheets?
1. Maintaining records
2. Creating videos
3. Analysing data
4. Performing financial calculations
5. Writing letters

• A. 1, 2, 3, 4, 5
• B. 1, 3, 4
• C. 1, 3, 5
• D. 3, 4, 5

Hint:

Spreadsheets are fundamentally designed around quantitative numbers and logical tables. If a task requires video, audio, or extensive narrative prose, spreadsheets are not the primary tool.

Answer 1

The Correct Option is B

Step 1: Analyze Core Spreadsheet Capabilities:
A spreadsheet (such as Microsoft Excel or Google Sheets) is an interactive computer application designed for the organization, analysis, and storage of data in tabular form. It consists of cells arranged in rows and columns.

Step 2: Match Options against Spreadsheet Design:
1. Maintaining records is a native capability of spreadsheets using tables. 2. Creating videos is impossible since spreadsheets lack rendering engines. 3. Analysing data is a core strength using statistical tools. 4. Performing financial calculations is a fundamental feature using formula bars. 5. Writing letters is a task for word processors, not spreadsheets.

Step 3: Selecting the Correct Combination:
The functions that are native and optimal to spreadsheets are 1, 3, and 4. This directly corresponds to Option (B).