Computer Application in Business (Program) Solved Paper 2023: NBU

-

 

UNIVERSITY OF NORTH BENGAL

B.Com. Programme 5th Semester Examination, 2023

 

SEC3-COMMERCE

 

COMPUTER APPLICATIONS IN BUSINESS

 

Time Allotted: 2 Hours                                                                  Full Marks: 60

 

 

The figures in the margin indicate full marks.

GROUP-A

Answer any two questions 12×2 =24

 

1. (a) Discuss the advantages of using Electronic Spreadsheet. 8+4

1. (b) Write the steps involved in printing a worksheet in MS Excel.

 

Answer: (a). Various important advantages of using electronic spreadsheets presented below:

 

1. Quick Calculations: Built-in formulas and functions enable fast and accurate calculations, reducing manual errors.

2. Easy Data Entry: Spreadsheets simplify data entry, sorting, filtering, and manipulation, enhancing efficiency.

3. Data Visualization: They support various charts and graphs, making data presentation clear and visually appealing.

4. Conditional Formatting: Automatically highlights key data points, helping identify trends or outliers quickly.

5. Flexibility: Capable of handling large volumes of data, suitable for tasks like financial modelling and inventory management.

6. Real-Time Collaboration: Multiple users can work on the same document simultaneously, improving productivity and teamwork.

7. Data Analysis: Advanced features allow for complex data analysis, making it easier to interpret and use information.

8. Customizability: Spreadsheets can be tailored to specific needs with macros, templates, and custom functions.

 

(b). The steps involved in printing a worksheet in MS Excel as follows:

 

Step-1: Open the Worksheet: Open the Excel workbook and select the worksheet you want to print.

Step-2: Go to the Print Menu: Click on the "File" tab and select "Print" from the drop-down menu, or press `Ctrl + P`.

Step-3: Set Print Options: In the Print menu, choose the printer, select the number of copies, and adjust settings like orientation, margins, and scaling.

Step-4: Preview the Print: Review the print preview to ensure the worksheet looks as desired.

Step-5: Print the Worksheet: Click the "Print" button to send the worksheet to the printer.


2. Briefly discuss the steps involved in inserting, re-sizing and changing the Chart/graph in MS PowerPoint.              6+3+3

 

Answer: Here’s a brief discussion on the steps involved in inserting, resizing, and changing a chart/graph in MS PowerPoint:

 

 Inserting a Chart/Graph :

1. Open the Slide: Navigate to the slide where you want to insert the chart/graph.

2. Insert a Chart: Go to the "Insert" tab in the Ribbon.

3. Choose Chart Option: Click on the "Chart" icon.

4. Select Chart Type: In the "Insert Chart" dialog box, choose the desired chart type (e.g., Bar, Line, Pie).

5. Enter Data: An Excel spreadsheet will open; enter your data into the spreadsheet.

6. Close Excel: Close the Excel window, and the chart/graph will appear on the slide.

 

 Resizing the Chart/Graph :

1. Select the Chart: Click on the chart to select it.

2. Drag to Resize: Use the corner handles to drag and resize the chart proportionally.

3. Adjust Proportion: Alternatively, use the side handles to adjust the height or width independently.

 

 Changing the Chart/Graph :

1. Select the Chart: Click on the chart to highlight it.

2. Access Chart Tools: Go to the "Chart Tools" section in the Ribbon, where you'll find "Design" and "Format" tabs.

3. Choose a New Chart Type: In the "Design" tab, click on "Change Chart Type" and select a new chart style to apply.

Comments

Post a Comment

Popular posts from this blog

Chapter 3: Special Areas of Audit in India

-
3.1 Special Areas of Audit   Auditing is not limited to the examination of financial statements alone. There are several specialized areas of audit that address specific needs and requirements of different aspects of an organization’s operations. In India, special areas of audit include cost audit, tax audit, and management audit, among others. This chapter will delve into these special areas, recent trends in auditing, considerations in an Electronic Data Processing (EDP) environment, computer-aided audit techniques and tools, and auditing standards.         3.2 Special Features of Cost Audit   Cost Audit: A cost audit involves the verification of cost accounts and checking the adherence to cost accounting plans. It is governed by the Cost and Works Accountants Act, 1959, and the Companies (Cost Records and Audit) Rules, 2014.   Key Features: - Compliance Verification: Ensures that cost records are maintained as per the prescribe...
Read more

Chapter 1: Introduction to Income Tax in India

-
This chapter provides a foundational understanding of income tax concepts and terms, residential status, and exempted income as per Indian tax laws. We'll break down each concept in simple language and provide examples relevant to India.     1.1 Basic Concepts     1.1.1 Income   Income refers to the money or financial gains earned by an individual or entity. This can come from various sources such as salaries, business profits, investments, or rental income.   - Example: An individual earning Rs. 50,000 per month from a salaried job, Rs. 10,000 from rental income, and Rs. 5,000 from interest on savings accounts has an income that combines these sources.     1.1.2 Agricultural Income   Agricultural Income is defined as income derived from agricultural activities. According to Indian tax laws, income from farming, growing crops, or raising livestock is considered agricultural income.   - Example: A farmer earn...
Read more

NBU CBCS SEC (H) : E-Commerce Revised Syllabus

-
Revised Syllabus for B.Com Honours Program [Effective from: 2022-23]   B.Com. Honours Program: Semester IV COURSE SEC(H)-2   E-COMMERCE   Marks: 75 (Lectures: 50)   Objective: To enable the students to become familiar with the mechanism of dealing with the business transactions through electronic means and the security mechanism.   Contents:   Unit I: Introduction (Lectures: 10) Meaning, nature, concepts, advantages, disadvantages and reasons for transacting online; types of E-Commerce, e-commerce business models (introduction , key elements of a business model and categorizing major E-commerce business models), forces behind e- commerce; Designing, building and launching e-commerce website.   Unit II: E-payment System (Lectures: 10) Models and methods of e–payments (Debit Card, Credit Card, Smart Cards, e-money), 24 digital signatures (procedure, working and legal position), payment gateways, online banking (meaning, ...
Read more