Gauhati University, located in Guwahati, Assam, is one of the prominent educational institutions in Northeast India. It offers a wide range of undergraduate and postgraduate courses to students across various disciplines. The Bachelor of Commerce (BCom) program at Gauhati University is highly regarded for its comprehensive curriculum and focus on practical applications in the business world. In this article, we will explore the Gauhati University BCom 3rd Sem Computer Applications in Business Question Paper for the year 2021 (Held in 2022), shedding light on its importance and the Questions asked in Examinations.
Gauhati University B.Com 3rd Sem, CBCS Pattern
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
-0000-
Also Read :-