Computer Applications in Business Solved Question Paper’ 2023 [Dibrugarh University BCOM 4th SEM Hons]

Computer Applications in Business Question Solved Paper’ 2023 (May/June)
Paper: C-410 (Computer Applications in Business)
Full Marks: 80
Pass Marks: 32
Time: 3 hours

The figures in the margin indicate full marks for the questions

1. Answer the following questions:                         1x8=8

(a) What is Entity?

Ans: An entity is a distinct real-world thing, such as a person, a place, or a concept, that can be uniquely identified. It's an object that stands out from the crowd.

(b) What is Database?

Ans: A database is an electronically stored, systematic collection of data. It can contain any type of data, including words, numbers, images, videos, and files.

(c) What is SQL?

Ans: SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases. It provides a standardized way to communicate with and perform operations on databases.

(d) What do you mean by Slideshow?

Ans: A slide show is a presentation of a series of still images on a projection screen or electronic display device, typically in a prearranged sequence. The changes may be automatic and at regular intervals or they may be manually controlled by a presenter or the viewer.

(e) Define the term template in Word Processing.

Ans: A design template or template is a file created with an overall layout to be used with one or more documents. For example, a word processor may have a template for a resume. With a resume template, the overall layout is designed with placeholder text that you can replace with information relevant to you.

(f) What do you mean by Autocorrect?

Ans: AutoCorrect is a specific feature in MS Word which fixes common spelling mistakes and typing errors automatically while you type. It replaces misspelled or mistyped words with the correct versions.

(g) What is Worksheet?

Ans: A worksheet also known as a spreadsheet consists of cells in which we can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.

(h) What is Active Cell in MS-Excel?

Ans: The active cell is the selected cell in which data is entered when we begin typing. Only one cell is active at a time. Data can only be entered into the active cell.

2. Answer the following questions:                         2x8=16

(a) What are the different views in MS-PowerPoint?

Ans: Microsoft PowerPoint has three main views: normal view, slide sorter view, and slide show view. Normal View is the main editing view, which is used to write and design a presentation.

(b) What is paragraph formatting in MS-Word?

Ans: Paragraph formatting is a process of organizing and arranging texts in a document to follow a stipulated pattern. Paragraph formatting is a change in the format of text that affects an entire paragraph or is different from other paragraphs in a document.

(c) Write the steps to add background to a slide.

Ans: Adding a background picture to a slide:

1. Select the slide you want to add a background picture to.

2. Select Design > Format Background.

3. In the Format Background pane, select Picture or texture fill.

4. Select File.

5. In the Insert Picture dialog box, choose the picture you want to use and then select Insert.

6. Make adjustments to the background picture to make sure text is visible and it's positioned where you want.

- Use Transparency to make the picture lighter.

- Use the Offset settings to adjust the position of the picture.

- Use Tile picture as texture to repeat the picture across the slide.

7. If you want the background picture on every slide, select Apply to All.

(d) What is Header and Footer in a document?

Ans: The header is a section of the document that appears in the top margin, while the footer is a section of the document that appears in the bottom margin. Headers and footers will help keep long documents organized and make them easier to read

(e) Describe two functions used in MS-Excel.

Ans: Mathematical functions in excel are used to perform various mathematical calculations like sum, average, count etc. For example:  A) Sum (): This is used to find sum of the values within a given range of cell.

Logical Functions: Logic Functions in Excel check the data and return the result «TRUE» if the condition is true, and «FALSE» if not.

For Example: A) Logical Function IF (): Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

(f) How will you show a text vertically in a cell?

Ans: Steps to show a text vertically in a cell:

- Select the cells containing the text you want to make vertical.

- Click on the "Alignment" tab in the "Format Cells" dialog box.

- Under "Text alignment," select the "Vertical" dropdown list.

- Select the "Rotate text up" or "Rotate text down" option.

(g) What is Relational Data Model?

Ans:  Relational data model is the primary data model, which is used widely around the world for data storage and processing.  It makes data sorting and data access easier and Provides a standard way to organize data in databases.

(h) Write the names of two popular DBMS, software.

Ans: Popular DBMS Software examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.

3. (a) Explain the different components/symbols of an E-R model.           6

Ans: Buy Computer Applications in Business Complete Notes and Solved Papers PDF @ Rs. 175

(b) Write the advantages and disadvantages of DBMS. 6

Ans: Buy Computer Applications in Business Complete Notes and Solved Papers PDF @ Rs. 175

(c) Write SQL to create a table named student with attributes Reg. No., Name, Address, Marks, email.                  5

Ans: Buy Computer Applications in Business Complete Notes and Solved Papers PDF @ Rs. 175

4. (a) What is mail-merge? Write the steps for mail-merge in MS-Word. 1+5=6

Ans: Mail merge is a specific feature of MS-Word, which enables users to send a similar email or document to more than one recipient at a time. It enables connecting a single form template with a data source that contains information about the recipient’s name, address and other predefined and supported data.

Benefits of Mail Merge: With the help of mail merge feature, one mail is sent to more than one recipient at a time which saves times and efforts. It simplified producing mass mailing.

Steps in Mail Merge:

1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge.

2. Click Step-by-Step Mail Merge Wizard.

3. Select your document type. (Letters, E-mail, Envelopes, Labels, Directory etc.)

 4. Select the starting document. Select Use the current document and then click Next: Select recipients.

5. Create new list of recipients by adding address list of various recipients or select from outlook contacts or type a new list. Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records. Click OK to accept the list as is.

6. Then Click Next: Write your letter.

7. Click Address block to add the recipients' addresses at the top of the document. In the Insert Address Block dialog box, check or uncheck boxes and select options on the left until the address appears the way you want it to.

8. Then, preview your letter and click Next: Complete the merge.

(b) Write the steps for using ‘chart’ in Excel.       4

Ans: Creating a chart in Microsoft Office Excel is quick and easy. Excel provides a variety of chart types that you can choose from when you create a chart. For most charts, such as column and bar charts, you can plot the data that you arrange in rows or columns on a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) in a chart. Some chart types, however, such as pie and bubble charts, require a specific data arrangement.

Steps of inserting a chart in MS-Excel

a)       On the worksheet, arrange the data that you want to plot in a chart.

b)      Select the cells that contain the data that you want to use for the chart.

c)       On the Insert tab, in the Charts group, Click the chart type, and then click a chart subtype that you want to use.

(c) Write the steps for using slide animation in MS-PowerPoint.                5

Ans: To add animation to objects in power point:

- Select the object and go to the "Animations" tab.

- Choose an animation from the available options or customize the animation effects.

- You can set the animation to occur when the slide loads or when you click on the object during the slideshow.

5. (a) Write the steps to perform the following (any four):           3x4=12

(1) Change the size of a font in MS-Word.

Ans: Steps to change the size of a font:

- Select the text that you want to change.

- Click the Format tab under Text Box Tools, and then type or select a point size in the Font Size list Button image.

Also Read:

Computer Applications in Business Question Paper 2022 Dibrugarh university BCOM 4th Sem

Computer Applications in Business Question Paper 2023 Dibrugarh university BCOM 4th Sem

Computer Applications in Business Solved Question Paper 2022 Dibrugarh university BCOM 4th Sem

Computer Applications in Business Solved Question Paper 2022 Dibrugarh university BCOM 4th Sem


(2) Change the line spacing in MS-Word.

Ans: Change the line spacing in a portion of the document

- Select one or more paragraphs to update. Press Ctrl + A to select all.

- Go to Home > Line and Paragraph Spacing.

- Select Line Spacing Options and choose an option in the Line spacing box.

- Adjust the Before and After settings to change spacing between paragraphs.

- Select OK.

(3) Change the height of a row in an Excel.

Ans: Steps to change the height of a row in an excel:

- Select the row or rows that you want to change. 

- Go to Home > Cells > Format. 

- Under Cell Size, select Row Height. 

- In the Row height box, type the value that you want, and then select OK.

(4) Enclose a cell in a shadow box in an Excel.

Ans: Steps to enclose a cell in a shadow box:

- Select the cells that you want to add a shadow effect to.

- Right-click on the selected cells and choose "Format Cells" from the context menu.

- In the "Format Cells" dialog box, go to the "Fill" tab.

- Click on the "Effects" button at the bottom of the dialog box.

- Check the box next to "Shadow" to enable the shadow effect.

- Adjust the settings for the shadow effect, such as the color, size, and direction.

- Click "OK" to apply the shadow effect to the selected cells.

(5) Convert existing text to Word Art in PowerPoint.

Ans: Convert existing text to WordArt

- Select the text to convert to WordArt.

- On the Insert tab, click WordArt, and then pick the WordArt style you want.

(6) Hide a slide from slide show.

Ans: Steps to Hide a slide:

- In the left navigation pane, select the thumbnail image of the slide you want to hide.

- Right-click the slide, then select Hide Slide. The slide now shows a slash through the slide number to indicate that it's hidden:

(b) Write short notes on (any three):                      4x3=12

(1) Ratio analysis.

Ans: Ratio analysis is the method or process of expressing relationship between items or group of items in the financial statement are computed, determined and presented. It is an attempt to draw quantitative measures or guides concerning the financial health and profitability of an enterprise. It can be used in trend and static analysis. It is the process of comparison of one figure or item or group of items with another, which make a ratio, and the appraisal of the ratios to make proper analysis of the strengths and weakness of the operations of an enterprise.

According to Myers, “Ratio analysis of financial statements is a study of relationship among various financial factors in a business as disclosed by a single set of statements and a study of trend of these factors as shown in a series of statements."

(2) Using DBMS in the area of accounting.

Ans: Buy Computer Applications in Business Complete Notes and Solved Papers PDF @ Rs. 175

(3) The importance of using spread-sheets’ in Business application.

Ans: Buy Computer Applications in Business Complete Notes and Solved Papers PDF @ Rs. 175

(4) Windows Operating System.

Ans: The Windows Operating System, developed by Microsoft, is a user-friendly platform renowned for its graphical interface. It features the Start Menu, Taskbar, and Control Panel for easy navigation, supporting multitasking for running multiple applications simultaneously. Regular updates enhance security, and its broad compatibility accommodates various software and hardware. Seamless integration with Microsoft services facilitates access to applications, cloud storage, and productivity tools. Widely used across personal computers, laptops, and servers, Windows excels in gaming with DirectX support. Its versatility, user-friendly updates, and extensive compatibility contribute to its pervasive use in diverse computing environments, meeting the needs of both casual users and professionals.

(5) Word Processing.

Ans: Word processing refers generally to the creation, editing, formatting, storage, and output of both printed and online or electronic documents. Word processing is undoubtedly the most-used business application for personal computers, perhaps alongside World Wide Web browsers and electronic-mail (e-mail) applications.

Word-processing software includes basic applications designed for casual business or home users and powerful, advanced applications capable of meeting the most-demanding needs of businesses. Many word-processing applications are designed for use as part of a suite or integrated group of word-processing, spreadsheet, and presentation programs. For example, Microsoft Word, probably the most widely used word-processing software, is part of the Microsoft Office suite, which includes Microsoft's PowerPoint presentation program and Excel spreadsheet program.

Features of MS-word or Word processing

The main features are:

a) We can create professional documents fast using custom templates.

b) We easily manage large documents using various features like the ability to create table of contents, index, and cross-references.

c) We can easily add, remove and copy text in a word file.

d) We can work on multiple documents simultaneously.

e) We can easily conduct spelling and grammar check.

0/Post a Comment/Comments

Kindly give your valuable feedback to improve this website.