Computer applications

Line, column, bar, and pie charts each have a _____ subtype.

3-d

To add depth to a column chart, create a _____ column chart.

3-d

The angle settings of a 3-D column chart can be changed for the X and Y axes in the _____ settings.

3-d rotation

The depth of the base of a 3-D column chart can be changed in the _____ settings.

3-d rotation

The Bar of Pie chart subtype displays a secondary _____ chart to emphasize certain values.

bar

Which type of chart is used to compare data using horizontal representations of data?

bar

_____ are preset layouts for charts that determine the positioning of chart items.

chart layouts

_____ are preset color formatting for chart objects.

chart styles

There are several methods to display data visually in Excel. Which method allows you to fill an entire sheet with a visual representation of data?

charts

_____ in the Excel program are(is) used to visually display data.

charts

Which one is not a common chart type?

circle

Use the _____ to delete a sparkline from a cell.

clear tool

Which of the following is not an example of an illustration that can be inserted in an Excel worksheet?

clip mart

In the Custom tab of the More Fill Colors options, drag the _____ up or down to lighten or darken the selected color.

color slider triangle

Which type of chart is used to compare data using vertical representations of data?

column

When preparing data to be charted, there should be no blank _____ in the data.

columns

To size a picture or a clip art and keep it in proportion, size it from the _____.

corner

A _____ is one item in a data series, such as one column, bar, or slice of pie.

data point

A data series in a chart is the series of numbers from a row or column of charted data. A _____ represents one of the numbers.

data point

One column in a column chart is referred to as a _____.

data point

A _____ is the set of numbers from one column or row of data that is charted.

data series

The Chart Layouts and Chart Styles groups are found on the _____ tab when a chart is selected.

design

When a sparkline is selected, the _____ tab appears on the ribbon that displays tools for formatting the sparklines.

design

The mouse pointer to size pictures is shaped as a _____.

double arrow

The shortcut to quickly format a chart element is to _____ on the element.

double-click

Sparklines can be copied down a column by using the _____.

fill handle

Double-clicking on a number in the vertical axis opens the _____ dialog box.

format axis

The mouse pointer to move pictures is shaped as a _____.

four-headed arrow

Which is not an option with the Shape Effects tools?

halo

To change how empty cells are charted in a sparkline, use the _____ command.

hidden and empty cells

_____ are graphics you can insert in a worksheet or chart.

illustrations

The illustration tools are found in the Illustrations group. On what tab on the ribbon is the Illustrations group found?

insert

Which tab of the ribbon are the charting tools found on?

insert

To change the Label commands, such as the Chart Title, Axis Titles, and Data Labels, click on the _____ tab on the ribbon.

layout

Which type of chart is used to chart progress over time?

line

Use the _____ tool to change the color of markers.

marker color

Check the _____ checkbox in the Show group to highlight each data point in a sparkline.

markers

To remove the shape outline, choose the _____ option.

no outline

To visually represent data without creating a separate chart, insert _____ in cells.

not minicharts

A data point on a pie chart can be emphasized by _____ the slice of the pie.

not rotating

Setting the Data Labels to Outside End on a pie chart displays the _____ of each slice of the pie.

not size

When a column in a column chart is first filled with a picture, the fill option is set to _____.

not stack and scale

If you want the background of a shape to be see-through, so it doesn't obstruct the view of items behind it, change the Shape Fill setting to _____.

not transparent fill

How many data series can be charted on a pie chart?

one

To fill columns in a chart with clip art, use the _____ fill option.

picture or texture

The Pie of Pie chart subtype displays a secondary _____ chart to emphasize certain values.

pie

Which is not a type of sparkline?

pie

Which type of chart compares the parts to the whole?

pie

Which is not a marker option that can be turned off and on from the Show group?

positive points

Charts are often used in presentation programs, such as Microsoft _____.

powerpoint

To quickly delete an illustration, select the illustration and _____.

press the delete key on your keyboard

Charts are often used in _____ to quickly represent data and help the readers understand the data.

reports

To quickly open the Format Shape dialog box, _____ on a shape, and choose Format Shape.

right-click

When preparing data to be charted, there should be no blank _____ in the data.

rows

The _____ tool can be used to set the background of a picture to see-through.

set transparent color

To change the background color of shapes, use the _____ tool.

shape fill

The _____ tools set the formats of the border around a shape.

shape outline tools

Preset shape formatting can be quickly added to shapes using the _____.

shape quick styles

When a shape is selected, the Format tab contains the _____ group, which contains tools to change the format of shapes.

shape styles

When sizing a shape, to keep it in proportion, you must press and hold the _____ key while dragging from a corner of the shape.

shift

Preset formatting for sparklines are called _____.

sparkline styles

_____ are minicharts that display in cells.

sparklines

When the fill option is set to _____ in a column of a column chart, the picture keeps its original shape.

stack

When the fill option is set to _____ in a column of a column chart, the picture is repeated, displaying one picture for each unit of numerical value of the data point.

stack and scale

When creating charts, there are many chart _____ to choose from.

subtypes

Which is not an option for filling a shape?

swirls

A _____ shape is used to place text anywhere in a worksheet or chart.

textbox

Shapes are objects of different shapes that can be drawn in a worksheet or chart. Which shape is used to place text anywhere in a worksheet or chart?

textbox

The shape outline weight setting determines the _____ of the line around a shape.

thickness

Many businesses rely on _____ to help make decisions for the future.

trends

Illustrations must be inserted in a worksheet, not opened from the File tab.

true

When setting up data to be charted, it's best to have no blank rows or columns in the data.

true

The usual setting for the number in the _____ setting in the fill picture or texture option is the same as the step of the numbers in the Y-axis.

unit/picture

The columns in a column chart can be filled with different options. Which one of the following is not a fill option for a column?

video

To select an individual data point on a chart, click on the point, _____, and then click again.

wait

What two elements does a 3-D column chart contain that a regular column chart does not?

walls and floor