TYBCOM Sem 6 Computer Question Paper April 2023
TYBCOM Sem 6 Computer Question Paper April 2023

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 creditCard 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.

ABDEFGHIJ
1NameEcoA/cCompExportTaxTotal
Marks
(500)
Average
Marks
Grade
2Sunny7698541565
3Arham4554451284
4Sarah3636896554
5Alex2554257547
6Kumar4512144554

Write the steps to obtain

  1. Total Marks
  2. Average Marks
  3. Grade which is decided a per the following criteria.
AverageGrade
>=60A
<60 but >=45B
<45 but>=35C
<35Fail

b. Answer the following using give spreadsheet.

ABCDE
1Salesman
Name
Sales
Amt
CommissionBonusTotal =
Commission+ Bonus
2Rachit55000   
 3Anish45000   
4Sunil64000   
 5Rahul35000  

Write the steps to compute

  1. Commission in Column C as 5% of the sales amt
  2. Bonus in Column D as follows:
Sales AmtBonus
Up t0 500005%
>500008%

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 CD E F
1NameBasicHRADATaxNet Salary
2Anil50000   
3.Sachi35000   
4Sushil24000   
5Rasik16000    

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.

ABCDE
1NameTaxable
Income
Income
Tax
SurchargeTotal
Tax
2Rachit555000   
3Anish1200000   
4Sunil640000   
5Rahul1350000   
6Nishin750000   

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)

 ABC DE
1CityOctNovDec 
2Pune503540 
3Thane404520 
4Nashik305030 
5Dhule105560 

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.

ABCDEF
1PRODUCTCOST PRICEQIYSOLDSELLING PRICEPROFIT
 2TV250006032000 
 3Washing
Machine
150002920000 
4Refrigerator21000352750 
5Microwave97502412500 
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

ABCD
Emp_NoNameDeptSalary
P21ShrutiHR55000
P32MicasAda&60000
511Am KaSales40000
Al2ShyamHR30000
513KashishHR35000
 S14 RadheSales25000

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

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.