(WGU D388) BUS 2250 Spreadsheets & Data Presentations - OA Review .

D388 BUS 2250



Spreadsheets & Data Presentations




OA REVIEW 1




© 2024/2025

,1. Which of the following spreadsheet functions can be used to
find the average of a set of numbers?
a) MAX
b) AVERAGE
c) COUNT
d) SUM
Correct Answer: b) AVERAGE
Rationale: The AVERAGE function calculates the mean of a
series of values.


2. What does the VLOOKUP function do in a spreadsheet?
a) Looks up a value in a column and returns a corresponding
value from another column
b) Validates the existing data in a cell
c) Creates vertical graphs
d) Adds up all the values in a range
Correct Answer: a) Looks up a value in a column and
returns a corresponding value from another column
Rationale: VLOOKUP searches for a value in the leftmost
column of a table and returns a value in the same row from a
specified column.
© 2024/2025

, 3. Which of the following is a valid cell reference in Excel?
a) A1
b) $A$1
c) A$1
d) All of the above
Correct Answer: d) All of the above
Rationale: All listed options represent valid cell references,
with different types of referencing (relative and absolute).


4. If cell A1 contains the formula =B1+C1, what happens when
you drag this cell down to A2?
a) The formula remains =B1+C1
b) The formula changes to =B2+C2
c) The formula changes to =B1+C2
d) An error appears
Correct Answer: b) The formula changes to =B2+C2
Rationale: This behavior illustrates Excel's relative referencing,
where dragged formulas adjust based on their new positions.


5. Which chart type is most suitable for showing trends over
time?
© 2024/2025