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 Solved Question Paper for the year 2021, shedding light on its importance and the Questions asked in Examinations.
Computer Applications in Business Solved Question Paper’ 2021
Gauhati University B.Com 3rd Sem, CBCS Pattern
(SEM-3/CBCS) CAB HC 1
2021
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.
Ans:- (1) A pre-created and formatted document style.
(b) The short key for find and replace option in MS Word:
(1) Ctrl + f.
(2) Ctrl + r.
(3) Alt + f.
(4) Alt + r.
Ans:- (1) Ctrl + f.
(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.
Ans:- (2) Can identify a record uniquely.
(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.
Ans:- (1) Payment for a loan based on constant payments and a constant interest rate.
2. Answer the following questions in brief: 2×3=6
(1) Write the keyboard shortcuts for Undo and Centre Alignment in MS Word.
Ans:- (1) The keyboard shortcuts for Undo and Center Alignment in MS Word are as follows:
- Undo: Ctrl + Z
- Center Alignment: Ctrl + E
(2) How to add text to a PowerPoint slide?
Ans:- To add text to a PowerPoint slide, you can follow these steps:
- Open PowerPoint and select the slide where you want to add text.
- Click on the text box placeholder on the slide. If there's no text box, go to the "Insert" tab and click on "Text Box" to create one.
- Click inside the text box and start typing your text. You can also copy and paste text from other sources.
- Format the text as desired using the options available in the "Home" tab, such as font style, size, color, and alignment.
(3) What is mail merge?
Ans:- Mail merge is a feature in Microsoft Word that allows you to create personalized letters, envelopes, labels, or other documents by combining a main document with a data source. The main document contains the generic content, while the data source contains the variable information, such as names and addresses. The mail merge process automatically fills in the variable information from the data source into the main document, creating customized documents for each recipient.
3. Answer the following questions: (any two) 5×2=10
(1) Write about different features available under the Page Layout menu of MS Word.
Ans:- Features available under the Page Layout menu of MS Word:
The Page Layout menu in MS Word provides various tools and options to customize the layout and appearance of your documents. Here are some of the key features available under the Page Layout menu:
1. Margins: Allows you to set the size of the margins around your document. You can choose from predefined margin settings or customize them according to your needs.
2. Orientation: Lets you change the orientation of the page between portrait (vertical) and landscape (horizontal). This is useful when you want to create documents with different page orientations.
3. Size: Enables you to specify the size of the page. You can select from standard page sizes like Letter, Legal, A4, etc., or define a custom page size.
4. Columns: Allows you to divide your document into multiple columns. You can choose the number of columns, adjust the column width and spacing, and apply column settings to the entire document or specific sections.
5. Breaks: Provides options to insert various types of breaks in your document. These include page breaks, section breaks, and column breaks, which help control the layout and formatting of your content.
6. Line Numbers: Allows you to add line numbers to your document. Line numbers can be useful for referencing specific lines in academic or legal documents.
7. Hyphenation: Enables automatic hyphenation of words at the end of lines to improve the overall appearance of your document. You can adjust hyphenation settings to control how words are hyphenated.
8. Page Borders: Lets you apply borders around the pages or sections of your document. You can customize the style, color, and width of the borders to enhance the visual appeal of your document.
(2) Write about different features available under the Insert menu of MS Excel.
Ans:- Features available under the Insert menu of MS Excel:
The Insert menu in MS Excel provides various features and options to add and customize different elements within your spreadsheet. Here are some of the key features available under the Insert menu:
1. Tables: Allows you to insert a table into your spreadsheet. You can create a table from existing data, specify the number of rows and columns, and apply formatting options.
2. Charts: Enables you to create visual representations of your data using different types of charts, such as column charts, line charts, pie charts, and more. Excel provides a variety of chart customization options to present your data effectively.
3. Sparklines: Lets you insert small, inline charts that represent trends or patterns within a cell range. Sparklines are useful for providing quick visual summaries of your data.
4. Filters: Provides options to add filters to your data, making it easier to analyze and sort information based on specific criteria. You can apply filters to columns and quickly view subsets of data that meet your filtering conditions.
5. PivotTables: Allows you to create PivotTables, which are powerful tools for summarizing and analyzing large sets of data. PivotTables enable you to group and summarize data based on different criteria, providing valuable insights.
6. Hyperlinks: Enables you to insert hyperlinks to web pages, files, email addresses, or specific locations within the spreadsheet.
(3) Write about how to make better PowerPoint presentations including the 5/5/5 rule.
Ans:- How to Make Better PowerPoint Presentations including the 5/5/5 Rule:
PowerPoint presentations are a widely used tool for delivering information in a visually engaging and organized manner. To create more effective and impactful presentations, you can follow several best practices, including the 5/5/5 rule. Here are some tips to help you make better PowerPoint presentations:
1. Keep it Simple: One of the most important aspects of a successful presentation is simplicity. Avoid overcrowding slides with excessive text or complex graphics. Stick to a clean and minimalistic design that allows your audience to focus on the key message.
2. Use High-Quality Images: Visuals are crucial in capturing and retaining audience attention. Incorporate high-quality images, charts, and graphs that are relevant to your content. Avoid using clip art or low-resolution graphics that can make your presentation appear unprofessional.
3. Choose Legible Fonts and Colors: Select fonts that are easy to read and use consistent font styles throughout your presentation. Opt for clear, sans-serif fonts like Arial or Calibri. Also, ensure sufficient contrast between text and background colors to enhance readability.
4. Maintain Consistency: Consistency is essential for creating a professional and cohesive presentation. Use a consistent color scheme, font styles, and formatting throughout your slides. This helps establish visual harmony and improves the overall flow of your presentation.
5. Limit Text and Bullet Points: Avoid overwhelming your audience with excessive text. Instead, use bullet points to highlight key information. Following the 5/5/5 rule means limiting each slide to no more than five bullet points, with each bullet containing no more than five words, and no more than five slides per minute of your presentation. This rule encourages brevity and ensures that your audience can easily grasp the main points.
6. Add Engaging Transitions and Animations: Incorporating subtle and meaningful transitions and animations can enhance the flow of your presentation. However, avoid overusing them, as excessive animations can be distracting and detract from the content.
7. Practice and Rehearse: Before delivering your presentation, practice and rehearse to ensure a smooth delivery. Familiarize yourself with the content, timings, and transitions. Rehearsing will boost your confidence and help you deliver a more engaging presentation.
(4) Define Candidate key, Primary key and Alternate Key.
Ans:- Definitions:
Candidate Key: In the context of database design, a candidate key refers to a column or a set of columns that can uniquely identify each row or record in a relational database table. It is a potential candidate for being selected as the primary key of the table.
Primary Key: A primary key is a specific candidate key that is chosen to uniquely identify each row in a database table. It must have two essential properties: uniqueness (each value in the primary key column(s) must be unique) and non-nullity (primary key values cannot be null). A primary key helps maintain data integrity, as it ensures that each record in a table can be uniquely identified.
Alternate Key: An alternate key, also known as a secondary key, is a candidate key that is not selected as the primary key. It provides an alternative means of identifying rows in a database table. While it may not be the primary identifier, an alternate key still has the properties of uniqueness and non-nullity. It can be used for certain operations or to establish relationships with other tables in the database schema.
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
Ans:- An ER (Entity-Relationship) diagram is a graphical representation of the entities, relationships, and attributes in a database system. It helps to visualize and design the structure of a database and the relationships between different entities.
Common symbols used in an ER diagram include:
1. Entity: Represented by a rectangle or square, it represents a distinct object, concept, or thing in the real world. For example, a "Customer" entity in a database may have attributes like "CustomerID," "Name," and "Email."
2. Attribute: Represented by an oval or ellipse, it describes the properties or characteristics of an entity. Attributes provide more information about an entity. For example, the "Name" attribute of the "Customer" entity represents the customer's name.
3. Relationship: Represented by a diamond shape, it represents the association between entities. Relationships show how entities are connected or related to each other. For example, a "Customer" entity may have a relationship with an "Order" entity, indicating that a customer can place multiple orders.
4. Cardinality: Represented by lines or arrows, it specifies the number of instances of one entity that can be associated with another entity. Cardinality defines the nature of the relationship, such as one-to-one, one-to-many, or many-to-many.
In a relational database, an entity and its attributes are typically represented using tables. Each table consists of rows and columns, where each row represents an instance of the entity, and each column represents an attribute or characteristic of that entity. Here's an example of how an entity and its attributes can be represented using a table:
Let's consider an entity called "Employee" with the following attributes:
1. Employee ID (unique identifier for each employee)
2. First Name
3. Last Name
4. Date of Birth
5. Email
6. Department
Here's how the table representation would look:
In this representation, each row corresponds to an individual employee, and each column represents a specific attribute of an employee. The Employee ID serves as a unique identifier for each employee, ensuring that each row is distinct. The other columns hold the relevant information for each attribute of an employee, such as their first name, last name, date of birth, email, and department.
By structuring the data in this tabular format, a database management system can efficiently store, retrieve, and manipulate the information for various entities and their attributes.
(2) Write and describe at least five financial and statistical spreadsheet (Excel) functions. 2×5=10
Ans:- Following are the five commonly used financial functions in Excel along with their descriptions:
1. PV (Present Value): The PV function calculates the present value of an investment or a series of cash flows. It takes into account the future value, interest rate, and the number of periods to determine the present value of the cash flows. This function is useful for evaluating the worth of an investment in today's dollars.
2. FV (Future Value): The FV function calculates the future value of an investment or a series of cash flows. It considers the initial investment, interest rate, and the number of periods to determine the future value of the investment. This function helps in forecasting the value of an investment at a future date.
3. PMT (Payment): The PMT function calculates the periodic payment amount required to repay a loan or an investment based on a fixed interest rate and a fixed number of periods. It takes into account the principal amount, interest rate, and the number of periods to determine the regular payment required.
4. RATE: The RATE function calculates the interest rate per period for an investment or loan. It considers the number of periods, payment amounts, and the present value or future value to determine the interest rate. This function is useful for determining the interest rate needed to achieve a desired future value or to evaluate the cost of borrowing.
5. NPV (Net Present Value): The NPV function calculates the net present value of a series of cash flows by discounting them to their present value and subtracting the initial investment. It takes into account the discount rate and the cash flows occurring at different periods to determine the net present value.
-Following are the five statistical functions commonly used in spreadsheets like Excel_
1. SUM: The SUM function calculates the sum of a range of cells. It adds up all the numbers in the specified range and returns the total. For example, if you have a column of numbers in cells A1 to A5 and you want to find their sum, you can use the formula "=SUM(A1:A5)".
2. AVERAGE: The AVERAGE function calculates the average value of a range of cells. It adds up all the numbers in the specified range and divides the sum by the count of numbers. This function is useful for finding the average of a set of values. For example, if you have a column of numbers in cells A1 to A5 and you want to find their average, you can use the formula "=AVERAGE(A1:A5)".
3. COUNT: The COUNT function counts the number of cells in a range that contain numbers. It ignores empty cells and cells with text or other non-numeric values. This function is useful for determining the count of numerical data points in a range. For example, if you have a column of numbers in cells A1 to A5 and you want to count how many numbers are in that range, you can use the formula "=COUNT(A1:A5)".
4. MAX: The MAX function returns the largest value from a range of cells. It scans the specified range and identifies the highest value. This function is useful for finding the maximum value in a set of data. For example, if you have a column of numbers in cells A1 to A5 and you want to find the maximum value, you can use the formula "=MAX(A1:A5)".
5. MIN: The MIN function returns the smallest value from a range of cells. It scans the specified range and identifies the lowest value. This function is useful for finding the minimum value in a set of data. For example, if you have a column of numbers in cells A1 to A5 and you want to find the minimum value, you can use the formula "=MIN(A1:A5)".
(3) What is Database Management System? Write the characteristics of DBMS. Also describe the applications of DBMS. 2+3+5=10
Ans:- A Database Management System (DBMS) is a software system that allows users to manage, organize, and store data efficiently. It provides an interface between the users and the database, enabling them to interact with the data without worrying about the underlying details of data storage and retrieval. Here are the characteristics of DBMS:
1. Data Independence: DBMS provides a layer of abstraction that separates the physical implementation of data from its logical representation. This allows changes in the physical storage structure without affecting the application programs or user views.
2. Data Integrity: DBMS ensures the accuracy, consistency, and integrity of the data by enforcing data integrity constraints. It validates data during insertion, modification, and deletion to maintain data integrity.
3. Data Security: DBMS provides mechanisms to protect the data from unauthorized access and modification. It includes user authentication, access control, and encryption techniques to ensure data security.
4. Data Consistency: DBMS maintains the consistency of data by providing transaction management. It ensures that a database remains in a consistent state even in the presence of concurrent transactions.
5. Data Recovery and Backup: DBMS includes mechanisms for data recovery and backup to ensure that data can be restored to a consistent state in case of system failures, crashes, or other errors.
6. Query Language: DBMS provides a structured query language (SQL) that allows users to retrieve, manipulate, and update data in the database. SQL provides a standardized way to interact with the database, making it easier for users to work with the data.
Applications of DBMS:
1. Banking Systems: DBMS is extensively used in banking systems to store and manage customer data, transaction records, account details, and other financial information. It ensures data security, integrity, and consistency in handling financial transactions.
2. E-commerce Websites: DBMS is crucial for e-commerce websites that handle a large volume of customer data, product catalogs, orders, and inventory management. It enables efficient data storage, retrieval, and processing, ensuring smooth operations of online businesses.
3. Healthcare Systems: DBMS is used in healthcare systems to store and manage patient records, medical histories, test results, and other healthcare-related data. It facilitates the retrieval and sharing of patient information among healthcare providers while maintaining data privacy and security.
4. Airlines and Travel Systems: DBMS is employed in airlines and travel systems to manage flight schedules, ticket reservations, passenger records, baggage handling, and other travel-related information. It ensures efficient processing of bookings, cancellations, and modifications.
5. Educational Institutions: DBMS is utilized in educational institutions to maintain student records, course catalogs, academic results, and other administrative information. It simplifies the management of student data, course registration, and generating reports.
(4) State few word processing software. Explain different features and advantages of using MS Word and Google Docs. 4+6=10
Ans:- There are several word processing software available, but two popular options are Microsoft Word and Google Docs. Let's explore the features and advantages of each:
Microsoft Word:
1. Rich Formatting Tools: Microsoft Word offers a wide range of formatting options, including font styles, sizes, colors, paragraph settings, and advanced features like tables, charts, and shapes.
2. Advanced Editing Features: It provides tools for spell checking, grammar checking, and thesaurus to enhance the quality of your documents. Additionally, it offers features like track changes and comments for collaborative editing.
3. Offline Access: Microsoft Word is primarily a desktop application, allowing you to work on documents even when you don't have an internet connection.
4. Extensive Templates: It offers a vast collection of pre-designed templates for various document types such as resumes, reports, letters, and more, which can save time and effort.
5. Integration with Microsoft Office Suite: Word seamlessly integrates with other Microsoft Office applications like Excel and PowerPoint, enabling easy transfer of data and content between them.
Google Docs:
1. Cloud-Based Collaboration: Google Docs is a cloud-based platform, allowing multiple users to collaborate in real-time. It enables users to work together on a document simultaneously, making it ideal for team projects or remote collaboration.
2. Automatic Saving and Version History: All changes made in Google Docs are automatically saved, eliminating the risk of losing work. Additionally, it maintains a detailed version history, allowing you to revert to previous versions if needed.
3. Easy Sharing and Accessibility: Sharing documents in Google Docs is simple and flexible. You can easily grant access to specific individuals or groups, and they can view or edit the document through a web browser, regardless of the device or operating system they use.
4. Simplicity and Ease of Use: Google Docs has a user-friendly interface with intuitive features, making it easy for beginners to get started. The learning curve is generally shorter compared to Microsoft Word.
5. Add-ons and Third-Party Integrations: Google Docs supports various add-ons and integrations with third-party applications, expanding its functionality. These extensions provide additional features and enhance productivity within the document.
(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
Ans:- Payroll statements can indeed be easily prepared using spreadsheet software such as MS Excel or Open Office. These software programs provide powerful tools and features that make the process efficient and organized. Let's walk through an example of how you can create a payroll statement using MS Excel:
1. Open a new spreadsheet in MS Excel. The spreadsheet will consist of rows and columns that will hold the data for your payroll statement.
2. Set up the column headers. In the first row, enter the column headers for the different components of the payroll statement. For example, you can have columns for employee name, employee ID, hours worked, rate of pay, gross pay, deductions, and net pay.
3. Enter employee data. In the subsequent rows, enter the relevant data for each employee. Fill in the employee name, employee ID, hours worked, and rate of pay for each employee.
4. Calculate gross pay. In the "Gross Pay" column, use a formula to calculate the gross pay for each employee based on the hours worked and rate of pay. For example, if the rate of pay is in column D and hours worked in column E, you can use the formula "=D2*E2" in the gross pay column (assuming the first employee's data starts from row 2).
5. Calculate deductions. In the "Deductions" column, you can enter any applicable deductions for each employee. This can include taxes, insurance premiums, retirement contributions, etc. If the deductions are fixed amounts, you can enter them directly. If they are calculated based on percentages or formulas, you can use appropriate functions to calculate them.
6. Calculate net pay. In the "Net Pay" column, use a formula to subtract the deductions from the gross pay for each employee. For example, if the gross pay is in column F and deductions are in column G, you can use the formula "=F2-G2" in the net pay column.
7. Apply formatting. Format the spreadsheet as needed to improve readability. You can adjust column widths, apply cell formatting, add borders, or use color-coding to enhance the appearance of the payroll statement.
8. Review and finalize. Double-check the data and calculations to ensure accuracy. Make any necessary adjustments or corrections. Once you're satisfied with the results, your payroll statement is ready.
By following these steps, we can efficiently create a payroll statement using spreadsheet software. The process is flexible, and you can easily update or modify the data as needed. Additionally, spreadsheet software allows you to automate calculations, perform analysis, and generate reports, making it a valuable tool for managing payroll.
-000-
Also Read :-