IS 160
Spreadsheets
Midterms Exam Review (Qns & Ans)
2025
1. Which function in spreadsheets calculates the total of a range
of values?
A. AVERAGE
B. SUM
C. COUNT
D. CONCATENATE
- ANS: B. SUM
- Rationale: The SUM function adds all values in a specified
range, making it essential for calculations like totals.
©2025
,2. What does the VLOOKUP function primarily do in a
spreadsheet?
A. Counts non-empty cells in a range
B. Sorts data in ascending order
C. Searches for a value in the first column and returns a value in
the same row from a specified column
D. Creates a pivot table
- ANS: C. Searches for a value in the first column and
returns a value in the same row from a specified column
- Rationale: VLOOKUP is commonly used for table lookups,
retrieving data based on a key.
3. Which chart type is most suitable for showing trends over
time in spreadsheet data?
A. Pie Chart
B. Line Chart
C. Bar Chart
D. Scatter Plot
- ANS: B. Line Chart
- Rationale: Line charts visualize data trends over time by
connecting data points with lines.
©2025
, 4. What is the purpose of conditional formatting in spreadsheets?
A. To adjust column width automatically
B. To visually highlight cells based on specific criteria
C. To remove duplicate entries in a range
D. To concatenate cell values
- ANS: B. To visually highlight cells based on specific
criteria
- Rationale: Conditional formatting enhances data readability
by applying visual cues to meet certain conditions.
5. Which advanced feature allows spreadsheet users to
summarize, analyze, and extract significant insights from large
datasets?
A. Macros
B. Pivot Tables
C. Data Validation
D. Filters
- ANS: B. Pivot Tables
- Rationale: Pivot tables allow users to reorganize and
summarize data dynamically for analysis.
---
©2025
Spreadsheets
Midterms Exam Review (Qns & Ans)
2025
1. Which function in spreadsheets calculates the total of a range
of values?
A. AVERAGE
B. SUM
C. COUNT
D. CONCATENATE
- ANS: B. SUM
- Rationale: The SUM function adds all values in a specified
range, making it essential for calculations like totals.
©2025
,2. What does the VLOOKUP function primarily do in a
spreadsheet?
A. Counts non-empty cells in a range
B. Sorts data in ascending order
C. Searches for a value in the first column and returns a value in
the same row from a specified column
D. Creates a pivot table
- ANS: C. Searches for a value in the first column and
returns a value in the same row from a specified column
- Rationale: VLOOKUP is commonly used for table lookups,
retrieving data based on a key.
3. Which chart type is most suitable for showing trends over
time in spreadsheet data?
A. Pie Chart
B. Line Chart
C. Bar Chart
D. Scatter Plot
- ANS: B. Line Chart
- Rationale: Line charts visualize data trends over time by
connecting data points with lines.
©2025
, 4. What is the purpose of conditional formatting in spreadsheets?
A. To adjust column width automatically
B. To visually highlight cells based on specific criteria
C. To remove duplicate entries in a range
D. To concatenate cell values
- ANS: B. To visually highlight cells based on specific
criteria
- Rationale: Conditional formatting enhances data readability
by applying visual cues to meet certain conditions.
5. Which advanced feature allows spreadsheet users to
summarize, analyze, and extract significant insights from large
datasets?
A. Macros
B. Pivot Tables
C. Data Validation
D. Filters
- ANS: B. Pivot Tables
- Rationale: Pivot tables allow users to reorganize and
summarize data dynamically for analysis.
---
©2025
