BIS155 Data Analysis with Spreadsheets (DeVry) Final Exam Review 2025 (Qns & Ans

BIS155

Data Analysis with Spreadsheets

Final Exam Review (Qns & Ans)

2025



1. What is the primary purpose of using pivot tables in
spreadsheets?
A. To sort data alphabetically
B. To perform data analysis and summarize large datasets
C. To remove duplicates from a dataset
D. To create dynamic charts automatically
ANS: B. To perform data analysis and summarize large
datasets


©2025

, Rationale: Pivot tables are powerful tools in spreadsheets for
quickly summarizing, analyzing, and reorganizing data.


2. Which formula is used to calculate the total sum of a range of
cells in Excel?
A. =AVERAGE()
B. =SUM()
C. =IF()
D. =INDEX()
ANS: B. =SUM()
Rationale: The `SUM()` function adds up all numerical
values in the specified range.


3. What does the VLOOKUP function primarily accomplish?
A. It retrieves values based on a horizontal lookup.
B. It retrieves values based on a vertical lookup.
C. It counts specific text in a range.
D. It applies conditional formatting to a range.
ANS: B. It retrieves values based on a vertical lookup.
Rationale: The `VLOOKUP` function searches for a value in
the first column of a table and returns a value in the same row
from another column.
©2025

, ---


Fill-in-the-Blank Questions


4. The function _______ is used to identify the largest number in
a given range of cells.
ANS: MAX()
Rationale: The `MAX()` function returns the highest
numerical value in a specified range.


5. The formula _______ combines text from multiple cells into
one cell in Excel.
ANS: CONCATENATE()
Rationale: The `CONCATENATE()` function (or
`CONCAT()` in later versions) merges text from multiple cells.


---


True/False Questions



©2025