TYBCOM Sem 6 Computer Question Paper April 2023 – Download Free Pdf

TYBCOM Sem 6 Computer Question Paper April 2023

Duration: 2 Hours 30 min Max Marks:75

Note : All questions are compulsory

Q1A) Attempt any Two sub questions from a),b) & c) in MS- Excel (True or False ) (02 Marks)

a)The default cell reference-is absolute reference.
b) The LEN () function doe’s not include spaces while calculating the length of a string
c) WEEKDAY () returns the day of the week such as “Sun”, “Mon”, Etc

Q1B) Attempt any Two sub questions from d),e) and f) in Visual Basic (Multiple Choice ).
(02 Marks)

d) VIP means ________
1)Visual Binary  Project
2) Very Basic Project 
3) Visual Basic Project
4) Visual Basic Project

e) The prefix for naming a menu item in VB is _________
1) m
2) Mnu
3) men
4) mne

f) ________ arc the basic building block of Visual Basic Application

1. Forms
2. Method
3. Events
4. Controls

Q1C) Attempt any six sub questions from g),h),i),j),k),l),m),n) and 0) in E-Commerce (Multiple Choice) (06 Marks)

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

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

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

j) In SET the customer’s credit^–Card number is never seen by the merchant

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

I) The cost of the products sold through E-Commerce is very high

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

n) Decryption means converting readable text into cypher text.

o) EDI stand for electronic data interchange

Q1D) Attempt any Five sub questions from p),q),r),$),t),u),v), and w) in E-Commerce (Multiple Choice) (05 Marks)

p) A computer-to-computer exchanges of business transaction is called
a) EDI                      b) E-Commerce
c) E-Business               d) E-Market

q) 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

r) Conversion of coded data into readable data is called
a) De-Conversion
b) Decryptions
c) Encryptions 
d) Password

s) The most commonly used form of payment in E-Commerce is
a) Credit Card             
b) Pay Pal                 
c) Petro Card           
d) Digital Cash

t) The full form of HTTP in E-Commerce is Hyper Text  _________ protocol
a) Travel
b) Topology
c) Transmit
d) Transfer

u) The full form of SET is _______
a) Secure Electronics Tax
b) Secure Electronics transaction
c) Secure Electronics Tunnel
d) Secure Electronics Territiory

v) Commercial transaction done with the help of cell phone is called ________
a) M-Commerce
b) m-Business
c) E-Commerce
d) E-Business

w) Yahoo.com is a ______
a) Portal
b) Protocol
c) Email
d) E-Trailor

Q.2 A) Attempt any one sub questions from ay& b) in &Commerce (08 Marks)

a) Explain any four Revenue Model in E- Commerce
b) Explain various payment system in E- Commerce

Q.2B) Attempt any One sub ,questions from c) & in E-Commerce (07 Marks)

c) Explain B2B and C2C models in E-Cormmerce
d) Explain Encryption and Decryption in Commerce

Q.3A) Answer any one sub question from a) and b) in MS-Excel (08 Marks)
a. The following data has been entered in a worksheet.

	A	B	D	E	F	G	H	I	J
1	Name	Eco	A/c	Comp	Export	Tax	Total Marks (500)	Average Marks	Grade
2	Sunny	76	98	54	15	65
3	Arham	45	54	45	12	84
4	Sarah	36	36	89	65	54
5	Alex	25	54	25	75	47
6	Kumar	45	12	14	45	54

Write the steps to obtain

1. Total Marks
2. Average Marks
3. Grade which is decided a per the following criteria.

Average	Grade
>=60	A
<60 but >=45	B
<45 but>=35	C
<35	Fail

b. Answer the following using give spreadsheet.

	A	B	C	D	E
1	Salesman Name	Sales Amt	Commission	Bonus	Total = Commission+ Bonus
2	Rachit	55000
3	Anish	45000
4	Sunil	64000
5	Rahul	35000

Write the steps to compute

1. Commission in Column C as 5% of the sales amt
2. Bonus in Column D as follows:

Sales Amt	Bonus
Up t0 50000	5%
>50000	8%

iii. Total in column E.

Q.2B) Answer any one sub question-from c) and d) in MS – EXCEL (07 Marks)

c. Answer the following using the given spreadsheet.

	A	B	C	D	E	F
1	Name	Basic	HRA	DA	Tax	Net Salary
2	Anil	50000
3.	Sachi	35000
4	Sushil	24000
5	Rasik	16000

Write the steps to compute the following

1. HRA in column C as 30% of Basic salary whenever the basic salary is 30000 or less otherwise as 40% of the basic salary.
2. DA in column D as 50% of basic salary.
3. Tax in column E as 10% of Basic
4. Net Salary in column F as Basic + HRA+ DA — Tax

d) Answer the following using spreadsheet.

	A	B	C	D	E
1	Name	Taxable Income	Income Tax	Surcharge	Total Tax
2	Rachit	555000
3	Anish	1200000
4	Sunil	640000
5	Rahul	1350000
6	Nishin	750000

Write the steps to obtain the

1. income tax in columns C
2. Surcharge in columns D and
3. Total tax in column E. where income tax is calculated as follows.
   Taxable Income                Income Tax
   First 250000                               Nil
   Next 250000.                             5%
   Next 500000                             10%
   Excess                                       20%

Surcharge is calculated @1% of the income tax and is applicable only to those whose incomes exceed 1000000 otherwise it is zero.

Q.4A) Answer any one sub question from a) and b) in MS – EXCEL (08 Marks)

a. The following data is entered in a worksheet regarding rainfall in three months (in mm)

	A	B	C	D	E
1	City	Oct	Nov	Dec
2	Pune	50	35	40
3	Thane	40	45	20
4	Nashik	30	50	30
5	Dhule	10	55	60

Write the steps

i) To find the total rainfall in each city in the cells E2 to.E5.
ii)To create 2-D Column chart for Oct , Nov and Dec.
iii)To create Pie chart for the rainfall in Pune in Oct:, Nov and Dec
iv)To create Line chart for the rainfall in Oct and Dec.

b. The following data has been entered in a worksheet.

	A	B	C	D	E	F
1	PRODUCT	COST PRICE	QIYSOLD	SELLING PRICE	PROFIT
2	TV	25000	60	32000
3	Washing Machine	15000	29	20000
4	Refrigerator	21000	35	2750
5	Microwave	9750	24	12500
6	Total profit

Write steps to find the Total Profit in B7.

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

c. The following data has been entered in a worksheet

A	B	C	D
Emp_No	Name	Dept	Salary
P21	Shruti	HR	55000
P32	Micas	Ada&	60000
511	Am Ka	Sales	40000
Al2	Shyam	HR	30000
513	Kashish	HR	35000
	S14 Radhe	Sales	25000

Write steps to do the following:-

1. Display only those rows where the Salary is more than 50,000.
2. Display only those rows where the Salary is more than 25,000 but less than 40,000.
3. Display only those rows where the Department is “FIR” .

d. Explain the following functions in MS-EXCEL.

1) SUMIFO                   
2) LEND                       
3) MONTH()
4) YEAR
(5) PROPER°               
6) UPPER°                  
7) TIMED

Q.5A) Answer any one sub question from a) and b) in Visual Basic (8 Marks)

a) Write a project in V13 to design a suitable form which allows the user to enter length of a rectangle and breadth of the rectangle and then calculates and displays the area of the rectangle (Area = Breadth X Length)

b) Write a project in VB to design a suitable form which allows the user to enter Name and Basic Salary and calculate DA as 35% of Basic Salary whenever basic salary is less than 35000 otherwise 40% of Basic Salary using a ‘Calculate’ button and display the result.

  Q.5B) Answer any one sub question from c) and d) in Visual Basic (7 Marks)

c) Write a project in VB to design a suitable form which allows the user to enter two numbers and displays the larger of these two numbers.

d) Write a project in VB to compute and display the sum of the series.
1+2+3-1-….+10

TYBCOM Sem 6 Computer Question Paper April 2023 pdf

TYBCOM Sem 6 Question Paper April 2023

Related Posts :
FYBCOM Subjects
SYBCOM Subjects
TYBCOM Subjects
FYBCOM Syllabus
SYBCOM Syllabus
TYBCOM Syllabus

Tips to score good marks in TYBCOM Exam

1. Don’t wait until the last minute to start studying: begin early. You’ll have more time to learn the topic and solve questions, the earlier you start.
2. Remain arranged: Plan a study schedule and stick to it. Take time to rest and refresh during breaks.
3. Regularly review your notes: Regularly reviewing back your notes will help you keep the content in your memory.
4. Practice, practice, practice: By working through sample problems and completing sample tests, you can identify your areas of weakness and become familiar with the exam’s format.
5. Ask for assistance if you need it: If you’re having trouble with the subject, don’t be shy to ask for assistance. You can seek advice from your teacher, a classmate, or a tutor.
6. Get a good night’s sleep: The night before the exam, be sure to get lots of rest. A mind that has got enough sleep is better prepared to memorize and recall information.
7. Arrive early on exam day: Arrive early on the day of the exam to give yourself time to settle your worries and mentally prepare.
8. Stay focused during the exam: Avoid being distracted during the exam by remaining focused. Take a deep breath and return your attention to the activity at hand if you realize that your mind is roaming.
9. Don’t waste too much time on any one question: keep an eye on the time. If you start to struggle, leave it and return to it later.
10. Review your exam after you’re done: After you’re finished, review your paper for a while. By doing this, you’ll be able to correct any mistakes you may have made and provide any answers you’re not sure about.