WGU C268 SPREADSHEETS
COMPREHENSIVE EXAM STUDY GUIDE
COMPLETE QUESTIONS AND SOLUTIONS
●● Absolute Reference
Answer: A cell reference that stays fixed when a formula is copied from
one cell to another.
●● Accounting
Answer: An option in the Number Format drop-down menu that defines
a number as money with the appropriate monetary symbol and two
decimal places. The user does not have as many ways to format negative
numbers as the Currency option.
●● Algorithm
Answer: The part of a calculation that is applied to the measure.
Example: average revenue.
●● Alignment
Answer: The way values in a cell are positioned.
●● Area Chart
, Answer: A type of chart that combines a line chart and a bar chart to
show changes in quantities over time. Area charts display the height of
each category in relation to the height of the other categories.
●● Argument
Answer: The information that a function requires to perform the
intended calculation.
●● Average
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
●● Bar Chart
Answer: A type of chart that presents data with horizontal bars.
●● Bold
Answer: A feature in the Font group that thickens and darkens the font
face, making it stand out.
●● Borders
Answer: An icon in the Font group of the Home menu that, when
selected, gives multiple options to add lines, or "borders," to one or more
sides of a cell.
COMPREHENSIVE EXAM STUDY GUIDE
COMPLETE QUESTIONS AND SOLUTIONS
●● Absolute Reference
Answer: A cell reference that stays fixed when a formula is copied from
one cell to another.
●● Accounting
Answer: An option in the Number Format drop-down menu that defines
a number as money with the appropriate monetary symbol and two
decimal places. The user does not have as many ways to format negative
numbers as the Currency option.
●● Algorithm
Answer: The part of a calculation that is applied to the measure.
Example: average revenue.
●● Alignment
Answer: The way values in a cell are positioned.
●● Area Chart
, Answer: A type of chart that combines a line chart and a bar chart to
show changes in quantities over time. Area charts display the height of
each category in relation to the height of the other categories.
●● Argument
Answer: The information that a function requires to perform the
intended calculation.
●● Average
Answer: A function or PivotTable Value Field setting that displays the
average of the values.
●● Bar Chart
Answer: A type of chart that presents data with horizontal bars.
●● Bold
Answer: A feature in the Font group that thickens and darkens the font
face, making it stand out.
●● Borders
Answer: An icon in the Font group of the Home menu that, when
selected, gives multiple options to add lines, or "borders," to one or more
sides of a cell.
