WGU C268 STUDY GUIDE FOR EXCEL PA
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.
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.
