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

UNIT-I

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

(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

(a) What is hyperlink?

A hyperlink is a digital reference (link) that connects one location in a document to another or to an entirely different document/webpage.

(b) Define indent.

Indent refers to the distance or blank space between the document margin and the start of a paragraph's text.

(c) What are header and footer?

Header: Content appearing at the top margin of every page.

Footer: Content appearing at the bottom margin of every page.

(d) What is Word Processing?

Word processing is the use of software to create, edit, format, and print text-based documents.

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.

  1. Open MS-Word and go to the Insert tab.
  2. Click on the Table button.
  3. Drag the mouse over the grid to select the desired number of rows and columns.
  4. Alternatively, click Insert Table and manually enter the number of columns and rows.
  5. The table will appear on the document for data entry.

UNIT-IV

Question 11 (Answer any one) 2

(b) Explain conditional formatting with example.

Definition: Conditional formatting is an Excel feature that allows users to apply specific formatting (like cell color or font style) to cells that meet certain criteria or rules.

Example: In a student mark sheet, setting a rule to highlight all cells with marks below 40 in Red to quickly identify students who failed.

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:

  1. Select the range of data cells (including headers) to be charted.
  2. Click on the Insert tab.
  3. In the Charts group, click on the desired chart type (e.g., Column or Pie).
  4. Click on the specific subtype to insert the chart into the worksheet.
  5. Use Chart Tools to customize labels, colors, and styles.

UNIT-V

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

Exam Focus Enhancements

Exam Tips

Common Mistakes

Important Formulas List

Would you like me to generate step-by-step screenshots descriptions for any of the MS-Excel functions mentioned?