Computer Applications in
Business Question Solved Paper’ 2023 (May/June)
COMMERCE (Core)
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 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.
Post a Comment
Kindly give your valuable feedback to improve this website.