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Â
***