UNIVERSITY COMPREHENSIVE
EXAMINATION TEST 2026 STUDY
GUIDE QUESTIONS WITH DETAILED
SOLUTIONS
◉ When choosing the chart type, be careful to not accidentally select the
100% stacked column, as this chart type is typically not the appropriate
stacked column chart to use when comparing relative values. Answer:
True
◉ When selecting data to create a Pie chart, to make the chart most
clear, the total column or row within the table should be selected in
addition to the individual sectors. Answer: False
When selecting data for a Pie chart, if you select the "total" along with
rest of the data to be charted, your chart will be incorrect. (It would
include the "total" as one of the pie wedges.)
◉ Adding a lot of illustration and decoration to a chart usually enhances
the view of the data. Answer: False
◉ Using legends to clarify a pie chart's data is preferable to using data
labels. Answer: False
◉ The chart type of _____ compares the contribution each value in
multiple numeric data series makes to the whole as indicated in
segments. Answer: Doughnut
, ◉ The legend is the _____. Answer: box that identifies the colors or
patterns assigned to the data series
◉ It is possible to use a SUM function to SUM values across individual
worksheets. Answer: True
◉ A chart that displays the Volume-Open-High-Low-Close is a Bar
chart. Answer: False
◉ To display pairs of values with data points connected by lines, use a
column chart. Answer: False
◉ The Radar chart _____. Answer: None of the answers listed.
The answers were:
-displays a main pie chart with user-defined values as a stacked bar chart
-displays the trend of values over time or categories relative to a center
point
-displays the contribution of each value to a total with a 3-D visual effect
-compares sets of three values
◉ The 100% Stack Area chart displays the trend of the _____. Answer:
percentage each value contributes over time or categories