Solved 2025: FYUG Even Semester Exam, 2025 COMMERCE (2nd Semester) Computer Application in Business (COMSEC-151)

Subject: Commerce

Paper Code: COMSEC-151

Full Marks: 50 | Pass Marks: 20

(a) Define IP address.

An Internet Protocol (IP) address is a unique numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication.

(b) Write the difference between data and information.

Data: Raw, unorganized facts and figures that lack context.

Information: Data that has been processed, organized, and structured to be meaningful.

(c) Define modem.

A modem (Modulator-Demodulator) is a hardware device that converts digital data from a computer into an analog signal for transmission over telephone lines and vice versa.

(d) What is internet service provider?

An Internet Service Provider (ISP) is an organization that provides services for accessing, using, or participating in the Internet.

Question 2 (Answer any one) 2

(a) Differentiate between Intranet and Extranet.

Feature Intranet Extranet Access Private; only for internal employees. Private; for internal employees and authorized external partners. Purpose Internal communication and resource sharing. Collaboration with suppliers, vendors, or customers.

(OR) (b) Explain the terms 'Webpage' and 'Website' in internet.

Webpage: A single document on the internet identified by a unique URL.

Website: A collection of related webpages grouped together under a single domain name.

Question 3 (Answer any one) 5

(a) What is computer network? Explain types of network.

A computer network is a group of interconnected computers and devices that facilitate communication and resource sharing.

LAN (Local Area Network): Covers a small geographic area like a home or office.

MAN (Metropolitan Area Network): Connects users across a city.

WAN (Wide Area Network): Covers large distances, such as countries or continents (e.g., the Internet).

PAN (Personal Area Network): Used for personal devices within a very short range (e.g., Bluetooth).

(OR) (b) Discuss the major components of a computer system.

A computer system consists of several essential components:

Input Devices: Keyboard, mouse, etc.

Output Devices: Monitor, printer, etc.

CPU (Central Processing Unit): The brain of the computer that processes instructions.

Memory (RAM/ROM): For temporary and permanent data storage.

Storage Devices: HDD, SSD for long-term data retention.

UNIT-II

Question 4 (Answer any three) 1 x 3 = 3

Question 6 (Answer any one) 5

(a) What is mail merge? What are the different types of mail merge?

Mail Merge: A feature in MS-Word that allows users to create personalized letters, labels, or emails for a large number of recipients simultaneously by merging a main document with a data source.

Types of Mail Merge documents:

• Form Letters
• Envelopes
• Mailing Labels
• Directories/Catalogs
• Email Messages

(OR) (b) Write the steps to create a table in MS-Word.

Open MS-Word and go to the Insert tab.

Click on the Table button.

Drag the mouse over the grid to select the desired number of rows and columns.

Alternatively, click Insert Table and manually enter the number of columns and rows.

The table will appear on the document for data entry.

UNIT-IV

Question 11 (Answer any one) 2

Question 12 (Answer any one) 5

(a) What are the different categories of charts? Write the steps to create a chart in MS-Excel.

Categories of Charts:

• Column Chart
• Bar Chart
• Pie Chart
• Line Chart
• Area Chart
• Scatter (XY) Chart

Steps to Create a Chart:

Select the range of data cells (including headers) to be charted.

Click on the Insert tab.

In the Charts group, click on the desired chart type (e.g., Column or Pie).

Click on the specific subtype to insert the chart into the worksheet.

Use Chart Tools to customize labels, colors, and styles.

UNIT-V

Question 13 (Answer any three) 1 x 3 = 3

(a) Statistical function example: AVERAGE.

(b) Function for total: SUM.

(c) AVG is not a function in MS-Excel. True (The correct function name is AVERAGE).

(d) NPER: An Excel financial function that returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.