Question 1

GIGO means:

Accepted Answer

Wrong input/program gives wrong output.

Question 2

All Excel formulas start with:

Accepted Answer

Excel formulas start with =.

Question 3

Win+L shortcut is used to:

Accepted Answer

Win+L locks the screen.

Question 4

An advantage of computerisation in business is:

Accepted Answer

Computers speed up processing and reporting.

Question 5

Operating system is:

Accepted Answer

OS is system software managing resources and providing UI.

Question 6

COUNTIF function is used to:

Accepted Answer

COUNTIF counts matching entries.

Question 7

A database is:

Accepted Answer

Database stores related data in organized form.

Question 8

UPI stands for:

Accepted Answer

UPI is Unified Payment Interface, used for instant bank-to-bank transfers.

Question 9

Best practice before sending a business document is:

Accepted Answer

Proofreading reduces mistakes.

Question 10

A major benefit of e-commerce for customers is:

Accepted Answer

E-commerce provides convenience, round-the-clock shopping and easy comparison of products/prices.

Question 11

Two-factor authentication (2FA) helps mainly by:

Accepted Answer

2FA uses two verification factors (e.g., password + OTP), improving account/payment security.

Question 12

Header and footer are used to:

Accepted Answer

Headers/footers repeat page info like title/page number.

Question 13

Which chart best shows trends over time?

Accepted Answer

Line chart shows trends over time.

Question 14

SEO in online marketing refers to:

Accepted Answer

SEO (Search Engine Optimization) improves organic search ranking through content and technical improvements.

Question 15

Ctrl+S is used for:

Accepted Answer

Ctrl+S saves document.

Question 16

SaaS refers to:

Accepted Answer

SaaS provides ready-to-use software over the internet.

Question 17

AI in business is commonly used for:

Accepted Answer

AI is used for chatbots, recommendations, fraud detection and forecasting.

Question 18

F5 key in PowerPoint is used to:

Accepted Answer

F5 starts slideshow.

Question 19

WWW stands for:

Accepted Answer

WWW means World Wide Web, a service on the internet that provides web pages.

Question 20

Alignment options include:

Accepted Answer

These are paragraph alignments.

Question 21

State any one type of e-commerce.

Accepted Answer

B2C (Business to Consumer) (any one: B2B, B2C, C2C, C2B, B2G).

Question 22

What is a formula in Excel?

Accepted Answer

A formula is an expression starting with = used to calculate results in Excel.

Question 23

Name any one voucher used in Tally.

Accepted Answer

Sales voucher (any one: Sales, Purchase, Receipt, Payment, Contra, Journal).

Question 24

Write the full form of GSTIN.

Accepted Answer

GSTIN stands for Goods and Services Tax Identification Number.

Question 25

Define presentation.

Accepted Answer

A presentation is a structured communication of ideas using slides and visuals to an audience.

Question 26

Write the full form of SaaS.

Accepted Answer

SaaS stands for Software as a Service.

Question 27

Write the full form of ERP.

Accepted Answer

ERP stands for Enterprise Resource Planning.

Question 28

What is conditional formatting?

Accepted Answer

Conditional formatting highlights cells automatically based on rules/conditions.

Question 29

Define operating system.

Accepted Answer

Operating system is system software that manages computer hardware and provides an interface for users and applications.

Question 30

Write the meaning of normalization.

Accepted Answer

Normalization is organizing tables to reduce redundancy and improve data consistency.

Question 31

Differentiate between marketplace model and inventory model (any three points).

Accepted Answer

In marketplace model, the platform connects buyers and multiple third‑party sellers and earns commission/fees, whereas in inventory model the company owns stock and sells directly to customers.
Marketplace model has wider seller variety and the platform mainly manages the technology and delivery support, whereas inventory model controls pricing, inventory and warehousing fully.
In marketplace, responsibility of product listing and stock is mainly with sellers, whereas in inventory model it is with the company itself.
(Any three differences can be written.)

Question 32

Write any three slide design principles.

Accepted Answer

Use one idea per slide, readable fonts, consistent theme, high contrast, and bullets instead of paragraphs (any three).

Question 33

Explain any three types of MIS reports with examples.

Accepted Answer

1) Periodic reports: prepared at regular intervals such as daily or monthly sales report.
2) Exception reports: highlight unusual conditions such as stock below reorder level or high return rate.
3) Summary reports: provide totals/KPIs such as monthly sales summary by region and top-selling products.
(Any three types with examples can be written.)

Question 34

Write any three functions of an operating system.

Accepted Answer

Process management, memory management, file management, device management, security and user interface are OS functions (any three).

Question 35

Differentiate between relative and absolute cell reference.

Accepted Answer

Relative reference changes when copied (A1). Absolute reference remains fixed using $ signs ($A$1). Absolute references are used when a fixed rate/value is required for many calculations.

Question 36

Explain mail merge: meaning, steps and business uses.

Accepted Answer

Mail merge is a feature of MS Word used to create many personalised documents from one main document.

Business use:
- sending offer letters to multiple candidates
- sending invoices/letters to many customers
- printing address labels and envelopes

Steps:
1) Create the main document (letter).
2) Select recipients (Excel sheet/contacts list).
3) Insert merge fields like Name, Address.
4) Preview results to check correctness.
5) Finish and merge to print or send emails.

Mail merge saves time, reduces typing work and ensures accuracy in bulk communication.

Question 37

Explain MIS and its importance in business.

Accepted Answer

MIS (Management Information System) is a system that collects data from different business activities, processes it and provides useful information to managers for planning, controlling and decision making. MIS includes people, procedures, software, hardware and databases working together to generate reports.

MIS is important in business for several reasons. Firstly, it provides accurate and timely information such as sales performance, inventory levels, expenses and outstanding payments. This reduces guesswork and helps managers take better decisions.

Secondly, MIS supports planning and control. Managers can compare actual performance with targets, identify deviations and take corrective action. For example, if sales are falling in a region, the manager can plan promotional activities or improve distribution.

Thirdly, MIS improves coordination among departments because everyone uses the same data and reports. For example, sales, stores and accounts can coordinate using updated stock and customer outstanding reports.

Fourthly, MIS provides exception reports and early warnings, such as low stock, high returns, rising costs or overdue receivables. This helps the business take timely action.

Finally, MIS helps in strategic and long-term decisions by providing trend analysis and KPIs. Therefore, MIS improves efficiency, reduces uncertainty and supports growth and competitiveness of the business.

Question 38

Explain important Excel functions used for business analysis.

Accepted Answer

Excel functions are built-in formulas used for common calculations.

Important business functions:
- SUM(range): total sales/expenses.
- AVERAGE(range): average performance.
- IF(condition, value1, value2): decision-based results (e.g., pass/fail, bonus eligibility).
- COUNTIF(range, criteria): count matching records (e.g., count orders for a region).
- SUMIF(range, criteria, sum_range): sum only matching items (e.g., sales of one product).
- VLOOKUP(value, table, col, FALSE): fetch data from a table (e.g., price of item from price list).

These functions help prepare accurate and quick business reports and summaries.

Question 39

Explain the need/advantages of DBMS in business.

Accepted Answer

A DBMS is needed in business because business data is large and frequently updated.

Points (write in exam):
- Reduces data redundancy: avoids storing same data repeatedly.
- Improves data consistency: same value is maintained across tables.
- Better security: user permissions and controlled access.
- Fast retrieval and reporting: queries and reports for decisions.
- Backup and recovery: protects data from loss.
- Multi-user access: many departments can work on the same database.

Therefore, DBMS helps business operations, reporting and decision making.

Question 40

Explain phishing and the precautions to prevent phishing.

Accepted Answer

Phishing is a type of cyber fraud in which attackers send fake emails, SMS or create fake websites that look genuine (like a bank, courier, or company) to trick users into sharing confidential information such as password, OTP, PIN or card details. The main aim is to steal money or access accounts.

Phishing generally uses urgent messages like “Your account will be blocked” or “Verify immediately” and provides a link that takes the user to a fake login page. If the user enters details, the attacker gets the credentials.

Precautions to prevent phishing are as follows:
1) Do not click suspicious links or open unknown attachments. Always check the link carefully.
2) Verify the sender’s email address and domain. Look‑alike domains are common.
3) Never share OTP, PIN or password on email or links. Banks and genuine companies do not ask for such details.
4) Type the official website address manually in the browser instead of using the email link.
5) Enable multi‑factor authentication (MFA) for important accounts so that even if password leaks, login is blocked.
6) Keep system and browser updated and use security/antivirus tools.

Thus, awareness and careful checking of emails and links are the best ways to prevent phishing attacks.

Computer Applications in Business — Question Paper

20 more questions to unlock