BCom TY BCom Sem 6 BCom Sem 6 (2018 2019) April 2019 COMPUTER SYSTEM AND APPLICATION PAPER II Question Paper - Mumbai University | munotes

Questions asked in this paper

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

1. Q1 (A) Attempt any two sub-questions from a), b) and c) in MS-EXCEL (True or False) 2 marks
   • a) Theresult of a logical formula is a numeric value
   • b) The function removes all blank spaces from the string argument
   • c) Solver problems are limited to a single changing cell
   • (B) Attempt any two sub-questions e) and f) in VISUAL BASIC 2
   • d) Double clicking on the command button icon in the tool box will
   • e) is the final keyword used to indicate the end of a sub procedure
   • f) The full form of VBP is
   • (C) Attempt any six sub-questions from g), h), k), 1), 0) in E-Commerce. (True Or False) 6
   • g) Transaction broker earns money in the form of commission each time a
   • h) Richness refers to the total amount of information that is available to all
   • i) Content provider is one of the major B2B model
   • 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
   • 1) The cost of the products sold through E-Commerce is very high In SSL, encryption is based on session key which is unique and is different for each session
   • n) means buying and selling of goods and services using a
   • 0) Digital signature is used to authenticate the identity of a person involved
   • (D) Attempt any five sub-questions from p), q), t), u), Vv), W) in E- 5
   • A)Portal B)E-Tailer C) Transaction Broker D) None of these
   • q) In E-Commerce one business makes deals with another
   • r) The model in E-Commerce where companies earn revenue by referring users to other websites providing products/services is called
   • s) The full form of SET in E-Commerce is
   • t) of coded data into readable data is called 4
   • u) and receiver will have the same key in Key
   • v) are sites that create a digital online environment where people with similar interest can do transaction
   • w) AComputer to Computer exchange of business transaction is called
2. Q2 (A) Answer any onesub-question b) in E-Commerce. 8 marks
   • a) Explain the features of E-Commerce
   • b) Explain the following B2C models in E-commerce
   • (B) Answer any from c) and d) in E-Commerce 7
   • c) What is M-commerce? What are its applications?
   • d) Explain SET protocol
3. Q3 (A) Answer any one sub-question from a) and b) in MS-EXCEL 8 marks
   • a) the following worksheet Write steps to
   • i) Calculate Commission in column C using the following Commission
   • ii) Calculate Bonus as 4% of the total sales whenever the sales is above Rs.2, 00, 000 otherwise no bonus is given
   • iii) Calculate Total Earning where Total Earning = Commission+ Bonus
   • b) Consider the following worksheet. Write steps to compute Grade and the Division for next year in Column C and D respectively using HLOOKUP function. Policy table to be referred for finding Grade and Division for next year is given in the range G1:J3 RNO | MARKS | GRADE
   • (B) Answer any one sub-question from c) and d) in MS-EXCEL 7
   • c) Consider the following worksheet Write steps to compute the following:
   • i) 125% of basic salary whenever the basic salary is 30,000 or less otherwise as 135% of the basic salary
   • ii) HRA is 25000 for “Mumbai” city and 18000 for other cities
   • d) the following worksheet showing the electricity consumption in Write steps to compute the following
   • i) Find Rate using VLOOKUP function. Policy table to be referred is in the
   • ii) Calculate Unit Consumption Charges in column D where Unit
4. Q4 (A) Answer any one sub-question from a) and b) in MS-EXCEL 8 marks
   • a) The following table shows the shipment forecast of tablets, laptops and Write the steps to
   • i) Find the total product shipped in the year 2015,2016,2017,2018 in the
   • ii) Create 3-D Bar chart for the above data
   • iii) Create a Line diagram for the year 2015 and 2018
   • iv) Create a Pie chart for the year 2017
   • b) The following worksheet contains the Price Per Unit and quantity sold of some products in a year. Write steps to calculate Total Sales in column D and Grand Total Sales in D5 For the company to break even, it has to achieve a Grand Total Sales of Rs 18, 00, 000 in a year. Using solver, find out the number of units of each of these three products that should be sold in order to meet the desired Where Total Sales=Price*Quantity and Grand Total Sales=Sum of D2 to
5. Q4 (B) Answer any one sub-question from c) and d) in MS-EXCEL 7 marks
   • c) The following data has been entered in a Excel worksheet Write steps to
   • (i) Display only those rows where the sales is less than 40000
   • (ii) Display only those rows where the gender is “M”
   • (iii) Display only those rows where the city name starts with “N”
   • d) Explain the following functions in MS-EXCEL
6. 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 Amount in Dollars and Rate of Conversion to Rupees and then calculate and display equivalent amount in Rupees
   • 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 95% of Basic Salary whenever basic salary is less than 45000 otherwise 110% of Basic Salary using a ‘Calculate’ button and display the result
7. Q5 (B) 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 Product Name, Quantity Sold and Price per Unit of a product and then calculates and displays the Total Cost (Total Cost = Quantity Sold
   • d) Write a project in VB to design a suitable form which allows the user to enter an integer and calculate and display the factorial of that integer when the “Calculate” button is clicked

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