BUS 311: Excel Ch 3

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

What font color does Excel use by default for many of its elements?

Black, Text 1, Lighter 35%

T/F: A chart sheet can hold, at most, two charts.

False

T/F: A chart style effects the formatting of the chart itself, but not the chart data.

False

T/F: A parallel range is one that consists of the same starting point of another range, but can have a different end point.

False

T/F: A stacked column chart displays multiple columns for each category.

False

T/F: As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

False

T/F: In a rare cases you can chart text entries.

False

T/F: Including the column and row labels in a chart makes the chart harder to understand.

False

T/F: Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

False

T/F: The range used for a sparkling cannot include more than one row.

False

T/F: To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

False

T/F: To understand a chart you need to include the chart data.

False

T/F: When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

False

T/F: Effective charts never overwhelm an audience.

True

T/F: Even after selecting a data source for a chart you can still apply various filters on one or more series.

True

T/F: Excel normally uses all the selected data in creating a chart.

True

T/F: It is good practice to delete any blank rows or columns before creating a chart.

True

T/F: It is important to select parallel ranges.

True

T/F: Pie charts can only display one data series.

True

T/F: Sparklines do not include the normal chart labels.

True

T/F: The Chart Styles gallery displays style options for the selected chart only.

True

T/F: When you want to chart two related types of data, the Combo chart is perfect.

True

T/F: You can link to a cell as the title of a chart.

True

T/F: You can switch the rows and columns in a chart to communicate a different perspective on your data.

True

T/F: You can't enter data or formulas on a chart sheet.

True

T/F: You might want to avoid using 3D charts because they can distort the appearance of the data.

True

The ___ axis helps measure data from left to right in a graph.

X

The __ axis helps measure data from top to bottom in a chart.

Y

The __ axis is the vertical axis.

Y

Data table

a grid used to plot data in a chart

Data series

a group of data points

Data point

a precise value in a chart

task pane

a window of options

In a stacked column chart the data must be ___.

additive

3D chart

adds an additional dimension to your chart

Do not use data ___ and individual values in a chart.

aggregates

including what, distorts the effectiveness of charting data points?

aggregates

In the task pane, what does a diagonal black triangle next to a chart category indicate?

all the category's options are displayed

accessibility compliance

applying features to make it easier on disabled users

What does Excel not determine about the value axis when you create a chart?

average value

What chart type is preferable when the category names are long?

bar

Which chart type displays the data horizontally?

bar

Which chart type can't be displayed as a sparkling?

bar chart

If your chart is intended for presentation, as opposed to printing, you should use a __ background.

black and dark

plot area

both axes form a border for this

Where does Excel display the Quick Analysis tool?

bottom-right corner

alt text

can be read by various devices

In a column chart the horizontal axis displays the ___.

categories

Which axis in a chart displays the descriptive labels for the data points?

category

What can you not do from the select data source dialog box?

change chart type

100% stacked column chart

changes individual data points to percentages

Excel uses ___ to determine what categories are visible in a chart.

chart filters and filters

What is not a chart element?

chart foreground

Sparklines

chart resides in one cell

What icon is not displayed when you select a chart?

chart styles

What is not found on the chart elements list?

chart title

What is not a chart type?

circle

In a ____ column chart data appears as side by side columns.

clustered

area chart

colors are used between the lines

Which chart type displays the data vertically?

column

clustered column chart

columns are set side by side

combo chart

combines two chart types

Which chart type is best when you want to chart two unrelated data types?

combo chart

stacked column chart

compares individual points to the whole category

column chart

compares values across categories

chart sheet

contains no spreadsheet

To select nonadjacent ranges press and hold the __ key while selecting the nonadjacent ranges.

control

Which group on the design tab would you select if you wanted to change the source information in the chart?

data

What is not a chart element?

data area

A Chart Filter Excel uses ___ to indicate which chart categories are displayed in a chart.

data point

A ___ is a cell that contains a value used in a chart.

data point

chart filter

decides what is hidden or displayed in a chart

chart title

describes the entire chart

data lables

easier to read than a legend

sparklines

examples include: line, column, win/loss

What group is not found on the Sparkling Tools Design tab?

format

Which chart element can't be chosen from the Chart elements dialog box?

format back wall

Parallel range

has the same starting and ending point

Legend

helps to distinguish between various data series

Chart filter

helps you to focus on particular data

chart area

holds the entire chart

A bar chart uses __ bars.

horizontal

x-axis

horizontal border

What tab displays the tools for creating charts?

insert

What is not true about an effective chart?

it always contains more than one series

Where does the primary axis display on a combo chart?

left side

The ___ is the visual key to a chart.

legend

If you wanted to show trends over set periods of time, you probably want to use ___ chart.

line

Line chart

line connect data points

What chart type can display 2 different chart types at the same time?

mixed

Arrange

moves an object backward or forward

In the task pane, what does a diagonal white triangle next to a chart category indicate?

none of the category's options are displayed

X Y (scatter) chart

often used in educational, scientific, and medical experiments

Exploded pie chart

one or more pieces are separated from the others

X Y (scatter) chart

one variable is plotted on the horizontal axis and the other on the vertical axis

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

pie

What chart type represents data as spokes going from the center to the outer edge of the chart?

radar

If you are not sure which chart type to pick, it may be helpful to click __ Charts in the Chart group.

recommended

What is not a purpose of using an effective chart?

reveals even subtle errors in formulas

sizing handles

seen as 8 circles

What is a disadvantage of a stacked column chart?

segments do not start at the same point

A data ____ is a group of related data points.

series

A group of data points used in a graph become a data ___.

series

chart style

sets the formatting of the chart

Column charts are the most effective when they have __ or fewer categories.

seven

Data label

shows the precise value of a data point

histogram

similar to a column chart

Area

similar to a line chart

When you want to create a chart you first need to select a data ___.

source

A ___ is a type of chart which fits in one cell.

sparkline

Which chart type is a visual "dashboard" of your data?

sparkline

Which chart type is not listed in the All Charts window?

sparkline

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

sparkline

radar

spokes radiate from the center to the outer edges

A ___ column chart displays the relationship of data points to the whole category.

stacked

Picking a chart __ will allow you to change several formatting elements at the same time.

style

stock chart

subtypes inclue: high-low close, open-high-low-close, volume-high-low-close, and volume-open-high-low-close

Alt text

text based interpretation

chart font color

the default is black, text 1, lighter 35%

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

they are easier to read

Chart element

this helps make a chart clearer

In the insert chart dialog box, after you pick a chart type where are the subtypes listed?

top right

triangle with white fill

use to show that all chart category options are not visible

combo chart

used for 2 different but related data types

diagonal black triangles

used to show that all chart category options are visible

surface chart

uses 2 dimensions and a continuous curve

legend

uses color or patterns to identify each data series

Bar charts

uses horizontal bars

Pie chart

uses slices to display the data points

Column chart

uses vertical bars

Which axis in a chart displays incremental numbers for the data points?

value

In a bar chart, which axis displays the categories?

vertical

y-axis

vertical border

What should you not select when selecting data for a chart?

worksheet titles

How many variations of the stock chart does Excel have?

4

As a general rule, pie charts should be limited to how many slices?

7

How many sizing handle are found on embedded charts?

8

____ charts are often used to represent data in educational, scientific, and medical experiments.

Scatter, X Y and XY Scatter

When you point to a chart element Excel displays ___ with the name of the element.

ScreenTip and Screen Tip


Ensembles d'études connexes

Ch. 1 Introduction To Operation Managements

View Set

Street Law Chapter 1 - What Is Law?

View Set

Session 1 - Chapter 4 The Law of Agency Quiz

View Set