Question 1

The lines that go across charts to help gauge the size of the bars,columns,and data lines are known as ________.
A) data bars
B) sparklines
C) gridlines
D) trendlines

Accepted Answer

Gridlines are the lines that are used as a reference in a chart to help the viewer estimate the value of a data point. They form a grid-like pattern and help to visually organize the chart. Data bars are a type of chart that displays data in the form of horizontal or vertical bars. Sparklines are small, data-dense graphics that are often used in tables, and trendlines are used to show the trend of the data over time.

Question 2

Which of the following chart types compares groups of data in a horizontal fashion?
A) column
B) bar
C) pie
D) line

Accepted Answer

Bar charts are ideal for comparing groups of data in a horizontal fashion. They display the data using rectangular bars of equal width, with the height or length of each bar representing the value of the corresponding data.

Question 3

Which of the following chart types does NOT display data in a standard X-Y plane?
A) bar
B) column
C) line
D) pie

Accepted Answer

Pie charts do not display data in a standard X-Y plane. Instead, they show different parts of a whole and how they relate to each other. Bar, column, and line charts all use an X-Y plane to display data.

Question 4

Which of the following chart types is most similar to a bar chart in terms of function?
A) column
B) pie
C) line
D) scatter

Accepted Answer

A column chart is the most similar to a bar chart in terms of function. Both chart types display categorical data and measure their values using a length or height measure. The only difference is that the bars in a bar chart are horizontal while the columns in a column chart are vertical. Pie charts display the proportion of the whole while line and scatter charts show trends and relationships between variables.

Question 5

Which of the following chart types would best help convey data that changes over a period of time?
A) pie
B) column
C) bar
D) line

Accepted Answer

Line charts are best suited for showing trends and changes over time. They can easily display the ups and downs in data, making them a popular choice for tracking financial data, stock market trends, or weather patterns. Pie charts are not suitable because they are meant to display proportions or percentages, while column and bar charts are better for comparing different values at one point in time.

Question 6

Which of the following charts could best depict the relationship between two variables?
A) column
B) pie
C) scatter
D) bar

Accepted Answer

A scatter plot is the best choice for depicting the relationship between two variables as it shows how one variable changes in relation to another. It is often used to identify patterns or trends in data and to determine if there is a correlation between the variables. The other chart types listed (column, pie, and bar) are better suited for showing information such as proportions or comparisons between different categories, rather than relationships between variables.

Question 7

If a chart is placed inside of an existing worksheet,it is said to be a chart sheet.

Accepted Answer

If a chart is placed inside an existing worksheet, it is referred to as an embedded chart. A chart sheet is a separate sheet in a workbook that only contains a chart.

Question 8

Which of the following chart types are most similar in function?
A) line and pie
B) bar and column
C) column and scatter
D) pie and bar

Accepted Answer

Bar and column charts are both used for comparing data points in a category or across categories. They are similar in function as they both use rectangular bars to represent data values and are suitable for  graphical representation of quantitative data. Line charts are used to represent trends over time or continuous data variables, while pie charts are used to represent parts of a whole. Scatter plots are used to identify relationships between variables on a continuous axis. Therefore, the most similar chart types in function are bar and column charts, making option B the best choice.

Question 9

Which of the following chart types would NOT be useful for displaying multiple categories of data on the same chart?
A) line
B) column
C) pie
D) bar

Accepted Answer

Pie charts are best used for displaying proportions or percentages of a single category or data series. They are not ideal for displaying multiple categories of data on the same chart. Line, column, and bar charts can all display multiple categories of data in a clear and concise manner.

Question 10

Charts must be placed in an existing worksheet.

Accepted Answer

Charts can be placed in an existing worksheet, but they can also be placed in a new sheet specifically dedicated to the chart, known as a chart sheet, in Excel and similar spreadsheet software.

Question 11

Which of the following chart types would be used to compare parts of a whole?
A) bar
B) column
C) line
D) pie

Accepted Answer

A pie chart is best used to compare parts of a whole by visually representing each part as a slice of the whole pie. The size of each slice is proportional to the percentage of the whole that it represents, making it easy to compare and contrast the different parts. Bar charts and column charts, on the other hand, are used to compare different categories or values along an axis, while line charts are used to show trends over time.

Question 12

Which of the following statements regarding data series is FALSE?
A) A data series is made up of data points.
B) A chart can be made up of only one data series.
C) A data series is a range that will be charted.
D) A chart can be made up of multiple data series.

Accepted Answer

A chart can consist of multiple data series, so statement D is true. A data series can be a range of values or a set of individual data points, so statement C is also true. Statement A is also true because a data series is composed of data points. However, statement B is false because a chart can consist of multiple data series, not just one.

Question 13

A data point is made up of one or more data series.

Accepted Answer

A data series is made up of multiple data points, not the other way around.

Question 14

Which of the following chart types are most similar in function?
A) area and pie
B) area and line
C) column and scatter
D) scatter and pie

Accepted Answer

Area and line charts are most similar in function as they both display trends over time or numerical values on an axis. Both charts can show changes in data and are useful for comparing multiple data series.

Choice A (area and pie) and Choice D (scatter and pie) are not similar in function as pie charts display data as a portion of a whole, while area and scatter charts show numerical values.

Choice C (column and scatter) also have different functions as column charts show comparisons between categories, while scatter charts show the relationship between two variables.

Question 15

Small charts embedded into a spreadsheet,usually next to the data,that facilitate quick analysis of trends are known as ________.
A) gridlines
B) trendlines
C) data bars
D) sparklines

Accepted Answer

Small charts embedded into a spreadsheet, usually next to the data that facilitate quick analysis of trends are known as sparklines. Gridlines are the lines on a spreadsheet that separate cells from each other. Trendlines are used in graphs to visualize trends in data. Data bars are graphical representations of data in which the length of the bar indicates the value.

Question 16

Which of the following charts could be used to easily group and compare categorized data sets?
A) pie
B) area
C) column
D) line

Accepted Answer

Column charts are the best choice for grouping and comparing categorized data sets as they display data in columns which can be easily compared side by side.

Question 17

If individual cells are filled in with colors,they have had ________ added to them.
A) trendlines
B) sparklines
C) data bars
D) gridlines

Accepted Answer

Data bars are used to visually represent the values in cells using colored bars. Trendlines are used in charts to highlight patterns or trends, sparklines are small charts that fit within a cell to show trends, and gridlines are used to visually separate cells in a grid-like format. Therefore, the best choice is C, data bars.

Question 18

Lines added to a chart that use current data to show the general direction of the data are referred to as ________.
A) trendlines
B) sparklines
C) data bars
D) gridlines

Accepted Answer

Trendlines help to show the general direction of the data and are added to a chart using current data. Sparklines are a separate type of small chart that is embedded within a cell, data bars represent the data in a chart using color gradients, and gridlines are the horizontal and vertical lines that define the borders of the chart area.

Question 19

Which of the following could be used to easily group and compare categorized data sets?
A) bar
B) line
C) area
D) scatter

Accepted Answer

Bar charts are particularly effective for comparing and visualizing categorized data sets because they allow for easy comparison of different categories or groups by representing them with bars of varying lengths.

Question 20

Which of the following chart types would display a series in a circular fashion?
A) bar
B) pie
C) column
D) line

Accepted Answer

The pie chart displays data as a series of slices in a circular fashion.

Quiz 12: Microsoft Excel 2010,workshop 4: Using Charts

The lines that go across charts to help gauge the size of the bars,columns,and data lines are known as ________.

Which of the following chart types compares groups of data in a horizontal fashion?

Which of the following chart types does NOT display data in a standard X-Y plane?

Which of the following chart types is most similar to a bar chart in terms of function?

Which of the following chart types would best help convey data that changes over a period of time?

Which of the following charts could best depict the relationship between two variables?

If a chart is placed inside of an existing worksheet,it is said to be a chart sheet.

Which of the following chart types are most similar in function?

Which of the following chart types would NOT be useful for displaying multiple categories of data on the same chart?

Charts must be placed in an existing worksheet.

Which of the following chart types would be used to compare parts of a whole?

Which of the following statements regarding data series is FALSE?

A data point is made up of one or more data series.

Which of the following chart types are most similar in function?

Small charts embedded into a spreadsheet,usually next to the data,that facilitate quick analysis of trends are known as ________.

Which of the following charts could be used to easily group and compare categorized data sets?

If individual cells are filled in with colors,they have had ________ added to them.

Lines added to a chart that use current data to show the general direction of the data are referred to as ________.

Which of the following could be used to easily group and compare categorized data sets?

Which of the following chart types would display a series in a circular fashion?