BUSI 201
Intermediate Business Computer
Applications
Finals Exam (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANS. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANS before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which of the following best describes the primary function of
a database management system (DBMS)?
- A. To create and edit documents
- B. To store, retrieve, and manage data in databases
- C. To design graphics and images
- D. To manage email communications
- ANS: B
- Rationale: A database management system (DBMS) is used
to store, retrieve, and manage data in databases, ensuring efficient
data handling and organization.
2. What is the primary purpose of using pivot tables in
spreadsheet applications?
- A. To create charts and graphs
- B. To summarize and analyze large datasets
- C. To write and execute macros
- D. To manage email communications
- ANS: B
©2024/2025
, - Rationale: Pivot tables are used to summarize and analyze
large datasets, allowing users to extract meaningful insights and
trends from the data.
3. Which of the following is a key feature of cloud computing?
- A. Local data storage
- B. On-demand access to computing resources
- C. Manual data backup
- D. Offline data processing
- ANS: B
- Rationale: Cloud computing provides on-demand access to
computing resources, allowing users to access and manage data
and applications over the internet.
Fill-in-the-Blank Questions
4. The __________ function in spreadsheet applications is used
to calculate the sum of a range of cells.
- ANS: SUM
- Rationale: The SUM function is used to calculate the sum
of a range of cells, providing a quick and efficient way to perform
addition operations in spreadsheets.
©2024/2025
, 5. In database management, __________ refers to the process of
organizing data to minimize redundancy and improve data
integrity.
- ANS: Normalization
- Rationale: Normalization is the process of organizing data
to minimize redundancy and improve data integrity, ensuring that
the database is efficient and consistent.
True/False Questions
6. Macros in spreadsheet applications are used to automate
repetitive tasks.
- ANS: True
- Rationale: Macros are used to automate repetitive tasks in
spreadsheet applications, saving time and reducing the likelihood
of errors.
7. A relational database is a type of database that stores data in a
single table.
- ANS: False
- Rationale: A relational database stores data in multiple
tables that are related to each other through key fields, allowing
for efficient data organization and retrieval.
Multiple Response Questions
©2024/2025
Intermediate Business Computer
Applications
Finals Exam (Qns & Ans)
2025
General Instructions
1. Read All Questions Carefully: Make sure you understand each question.
2. Time Management: You have a specific amount of time to complete the exam.
Keep an eye on the clock and pace yourself.
3. Allowed Materials: Only use materials that are explicitly allowed. Unauthorized
materials can lead to disqualification.
4. ANS Format: Follow the required format for your ANS. For example, multiple-
choice questions might need you to select the best ANS, while essay questions
require detailed responses.
5. Academic Integrity: Adhere to the university's honor code. Any form of cheating or
plagiarism is strictly prohibited.
6. Technical Requirements: Ensure your computer and internet connection are
stable. For online exams, you might need a webcam and microphone for proctoring
purposes.
7. Submission: Submit your ANS before the time expires. Late submissions might
not be accepted.
©2024/2025
,1. Which of the following best describes the primary function of
a database management system (DBMS)?
- A. To create and edit documents
- B. To store, retrieve, and manage data in databases
- C. To design graphics and images
- D. To manage email communications
- ANS: B
- Rationale: A database management system (DBMS) is used
to store, retrieve, and manage data in databases, ensuring efficient
data handling and organization.
2. What is the primary purpose of using pivot tables in
spreadsheet applications?
- A. To create charts and graphs
- B. To summarize and analyze large datasets
- C. To write and execute macros
- D. To manage email communications
- ANS: B
©2024/2025
, - Rationale: Pivot tables are used to summarize and analyze
large datasets, allowing users to extract meaningful insights and
trends from the data.
3. Which of the following is a key feature of cloud computing?
- A. Local data storage
- B. On-demand access to computing resources
- C. Manual data backup
- D. Offline data processing
- ANS: B
- Rationale: Cloud computing provides on-demand access to
computing resources, allowing users to access and manage data
and applications over the internet.
Fill-in-the-Blank Questions
4. The __________ function in spreadsheet applications is used
to calculate the sum of a range of cells.
- ANS: SUM
- Rationale: The SUM function is used to calculate the sum
of a range of cells, providing a quick and efficient way to perform
addition operations in spreadsheets.
©2024/2025
, 5. In database management, __________ refers to the process of
organizing data to minimize redundancy and improve data
integrity.
- ANS: Normalization
- Rationale: Normalization is the process of organizing data
to minimize redundancy and improve data integrity, ensuring that
the database is efficient and consistent.
True/False Questions
6. Macros in spreadsheet applications are used to automate
repetitive tasks.
- ANS: True
- Rationale: Macros are used to automate repetitive tasks in
spreadsheet applications, saving time and reducing the likelihood
of errors.
7. A relational database is a type of database that stores data in a
single table.
- ANS: False
- Rationale: A relational database stores data in multiple
tables that are related to each other through key fields, allowing
for efficient data organization and retrieval.
Multiple Response Questions
©2024/2025
