BUSI 201
Intermediate Business Computer
Applications
Comprehensive Midterms Test (Qns & Ans)
2025
1. Which of the following software applications is primarily
used for data analysis and visualization in business?
- A. Microsoft Word
- B. Microsoft Excel
- C. Microsoft PowerPoint
- D. Microsoft Access
ANS: B. Microsoft Excel
©/2025
, Rationale: Microsoft Excel is widely used for data analysis
and visualization in business due to its powerful features,
including formulas, charts, and pivot tables.
2. What is the primary purpose of using macros in Microsoft
Excel?
- A. To create text documents
- B. To automate repetitive tasks
- C. To design presentations
- D. To manage databases
ANS: B. To automate repetitive tasks
Rationale: Macros in Microsoft Excel are used to automate
repetitive tasks, saving time and reducing the likelihood of errors.
Fill-in-the-Blank Questions
3. In Microsoft Access, a __________ is a database object used
to store and organize data.
ANS: table
Rationale: A table is a database object in Microsoft Access
used to store and organize data in rows and columns.
©/2025
,4. The __________ function in Microsoft Excel is used to sum a
range of cells based on specified criteria.
ANS: SUMIF
Rationale: The SUMIF function in Microsoft Excel is used to
sum a range of cells that meet specified criteria, allowing for
conditional summation.
True/False Questions
5. True or False: Pivot tables in Microsoft Excel are used to
summarize, analyze, and present data in a tabular format.
ANS: True
Rationale: Pivot tables in Microsoft Excel are used to
summarize, analyze, and present data in a tabular format, making
it easier to derive insights from large datasets.
6. True or False: In Microsoft Access, a query is used to retrieve
specific data from one or more tables.
ANS: True
©/2025
, Rationale: A query in Microsoft Access is used to retrieve
specific data from one or more tables based on specified criteria,
enabling users to extract meaningful information from the
database.
Multiple Response Questions
7. Which of the following features are available in Microsoft
PowerPoint to enhance presentations? (Select all that apply)
- A. Animations
- B. Transitions
- C. Pivot tables
- D. Slide Master
ANSs: A, B, D
Rationale: Features available in Microsoft PowerPoint to
enhance presentations include animations, transitions, and the
Slide Master. Pivot tables are a feature of Microsoft Excel, not
PowerPoint.
8. Which of the following file formats can be used to save a
Microsoft Excel workbook? (Select all that apply)
- A. .xls
- B. .docx
©/2025
Intermediate Business Computer
Applications
Comprehensive Midterms Test (Qns & Ans)
2025
1. Which of the following software applications is primarily
used for data analysis and visualization in business?
- A. Microsoft Word
- B. Microsoft Excel
- C. Microsoft PowerPoint
- D. Microsoft Access
ANS: B. Microsoft Excel
©/2025
, Rationale: Microsoft Excel is widely used for data analysis
and visualization in business due to its powerful features,
including formulas, charts, and pivot tables.
2. What is the primary purpose of using macros in Microsoft
Excel?
- A. To create text documents
- B. To automate repetitive tasks
- C. To design presentations
- D. To manage databases
ANS: B. To automate repetitive tasks
Rationale: Macros in Microsoft Excel are used to automate
repetitive tasks, saving time and reducing the likelihood of errors.
Fill-in-the-Blank Questions
3. In Microsoft Access, a __________ is a database object used
to store and organize data.
ANS: table
Rationale: A table is a database object in Microsoft Access
used to store and organize data in rows and columns.
©/2025
,4. The __________ function in Microsoft Excel is used to sum a
range of cells based on specified criteria.
ANS: SUMIF
Rationale: The SUMIF function in Microsoft Excel is used to
sum a range of cells that meet specified criteria, allowing for
conditional summation.
True/False Questions
5. True or False: Pivot tables in Microsoft Excel are used to
summarize, analyze, and present data in a tabular format.
ANS: True
Rationale: Pivot tables in Microsoft Excel are used to
summarize, analyze, and present data in a tabular format, making
it easier to derive insights from large datasets.
6. True or False: In Microsoft Access, a query is used to retrieve
specific data from one or more tables.
ANS: True
©/2025
, Rationale: A query in Microsoft Access is used to retrieve
specific data from one or more tables based on specified criteria,
enabling users to extract meaningful information from the
database.
Multiple Response Questions
7. Which of the following features are available in Microsoft
PowerPoint to enhance presentations? (Select all that apply)
- A. Animations
- B. Transitions
- C. Pivot tables
- D. Slide Master
ANSs: A, B, D
Rationale: Features available in Microsoft PowerPoint to
enhance presentations include animations, transitions, and the
Slide Master. Pivot tables are a feature of Microsoft Excel, not
PowerPoint.
8. Which of the following file formats can be used to save a
Microsoft Excel workbook? (Select all that apply)
- A. .xls
- B. .docx
©/2025
