BCom TY BCom Sem 6 BCom Sem 6 (2016 2017) April 2017 COMPUTER 13rd Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 (A) Attempt any fwo sub-questions from a), b) and c) in MS-EXCEL (True or False) 2 marks
   • a) is used to convert all the letters in a word to upper case
   • b) allows you to solve for more than one variable Attempt any two sub-questions from d), e) and f) in VISUAL BASIC (2)
   • d) Visual Basic code is written in
   • e) The standard prefix for a check box button is
   • f) is a valid object name for box
   • (C) Attempt any six sub-questions from i), j), k), n), 0) in E- Commerce (True Or False) 6
   • g) E-commerce provides the capability of buying and selling of products, services and information on the internet
   • h) Web sites that supply different types of online information are content is an online store
   • j) Authentication ensures that the message was not read by others
   • k) of credit card numbers and passwords is possible in E-commerce
   • 1) Transaction broker earns money in the form of commission each time a
   • m) There is no scope for negotiations in B2C E-Commerce
   • n) Digital Cash is the electronic parallel of notes and coins
   • 0) Payment is done only by Smart Card in E-Commerce
   • (D) Attempt any five sub-questions from p), s), t), V), W) in E-Commerce (Multiple Choice) 5
   • q) The full form of C2Cin
   • A)Consumer to Commerce B)Commerce to Consumer
   • C)Consumer to Consumer D)Commerce to Commerce
   • r) of coded data into readable data is
   • s) to authenticate the sender of the message we use
   • t) isa convention that all sites that use SSL connection while making a secure connection use instead of HTTP
   • u) commonly used form of payment in E-Commerce is
   • v) Inonline stored value systems, cards that have embedded chips that store personal information are called
   • w) is part of E-Commerce
   • A)B2B B)C2C C)B2C D)All of these Answer any one sub-question from a) and b) in E-Commerce. (8)
   • a) Explain any four features of E-Commerce
   • b) Explain B2B and C2C models in E-Commerce
   • (B) Answer any one sub-question from c) and d) in E-Commerce. 7
   • c) Discuss the various payment systems used in E-Commerce the following in E-Commerce
2. Q3 (A) Answer any one sub-question from a) and b) in MS-EXCEL 1 No. Dept Salary Bonus Write steps to perform the following: 8 marks
   • i) To compute Allowance @ 1% of the Salary for salary up to otherwise @2% of the salary in Column D if) To find the Bonus @20% of the Salary for Salary above otherwise @14% of the Salary in Column E
   • iii) To find the total bonus of all employees whose salary is below 25,000
   • b) Roll Number and marks are entered in columns A and B as shown in the following worksheet. Write steps to compute Grade and the Award amount in Column C and D respectively using HLOOKUP function. Policy table to be referred for finding Grade and Award amount is given in the range G1:J3 1 |Roll. Award Marks 50 70 90
   • 2) 87' Grade A
   • (B) Answer any one sub-question from c) and d) in MS-EXCEL 7
   • c) The following table shows Roll no., Name and marks scored in three subjects by students in an exam Write steps to
   • 1) Find the Average marks in Column F
   • 2) Assign the grade in column G using the following policy:
   • d) Consider the following worksheet Write the steps to compute the Wages in column D given that the rate per hour is £500 and for Grade I, II and III workers respectively
3. Q4 Answer any one sub-question from a) and b) in MS-EXCEL 8 marks
   • a) The following data is entered in a worksheet regarding sales (in crores of the years 2005, 2010 and 2015 Write the steps to
   • i) Find the total sales in each year in the cells B6, C6 and Dé if) Create a Column chart for the total Sales in 2005, 2010 and 2015
   • iii) Create a Pie chart for the sales in 2010
   • iv) Create a Line diagram for the sales in 2005 and 2015
   • b) The following Excel worksheet contains the sale price per unit, units and sales value of two products in a year For the company to break even, it has to achieve a total sale of 1,00,00,000 in a year. Using Solver write the steps to find out the number of units of each of these two products that should be sold in order to meet the desired target sale
   • (B) Answer any one sub-question from c) and d) in MS-EXCEL 7
   • c) The following data has been entered in a worksheet: No. ‘Salary Contribution Write steps to
   • i)To display only the rows where the salary is more than 30,000
   • ii)To display only the rows where the Contribution is up to 3,000 iif)To display only the rows where the name contains “i”
   • d) Explain the following functions in EXCEL
4. Q5 (A) Answer any one sub-question from a) and b) in VISUAL BASIC 8 marks
   • a) Write a project in VB to design a suitable form which allows the user to enter the Principal amount and then calculates and displays the Simple Interest using 8.5% rate of interest for 4 years. (SI = P*R*N/100)
   • b) Write a project in VB to design a suitable form which allows the user to enter Basic Salary and calculate and display the HRA as 13% of Basic Salary for Basic Salary up to and 20% of Basic Salary otherwise
   • (B) Answer any one sub-question from c) and d) in VISUAL BASIC 7
   • c) Write a project in VB to design a suitable form which allows the user to enter two numbers and displays the smaller of these two numbers
   • d) Write a project in VB to compute and display the sum of the series

Read from the scan above, so a character or two may differ. The scan is the original.