TYBCOM SEM 6 : Computer Systems & Applications Paper -II (November 2025 Question Paper with Solution)

Paper/Subject Code: 83020/ Computer systems & Applications Paper - II

 TYBCOM SEM 6 

Computer Systems & Applications Paper -II

(November 2025 Question Paper with Solution)

Course: TYBCom

Semester : VI

Subject : Computer Systems & Applications Paper-II

University : University of Mumbai

Exam : November 2025

Introduction

This article provides the TYBCom Semester 6 Computer System & Applications Paper -II question paper for the November 2025 examination along with detailed solutions. The solutions are explained step-by-step to help students understand the method used to solve each problem and prepare for their university examination.

Related Articles

Most Important Question with Solutions

Q.P. April 2019 with Solution

Q.P. November 2019 with Solution

Q.P. November 2022 with Solution

Q.P. April 2023 with Solution

Q.P. November 2023 with Solution

Q.P. April 2025 with Solution

Q.P. November 2025 with Solution

Note: 

1) All questions carry equal marks and are compulsory.

2) Figures to the right indicate maximum marks for a question

Q.1 A Attempt any two sub-questions from a), b) and c) in MS-EXCEL (True or False): 02

(a) A template has a file name extension.XLTX.

Ans: True

(b) The LEN () function does not include spaces while calculating the length of a string.

Ans: False

(c) WEEKDAY () returns the day of the week such as "Sun", "Mon", Etc.

Ans: False

B. Attempt any two sub-questions from d), e) and f) in VISUAL BASIC (Multiple Choice):            02

(d) What is the meaning of VBP?

A) Visual Binary Project

B) Very Basic Project

C) Visual Basic Project

D) Delete it

(e) The data type that holds the numeric variables with values ranging from 0 to 225 is _________.

A) Boolean

B) Byte

C) Single

D) Integer

(f) The data type of a variable decides:

A) The Range of values that can be stored

B) The operation that can be carried out on that variable.

C) The amount of memory that will be allocated to that variable.

D) All of the above.

C. Attempt any six sub-questions from g), h), i), j), k), l), m), n), o) in E-Commerce. (True Or False)

(g) E-commerce means buying and selling of products or services by business or consumer over the internet.

Ans: True

(h) In C2C E-Commerce consumer transact with other consumer through a physical market.

Ans: False

(i) The volume of B2B transaction being done is more than B2C transaction.

Ans: True

(j) In SET the customer's credit card number is never seen by the merchant. 

Ans: True

(k) Integrity refers to the ability to determine the origin of the message received over the Internet.

Ans: False

(l) The cost of the products sold through E-Commerce is very high.

Ans: False

(m) In the subscription model a fee is charged to the user for having access to material on the website.

Ans: True

(n) Decryption means converting readable text into cipher text.

Ans: False

(0) EDI stand for electronic data interchange.

Ans: True

D. Attempt any five sub-questions from p), q), r), s), t), u), v), w) in E-Commerce. (Multiple Choice):    05

(p) A computer-to-computer exchanges of business transaction is called. 

A) EDI 

B) E-Commerce 

C) E-Business 

D) E-Market

(q) The full form of P2P in E-Commerce is:

A) Person to person

B) Peer to Person

C) Peer to Peer

D) Person to Peer

(r) The model in E-Commerce where companies earn revenue by referring users to other websites providing products/services is called __________ model.

A) Advertising 

B) Affiliation

C) Sales

D) Transaction

(s) The full form of SET in E-Commerce is ___________.

A) Secure Electronic Tax

B) Secure Electronic Transaction

C) Secure Electronic Territory

D) Secure Electronic Tunnel

(t) Conversion of coded data into readable data is called _________.

A) De-conversion 

B) Decryption 

C) Encryption

D) Password

(u) The full form of SLL in E-Commerce is _________

A) Secure Socket Layer

B) Secure Socker Loop

C) Secure Electronic Territory

D) Secure Electronic tunnel

(v) SET is an open standard in E-commerce offered by ________.

A) Certification Authorities 

B) Microsoft

C) Master and Visa C

D) World bank

(w) The Emerging market economy where consumer, produce and merchants interact electronically is called ________.

A) E-Commerce

B) Super Market

C) EDI

D) E-Market

Q.2 A Answer any one sub-question from a) and b) in E-Commerce.

(a) Explain any four limitations of E-Commerce. 

E-commerce has revolutionized the way businesses operate and consumers shop, offering convenience and accessibility. However, it is not without its challenges.

1. Security Concerns

One of the most pressing limitations of e-commerce is the issue of security. Online transactions involve the exchange of sensitive personal and financial information, making them vulnerable to cyberattacks, data breaches, and identity theft. Consumers may hesitate to provide their credit card details or personal information due to fears of fraud. Businesses must invest heavily in security measures, such as encryption and secure payment gateways, to protect their customers and maintain trust. Despite these efforts, the ever-evolving nature of cyber threats means that security remains a significant concern.

2. Lack of Personal Interaction

E-commerce lacks the personal touch that traditional brick-and-mortar stores offer. In physical stores, customers can interact with sales staff, ask questions, and receive immediate assistance. This personal interaction can enhance the shopping experience and build customer loyalty. In contrast, online shopping often relies on automated systems and chatbots, which may not fully address customer concerns or provide the same level of service. The absence of face-to-face interaction can lead to misunderstandings, dissatisfaction, and ultimately, lost sales.

3. Dependence on Technology

E-commerce is heavily reliant on technology, which can be both a strength and a limitation. Technical issues such as website downtime, slow loading times, or payment processing failures can disrupt the shopping experience and lead to lost revenue. Additionally, not all consumers are tech-savvy, and some may struggle with navigating online platforms or using digital payment methods. This dependence on technology can create barriers for certain demographics, particularly older individuals or those in regions with limited internet access.

4. Shipping and Delivery Challenges

While e-commerce allows consumers to shop from the comfort of their homes, it also introduces challenges related to shipping and delivery. Delays in shipping, high delivery costs, and issues with product returns can frustrate customers. Unlike traditional shopping, where products can be taken home immediately, online shoppers must wait for their purchases to arrive, which can lead to impatience and dissatisfaction. Furthermore, logistical challenges, such as managing inventory and ensuring timely deliveries, can strain e-commerce businesses, particularly during peak shopping seasons.

(b) Explain any four Revenue Models in E-Commerce.

E-commerce has revolutionized the way businesses operate, providing various avenues for generating revenue. Understanding different revenue models is crucial for entrepreneurs and businesses looking to thrive in the digital marketplace.

1. Transaction Fee Model

The Transaction Fee Model is one of the most straightforward revenue models in e-commerce. In this model, businesses charge a fee for each transaction that occurs on their platform. This model is commonly used by online marketplaces and payment processors.

Features:

• Commission-Based: Businesses earn a percentage of each sale made through their platform.

• Scalability: As the number of transactions increases, so does revenue.

• Examples: Platforms like eBay and PayPal utilize this model, charging sellers a fee for each transaction completed.

Advantages:

• Low Initial Investment: Businesses can start with minimal upfront costs.

• Performance-Based: Revenue is directly tied to sales volume, incentivizing the platform to attract more users.

Disadvantages:

• Market Competition: High competition can drive down transaction fees.

• Dependency on Volume: Revenue can fluctuate based on market demand and user activity.

2. Subscription Model

The Subscription Model involves charging customers a recurring fee to access a product or service. This model is prevalent in industries such as software, media, and e-learning.

Features:

• Recurring Revenue: Businesses receive consistent income at regular intervals (monthly, quarterly, or annually).

• Customer Loyalty: Subscribers are more likely to remain loyal, leading to a stable customer base.

• Examples: Services like Netflix and Spotify operate on a subscription basis, providing users with unlimited access to content for a monthly fee.

Advantages:

• Predictable Revenue Stream: Businesses can forecast income more accurately.

• Customer Engagement: Regular interaction with subscribers can enhance customer relationships.

Disadvantages:

• Churn Rate: High cancellation rates can impact revenue.

• Content Maintenance: Continuous investment in new content or features is necessary to retain subscribers.

3. Advertising Model

The Advertising Model generates revenue by displaying ads on a website or platform. This model is particularly effective for businesses with high traffic, as they can monetize their audience.

Features:

• Ad Placement: Businesses earn revenue by allowing third-party advertisers to display ads on their site.

• Cost-Per-Click (CPC) or Cost-Per-Impression (CPM): Revenue can be generated based on user interactions with the ads.

• Examples: Google AdSense and Facebook Ads are prime examples of platforms that utilize the advertising model.

Advantages:

• Low Barrier to Entry: Businesses can start generating revenue without requiring a large customer base.

• Diverse Revenue Streams: Multiple advertisers can provide various income sources.

Disadvantages:

• User Experience: Excessive ads can detract from user experience and drive visitors away.

• Dependence on Traffic: Revenue is directly tied to the volume of visitors, making it vulnerable to fluctuations.

4. Affiliate Marketing Model

The Affiliate Marketing Model allows businesses to earn commissions by promoting other companies' products or services. Affiliates receive a percentage of the sale when a customer makes a purchase through their referral link.

Features:

• Performance-Based: Affiliates are only paid when a sale is made, aligning incentives.

• Diverse Product Range: Affiliates can promote a wide variety of products from different merchants.

• Examples: Amazon Associates and ShareASale are popular affiliate programs that allow individuals and businesses to earn commissions.

Advantages:

• Low Risk: Businesses do not need to invest in inventory or product development.

• Scalability: As more affiliates join, the potential for revenue increases.

Disadvantages:

• Commission Dependency: Revenue is contingent on the performance of affiliates.

• Quality Control: Businesses may struggle to maintain brand integrity if affiliates do not represent them well.

B.

(c) Explain how online credit card transactions work.

Online credit card transactions have become a cornerstone of e-commerce, enabling consumers to purchase goods and services from the comfort of their homes. 

The Transaction Process

1. Customer Initiates Purchase

The process begins when a customer selects items to purchase on an e-commerce website. Once they are ready to check out, they are prompted to enter their credit card information, which typically includes:

• Card number

• Expiration date

• Card verification value (CVV)

• Billing address

2. Data Encryption

To protect sensitive information, the website uses Secure Socket Layer (SSL) encryption. This technology encrypts the data transmitted between the customer’s browser and the merchant’s server, ensuring that personal and financial information remains confidential.

3. Payment Gateway

Once the customer submits their payment information, it is sent to a payment gateway. The payment gateway acts as a bridge between the merchant’s website and the financial institutions involved in the transaction. It securely transmits the credit card information to the appropriate payment processor.

4. Payment Processor

The payment processor receives the transaction details from the payment gateway and forwards them to the customer’s bank (the issuing bank). This bank is responsible for verifying whether the customer has sufficient funds or credit available to complete the transaction.

5. Authorization Request

The issuing bank checks the following:

• Validity of the credit card

• Availability of funds

• Any potential fraud alerts

If everything checks out, the bank sends an authorization code back to the payment processor, confirming that the transaction can proceed. If there are issues (e.g., insufficient funds, expired card), the transaction is declined.

6. Transaction Confirmation

Once the payment processor receives the authorization code, it forwards this information back to the payment gateway, which then communicates with the merchant’s website. The customer receives a confirmation of the transaction, and the merchant can proceed with fulfilling the order.

7. Settlement

After the transaction is authorized, the funds are not immediately transferred. Instead, the transaction goes through a settlement process, which typically occurs at the end of the business day. During this process, the payment processor collects all authorized transactions and submits them to the issuing banks for payment.

8. Funds Transfer

Once the issuing bank processes the settlement, it transfers the funds to the merchant’s bank (the acquiring bank). This process can take a few days, depending on the banks involved and the payment processor’s policies.

9. Transaction Completion

Finally, the merchant receives the funds, and the customer’s credit card is charged. The customer will see the transaction reflected on their credit card statement, usually within a few days.

(d) Explain the following in E-Commerce

E-commerce, or electronic commerce, refers to the buying and selling of goods and services over the internet. It encompasses a wide range of business models and activities, including online retail, electronic marketplaces, and mobile commerce.

Types of E-Commerce

E-commerce can be categorized into several types based on the nature of the transactions and the parties involved:

1. Business to Consumer (B2C)

Understanding E-Commerce: A Comprehensive Overview

E-commerce, or electronic commerce, refers to the buying and selling of goods and services over the internet. This document provides a detailed exploration of e-commerce, including its types, benefits, challenges, and future trends. As digital transactions become increasingly prevalent, understanding the nuances of e-commerce is essential for businesses and consumers alike.

Types of E-Commerce

E-commerce can be categorized into several types based on the nature of transactions:

1. Business to Consumer (B2C): This is the most common form of e-commerce, where businesses sell products or services directly to consumers. Examples include online retailers like Amazon and eBay.

2. Business to Business (B2B): In this model, transactions occur between businesses. Companies sell products or services to other companies, often in bulk. Examples include Alibaba and various wholesale suppliers.

3. Consumer to Consumer (C2C): This model allows consumers to sell directly to other consumers, often facilitated by a third-party platform. Examples include platforms like Etsy and Craigslist.

4. Consumer to Business (C2B): In this model, individuals sell products or services to businesses. Freelance platforms like Upwork and Fiverr exemplify this type of e-commerce.

5. Business to Government (B2G): This involves businesses providing goods or services to government entities. It often includes procurement processes and contracts.

6. Government to Business (G2B): In this model, government agencies provide services or information to businesses, such as licensing and permits.

Benefits of E-Commerce

E-commerce offers numerous advantages for both businesses and consumers:

1. Convenience: E-commerce allows consumers to shop anytime and anywhere, eliminating the need for physical stores.

2. Wider Reach: Businesses can reach a global audience, expanding their customer base beyond local markets.

3. Cost-Effectiveness: Operating online often reduces overhead costs associated with physical storefronts, allowing for competitive pricing.

4. Personalization: E-commerce platforms can use data analytics to provide personalized shopping experiences, enhancing customer satisfaction.

5. Variety: Consumers have access to a vast array of products and services, often with the ability to compare prices and features easily.

6. Scalability: Businesses can scale their operations more easily in an online environment, adapting to changing market demands.

Q.3 A Answer any one sub-question from a) and b) in MS-EXCEL

(a) The following data is entered in a worksheet.            08

	A	B	C	D
1	Emp_Code	Grade	Basic Salary	Bonus
2	102	I	25000
3	2015	II	30000
4	1725	III	15000
5	3121	I	20000
6	908	III	18000

Write the steps to compute the Bonus, which is calculated as 10% of the Basic Salary for Grade I, 12% for Grade II, and 8% for Grade III.

Ans:

Steps to compute the Bonus in the worksheet:

1. Click on cell D2.
2. Enter the following formula:

=IF(B2="I",C2*10%,IF(B2="II",C2*12%,C2*8%))

3. Press Enter. The bonus for the first employee will be calculated.
4. Select cell D2 again.
5. Drag the Fill Handle (small square at the bottom-right corner of the cell) down to D6 to copy the formula to the remaining rows.
6. The Bonus column will automatically display:
   • 10% of Basic Salary for Grade I
   • 12% of Basic Salary for Grade II
   • 8% of Basic Salary for Grade III

Computed Bonus Values:

	A	B	C	D
1	Emp_Code	Grade	Basic Salary	Bonus
2	102	I	25000	2500
3	2015	II	30000	3600
4	1725	III	15000	1200
5	3121	I	20000	2000
6	908	III	18000	1440

(b) The following data is entered in a worksheet.

	A	B	C	D	E
1	Name	Sales	Tax	Refund	Net Income
2	Priya	45000
3	Vikram	100000
4	Arun	30000
5	Neha	70000

Write the steps to compute the following:

1. Tax: 10% on sales above 30000, 15% on sales above 70000.

2. Refund: 5% of sales if the sales amount is less than 50000, otherwise refund is zero.

3. Net Income: The sum of sales minus Tax and Refund.

Ans:

Steps to Compute Tax, Refund, and Net Income

1. Compute Tax (Column C)

Rule:

• 15% of Sales if Sales > 70000
• 10% of Sales if Sales > 30000
• Otherwise 0

1. Click cell C2.
2. Enter the formula:

=IF(B2>70000,B2*15%,IF(B2>30000,B2*10%,0))

Press Enter.

Copy the formula down to cells C3:C5.

2. Compute Refund (Column D)

Rule:

• 5% of Sales if Sales < 50000
• Otherwise 0

1. Click cell D2.
2. Enter the formula:

=IF(B2<50000,B2*5%,0)

3. Press Enter.
4. Copy the formula down to cells D3:D5. 

3. Compute Net Income (Column E)

Formula:
Net Income = Sales − Tax − Refund

1. Click cell E2.
2. Enter the formula:

=B2-C2-D2

Press Enter.

Copy the formula down to cells E3:E5.

	A	B	C	D	E
1	Name	Sales	Tax	Refund	Net Income
2	Priya	45000	4500	2250	38250
3	Vikram	100000	15000	0	85000
4	Arun	30000	0	1500	28500
5	Neha	70000	7000	0	63000

Q.3 B (c) Answer any one sub-question from c) and d) in MS-EXCEL 

The following data is entered in a worksheet.

	A	B	C	D	E
1	Cust_ID	Purchases Date	Item	Purchases Amt	Discount Amt
2	C001	2025-03-01	Laptop	60000
3	C002	2025-03-02	Phone	25000
4	C001	2025-03-03	Headphone	5000
5	C004	2025-03-04	Tablet	20000
6	C001	2025-03-05	Laptop	60000
7	Total discount amount for Laptop purchases
8	Total amount spent by Customer C001

Write the steps for the following:

1. Discount amount in column E (10% discount for purchases above 50000).

2. Total discount amount for Laptop purchases in cell B7.

3. Total amount spent by Customer C001 in cell B8 (including discount).

Ans:

1. Calculate Discount Amount in Column E

Rule: 10% discount for purchases above ₹50,000; otherwise no discount.

1. Click on cell E2.
2. Enter the formula:

=IF(D2>50000,D2*10%,0)

Press Enter.

Copy the formula from E2 to E6 using the Fill Handle.

2. Calculate Total Discount Amount for Laptop Purchases in Cell B7

1. Click on cell B7.
2. Enter the formula:

=SUMIF(C2:C6,"Laptop",E2:E6)

3. Press Enter.

Result: ₹12,000
(Two Laptop purchases of ₹60,000 each receive a discount of ₹6,000 each.)

3. Calculate Total Amount Spent by Customer C001 in Cell B8 (Including Discount)

Since the amount spent including discount means Purchase Amount minus Discount Amount:

1. Click on cell B8.
2. Enter the formula:

=SUMPRODUCT((A2:A6="C001")*(D2:D6-E2:E6))

3. Press Enter.

Result: ₹1,13,000

Calculation for Customer C001:

• Laptop: ₹60,000 − ₹6,000 = ₹54,000
• Headphone: ₹5,000 − ₹0 = ₹5,000
• Laptop: ₹60,000 − ₹6,000 = ₹54,000

Total = ₹54,000 + ₹5,000 + ₹54,000 = ₹1,13,000

(d) The following data has been entered in a spreadsheet:

	A	B	C	D	E	F
1	R NO	Name	Practical (out of 25)	Theory (Out of 75)	Total Marks (Out of 100)	Remarks
2	31	Anita	15	25
3	43	Bina	21	30
4	25	Avinash	12	46
5	24	Agnela	8	38
6	35	Ashish	24	68

Write the steps to calculate:

1. Calculate Total Marks in column E

2. Calculate Remark in column F as follows

If the student scores more than or equal to 10 in Practical and more than or equal to 30 in Theory, the Remark is "PASS". Otherwise, it is "FAIL".

Ans:

1. Calculate Total Marks in Column E

Formula: Total Marks = Practical + Theory

Steps:

1. Click on cell E2.
2. Enter the formula: C2 + D2

Press Enter.

Copy the formula from E2 to E6 using the Fill Handle.

2. Calculate Remarks in Column F

Condition:

• If Practical Marks ≥ 10 and Theory Marks ≥ 30 → PASS
• Otherwise → FAIL

Steps:

1.  Click on cell F2.
2. Enter the formula: IF(AND(C2>=10,D2>=30),"PASS","FAIL")

Press Enter.

Copy the formula from F2 to F6 using the Fill Handle.

	A	B	C	D	E	F
1	R NO	Name	Practical (out of 25)	Theory (Out of 75)	Total Marks (Out of 100)	Remarks
2	31	Anita	15	25	40	FAIL
3	43	Bina	21	30	51	PASS
4	25	Avinash	12	46	58	PASS
5	24	Agnela	8	38	46	FAIL
6	35	Ashish	24	68	92	PASS

Q.4 A. Answer any one sub-question from a) and b) in MS-EXCEL

(a) The following data is entered in a worksheet regarding number of matches won

	A	B	C	D	E
1	Country	2013	2014	2015
2	India	20	19	18
3	Pakistan	15	16	20
4	Australia	19	20	19
5	Sri Lanka	16	15	18

Write the steps to

A) To find the total matches won by each country in cells E2 to E5.

B) Create Column chart for matches won.

C) To create Pie chart for matches won by India.

D) To create a line chart for matches won in 2013 and 2014

Ans:

A) Find the Total Matches Won by Each Country in Cells E2 to E5

1. Enter the heading Total in cell E1.
2. Click on cell E2.
3. Enter the formula: Sum(B2:D2)

Press Enter.

Copy the formula from E2 to E5 using the Fill Handle.

Country	Total Matches Won
India	57
Pakistan	51
Australia	58
Sri Lanka	49

B) Create a Column Chart for Matches Won

1. Select the data range A1:D5.
2. Click the Insert tab.
3. Choose Column Chart from the Charts group.
4. Select 2-D Clustered Column Chart.
5. The chart showing matches won by each country during 2013, 2014, and 2015 will be created.
6. Add a suitable chart title such as "Matches Won by Countries (2013-2015)". 

C) Create a Pie Chart for Matches Won by India

1. Select the headings and India's data:
   • B1:D1 (Years)
   • Hold Ctrl and select B2:D2 (India's values)
2. Click the Insert tab.
3. Select Pie Chart.
4. Choose 2-D Pie Chart.
5. Add the chart title "India's Matches Won (2013-2015)".

D) Create a Line Chart for Matches Won in 2013 and 2014

1. Select the range A1:C5 (Country, 2013, and 2014 data).
2. Click the Insert tab.
3. Choose Line Chart from the Charts group.
4. Select 2-D Line Chart.
5. The line chart comparing matches won in 2013 and 2014 will be displayed.
6. Add a suitable title such as "Matches Won in 2013 and 2014".

(b) A Company makes three products Bats, Racquets and Footballs whose sale price is 300, 200 and150 respectively. For the company to break even, it has to achieve a total sale of 500000 in a year. Write the steps to find Using Solver the number of units of each of these three products that should be sold in order to meet the desired target sale.

Ans:

Steps to Find the Number of Units Using Solver

1. Enter the Data in the Worksheet

A	B	C
Product	Sale Price	Unit Sold
Bats	300	0
Racquets	200	0
Football	150	0
Total  Sales		0

2. Calculate Total Sales

1.  In the cell for Total Sales (e.g., C6), enter the formula: = B2*C2+B3*C3+B4*C4
2. Press Enter. 

3. Enable Solver

1. Click Data tab.
2. Click Solver.
   • If Solver is not available:
     • Go to File → Options → Add-ins.
     • Select Excel Add-ins and click Go.
     • Check Solver Add-in and click OK.

4. Set Up Solver

1. Click Data → Solver.
2. In Set Objective, select the Total Sales cell (C6).
3. Select Value Of and enter: 50000
4. In By Changing Variable Cells, select the cells containing Units Sold (C2:C4).

5. Add Constraints

1. Click Add.
2. Add the constraint: C2:C4 >= 0
3. Check Make Unconstrained Variables Non-Negative.
4. Optionally add int (integer) constraint if whole units are required.

6. Solve

1. Click Solve.
2. Solver will calculate the number of Bats, Racquets, and Footballs required to achieve total sales of ₹5,00,000.
3. Click Keep Solver Solution and then OK.

Q.4 B Answer any one sub-question from c) and d) in MS-EXCEL

(c) The following data has been entered in a worksheet

	RNO	Name	AGE	Total
1	1	Abhay	15	450
2	5	Raksha	18	550
3	11	Varsha	19	260
4	23	Deelip	20	680
5	2	Meenakshi	24	150

Write steps to do the following:

A) Display the data for Age less than 20.

B) Display the data where name start with "A"

C) Display the data where RNO is "23"

D) Display the data where the total is between 300 and 500.

Ans:

Steps to Filter the Data in the Worksheet

First, Apply AutoFilter

1. Select the entire data table including headings.
2. Click Data → Filter (or Data → AutoFilter).
3. Drop-down arrows will appear on each column heading.

A) Display the Data for Age Less Than 20

1. Click the filter arrow in the AGE column.
2. Select Number Filters → Less Than.
3. Enter: 20
4. Click ok

	RNO	Name	AGE	Total
1	1	Abhay	15	450
2	5	Raksha	18	550
3	11	Varsha	19	260

B) Display the Data Where Name Starts with "A"

1. Click the filter arrow in the Name column.
2. Select Text Filters → Begins With.
3. Enter: A
4. Click OK

	RNO	Name	AGE	Total
1	1	Abhay	15	450

C) Display the Data Where RNO is "23"

1. Click the filter arrow in the RNO column.
2. Select Number Filters → Equals.
3. Enter: 23
4. Click OK

	RNO	Name	AGE	Total
4	23	Deepali	20	680

D) Display the Data Where Total is Between 300 and 500

1. Click the filter arrow in the Total column.
2. Select Number Filters → Between.
3. Enter:
   • Lower limit: 300
   • Upper limit: 500
4. Click OK.

Result:

	RNO	Name	AGE	Total
1	1	Abhay	15	450

(d) Explain the following built-in functions in MS-EXCEL

1.NOW() 2. DAY() 3. SMALL() 4. COUNTBLANK() 5. DAY() 6. MONTH() 7.WEEKDAY()

Ans:

Built-in Functions in MS-Excel

1. NOW()

• Returns the current date and time of the system.
• Syntax: = Now()
• Example: If the current date and time are 13-Jun-2026 10:30 AM, the function returns that value.

2. DAY()

• Returns the day of the month from a given date (1 to 31).
• Syntax: = Day (serial_number)
• Example : =DAY("13-Jun-2026")

3. SMALL()

• Returns the k-th smallest value in a range of data.
• Syntax: =SMALL(array,k)
• Example =SMALL(A1:A5,2)

If A1:A5 contains 10, 25, 15, 30, 20, the result is 15 (the 2nd smallest value).

4. COUNTBLANK()

• Counts the number of empty cells in a specified range.
• Syntax: = COUNTBLANK(range)
• Example = COUNTBLANK(A1:A10)
• Returns the number of blank cells in A1:A10.

5. DAY()

• Returns the day number from a date.
• Syntax: =DAY(date)
• Example =DAY("25-Dec-2025")

6. MONTH()

• Returns the month number from a date (1 to 12).
• Syntax: =MONTH(serial_number)
• Example =MONTH("13-Jun-2026")

7. WEEKDAY()

• Returns the day of the week as a number.
• Syntax: =WEEKDAY(serial_number)
• Example =WEEKDAY("13-Jun-2026")

Result: 7 (Saturday, in the default numbering system where Sunday = 1).

Q.5 A. Answer any one sub-question from a) and b) in VISUAL BASIC

(a) Write a project in VB to design a form that allows the user to enter Salary and calculate the following:

DA (70% of Salary)

HRA (30% of Salary)

Gross Salary (Salary + DA + HRA)

Ans:

Control	Name	Text
Label	Label1	Salary
TextBox	txtSalary
Label	Label2	DA
TextBox	txtDA
Label	Label3	HRA
TextBox	txtHRA
Label	Label4	Gross Salary
TextBox	txtGross
Button	btnCalculate	Calculate
Button	btnExit	Exit

Input Salary	DA (70%)	HRA (30%)	Gross Salary
10000	7000	3000	20000

(b) Write a project in VB to design a form where the user enters three numbers and displays the smallest number among them.

B. Answer any one sub-question from c) and d) in VISUAL BASIC

(c) Write a project in VB to design a form that allows the user to enter two numbers and display their product and difference along with the sum.

(d) Write a project in VB to design a form that allows the user to enter an integer n and calculate and display the factorial of n, where n is any number entered by the user.