A 100% stacked column chart is similar to what other chart in that it converts values to
percentages?
A) Clustered column
B) Radar
C) Line
D) Pie correct answers D
Which chart type is not listed in the All Charts window?
A) Treemap
B) Sparkline
C) Histogram
D) Waterfall correct answers B
Which chart type displays the data horizontally?
A) Pie
B) Radar
C) Bar
D) Column correct answers C
Which chart element cannot be chosen from the Chart Elements dialog box?
A) Axis Titles
B) Chart Title
C) Format Back Wall
D) Error Bars
Answer: C correct answers C
, Which chart type is a visual "dashboard" of your data?
A) Bar chart
B) Sparkline
C) Line chart
D) Column chart correct answers B
Which of the following is not a characteristic of a table?
A) Can contain multiple ranges
B) Helps to manage information
C) Helps to analyze information
D) Contains related data correct answers A
What is true about adding a new field to the right side of an existing data table?
A) You must convert the table back to a range, add the field, then recreate the table.
B) You can add it to the right of the data table and Excel will extend the table to include the new
field.
C) You cannot add a new field to an existing data table.
D) You must insert the new field somewhere inside the existing table, then move the columns to
the order you desire. correct answers B
By default, what is the first table on a worksheet named?
A) Table 1
B) Table A
C) Table
D) Data tables do not have names. correct answers A
Where does Excel display the Total row in a table?
A) At the top of the table