Computer Applications in Business Question Paper’ 2021 (Held in 2022), Gauhati University B.Com 3rd Sem, CBCS Pattern

Computer Applications in Business Question Paper’ 2021 (Held in 2022)

Gauhati University B.Com 3rd Sem, CBCS Pattern 

(SEM-3/CBCS) CAB HC 1

2021 (Held in 2022)

COMMERCE (Honours)

Paper: COM-HC-3016

(Computer Applications in Business)

Full Marks: 40

Time: Two hours

The figures in the margin indicate full marks for the questions.

1. Choose the right alternatives:                  1×4=4

(a)       What do you mean by a word template?

(1)       A pre-created and formatted document style.

(2)       A word document.

(3)       An unformatted document.

(4)       None of the above.

(b)       The short key for find and replace option in MS Word:

(1)       Ctrl + f.

(2)       Ctrl + r.

(3)       Alt + f.

(4)       Alt + r.

(c)    The primary key of a database table –

(1)       Cannot identify a record uniquely.

(2)       Can identity a record uniquely.

(3)       Can identity tables.

(4)       None of the above.

(d)       PMT calculates the –

(1)       Payment for a loan based on constant payments and a constant
interest rate.

(2)       Salary payments.

(3)       Correlation coefficient.

(4)       None of the above.

2. Answer the following questions in brief:         2×3=6

(1)       Write the keyboard shortcuts for Undo and Centre Alignment in MS Word.

(2)       How to add text to a PowerPoint slide?

(3)       What is mail merge?

3. Answer the following questions: (any two)            5×2=10

(1)       Write about different features available under the Page Layout menu of MS Word.

(2)       Write about different features available under the Insert menu of MS Excel.

(3)       Write about how to make better PowerPoint presentations including the 5/5/5 rule.

(4)       Define Candidate key, Primary key and Alternate Key.

4. Answer the following questions: (any two)            10×2=20

(1)       What is an ER diagram? What are the common symbols for drawing an ER diagram? Also write how an entity and its different attributes are represented with the help of a table in a database.              2+3+5=10

(2)       Write and describe at least five financial and statistical spreadsheet (Excel) functions.    2×5=10

(3)       What is Database Management System? Write the characteristics of DBMS. Also describe the applications of DBMS.         2+3+5=10

(4)       State few word processing software. Explain different features and advantages of using MS Word and Google Docs.          4+6=10

(5)       Explain with the help of an example, how payroll statements can be easily prepared with the help of spreadsheet software like MS Excel or Open Office.         10 

***