BCom TY BCom Sem 6 2022 2023 Apr 2023 COMPUTER SYSTEMS AND APPLICATIONS PAPER II Question Paper - Mumbai University | munotes

Loading PDF...

Older exam Apr 2023 - COST ACCOUNTING IV Semester-end · 2022 2023 → Newer exam Apr 2023 - COMMERCE VI Semester-end · 2022 2023 →

Questions asked in this paper

Q1 Attempt any Two sub questions from a),b) & c) in MS-Excel (True or False ) a The default cell reference is absolute reference b LEN function does not include spaces while calculating the length of a string c WEEKDAY () returns the day of the week such as “Mon”, Etc B Attempt any Two sub questions from d),e) and f) in Visual Basic 2 e The prefix for naming a menu item in VB is f are the basic building block of Visual Basic Application C Attempt any Six sub questions from and 0) in E-Commerce 6 ( True or False ) E-commerce means buying and selling of products or services by business or consumer 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 The cost of the products sold through E-Commerce is very high In the subscription model a fee is charged to the user for having access to material on n Decryption means converting readable text into cipher text o for electronic data interchange D Attempt any Five sub questions from and w) in E-Commerce 5 p Acomputer-to-computer exchanges of business transaction is called The model in E-Commerce where companies earn revenue by referring users to other websites providing products/services is called model r Conversion of coded data into readable data is called s most commonly used form of payment in E-Commerce is t The full form of HTTP in E-Commerce is Hyper Text protocol The full form of SET is v Commercial transaction done with the help of cell phone is called w Yahoo.com is a 2 marks
Q2 A Attempt any one sub questions from a) & b) in E-Commerce 8 marks
- a. Explain any four Revenue Model in E- Commerce b Explain various payment system in E- Commerce B Attempt any one sub questions from c) & d) in E-Commerce 7
- c. Explain B2B and C2C models in E-Commerce
- d. Explain Encryption and Decryption in Commerce
Q3 A Answer any one sub question from a) and b) in MS-Excel 8 marks
- a. The following data has been entered in a worksheet Write the steps to obtain
Q1 Total Marks
Q2 Average marks
Q3 Grade which is decided as per the following criteria
- b. Answer the following using give spreadsheet Write the steps to compute
Q1 Commission in Column C as 5% of the sales amt li. Bonus in Column D as follows: Total in column E Answer any one sub question from c) and d) in MS- EXCEL 7
- c. Answer the following using the given spreadsheet Write the steps to compute the following
Q1 HRA in column C as 30% of Basic salary whenever the basic salary is 30000 or less otherwise as 40% of the basic salary
Q2 DA in column D as 50% of basic salary
Q3 Tax in column E as 10% of Basic
Q4 Net Salary in column F as Basic + HRA+ DA — Tax
- d.Answer the following using spreadsheet Write the steps to obtain the
Q1 income tax in columns C
Q2 Surcharge in columns D and
Q3 Total tax in column E. where income tax is calculated as follows Surcharge is calculated @1% of the income tax and is applicable only to those whose incomes exceed 1000000 otherwise it is zero
Q4 A Answer any one sub question from a) and b) in MS- EXCEL 8 marks
- a. The following data is entered in a worksheet regarding rainfall in three months (in Write the steps find the total rainfall in each city in the cells E2 to
- ii)To create 2-D Column chart for Oct , Nov and Dec 111)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 Write steps to find the Total Profit in B7 B Answer any one sub question from c) and d) in MS- EXCEL 7
- c.The following data has been entered in a worksheet Emp_No Name Salary Write steps to do the following:
Q1 Display only those rows where the Salary is more than 50,000
- ii) Display only those rows where the Salary is more than 25,000 but
- iii) Display only those rows where the Department is “HR”
- d. Explain the following functions in MS-EXCEL
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 length of a rectangle and breadth of the rectangle and then calculates and displays the area of the
- 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 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 larger 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.

Report or request

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Related Resources

BCom Notes BCom Syllabus

Something wrong with this paper? Report it.

Connected Papers

BCom / Ty Bcom · 237 papers

Browse all →

Questions? Email contact@munotes.in

Done!