CSC Chapter 3 & 4 Questions and Answers
1) What should you not select when selecting data for a chart?
Worksheet titles
2) Which axis in a chart displays the descriptive labels for the data points?
Category
Previous
Play
Next
Rewind 10 seconds
Move forward 10 seconds
Unmute
...
CSC Chapter 3 & 4 Questions and
Answers
1) What should you not select when selecting data for a chart? - answer Worksheet
titles
2) Which axis in a chart displays the descriptive labels for the data points? - answer
Category
3) Which of the following is not a chart element? - answer Data area
4) What is not true about an effective chart? - answer It always contains more than
one series.
5) What is not a purpose of using an effective chart? - answer Reveals even subtle
errors in formulas
6) Which of the following, when included, distorts the effectiveness of charting data
points? - answer Aggregates
7) Which axis in a chart displays incremental numbers for the data points? - answer
Value
8) Which of the following is not a chart type? - answer Circle
9) A 100% stacked column chart is similar to which other chart in that it converts values
to percentages? - answer Pie
10) Which of the following is not true about trendlines?
A) They help forecast future data.
B) They can be added to all chart types.
C) The line indicates possible future values.
D) They are added to existing charts. - answer Answer: B
11) Which of the following is not true about sizing handles?
A) They appear as circles.
B) There are 8 of them for any object.
C) They allow you to make objects larger or smaller.
D) They always maintain the proper aspect ratio for the object. - answer Answer: D
12) What is a disadvantage of a stacked column chart?
A) Segments do not start at the same point.
B) Segments do not end at the same point.
,C) There is a limit as to how many segments can be displayed.
D) This is only useful for one data series. - answer Answer: A
13) Which chart type is not listed in the All Charts window?
A) Treemap
B) Sparkline
C) Histogram
D) Waterfall - answer Answer: B
14) Which axis displays descriptive labels for the data points in a chart?
A) category axis
B) value axis
C) z-axis
D) y-axis - answer Answer: A
15) Which axis displays incremental numbers to identify the approximate values of data
points? - answer value axis
16) Which chart type is best when you want to chart two unrelated data types? - answer
Combo chart
17) What chart type represents data as spokes going from the center to the outer edge
of the chart? - answer Radar
18) As a general rule, Pie charts should be limited to how many slices? - answer 7
19) Where does the primary axis display on a Combo chart? - answer Left side
20) What chart type can display two different chart types at the same time? - answer
Combo
21) In a bar chart, which axis displays the categories? - answer Vertical
22) Which chart type displays the data vertically? - answer Column
23) Which chart type displays the data horizontally? - answer Bar
24) How many sizing handles are found on embedded charts? - answer 8
25) Which of the following is not a chart element?
A) Chart foreground
B) Chart title
C) Axis title
D) Gridlines - answer Answer: A
26) The plot area is surrounded by how many axes?
, A) 1
B) 2
C) 3
D) It depends on the chart type selected. - answer Answer: B
27) In the task pane, what does a diagonal black triangle next to a chart category
indicate? - answer All the category's options are displayed.
28) Which chart element cannot be chosen from the Chart Elements dialog box? -
answer Format Back Wall
29) What does Excel not determine about the value axis when you create a chart? -
answer Average value
30) What is not found on the Chart Elements List? - answer Chart Type
31) In a pie chart which of the following is a good reason for using category data labels
rather than the legend? - answer They are easier to read.
32) In the task pane, what does a diagonal white triangle next to a chart category
indicate? - answer None of the category's options are displayed.
33) What icon is not displayed when you select a chart? - answer Chart Types
34) What can you not do from the Select Data Source dialog box? - answer Change
chart type
35) Which chart type is a visual "dashboard" of your data? - answer Sparkline
36) Which chart type cannot be displayed as a sparkline? - answer Bar chart
37) A parallel range is one that consists of the same starting point of another range, but
can have a different end point. - answer FALSE
38) As long as you pick the correct chart you can mix numeric value systems, such as
dollars and number of units sold. - answer FALSE
39) In rare cases you can chart text entries. - answer FALSE
40) Including the column and row labels in a chart makes the chart harder to
understand. - answer FALSE
41) It is good practice to delete any blank rows or columns before creating a chart. -
answer TRUE
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Pogba119. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £10.62. You're not tied to anything after your purchase.
