Microsoft Office 2013 Ch. 7 Review

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

What chart type shows trends of values over time

Area chart

T/F A chart pasted as a picture will automatically change if the source worksheet changes.

False

T/F All bar charts created in Excel have vertical bars

False

T/F All charts contain the same objects.

False

T/F Column, bar, and line are the only types of charts that can be created in Excel.

False

T/F Pie charts data labels must be displayed as percentages.

False

T/F The category axis is vertical

False

In Excel, a vertical bar chart is called what

Column chart

T/F A bar chart can only include one series of data.

False

A visual representation of worksheet data is called what

A chart

A chart is moved by dragging what

A chart border

A chart is sized proportionally by dragging what

A corner handle

What type of chart is best for comparing the differences between values

Bar

What type of chart would best illustrate a comparison of the number of employees in each department of a store

Bar

What chart object identifies each value in a data seies

Data labels

What is the portion of the worksheet to be charted called

Data range

The chart title does what

Describes what is charted

T/F Pie charts have axes.

Fase

In Excel, bar charts can have what to types of bars

Horizontal and vertical

What type of chart is best for displaying the differences of data over time

Line

What type of chart would best illustrate price fluctuations over a period of time for three stocks

Line

What is printed if a chart that appears as an object in a worksheet is selected before printing

Only the chart on a single sheet of paper in landscape orientation

What paste options command is selected to paste a chart as a graphic in a word document

Paste as a picture

In what kind of chart is each value from the series represented as a slice

Pie

What is not a type of sparkline

Pie

What type of chart is best for charting data that is a percentage of a whole

Pie

What type of chart would best illustrate each department's sales as a percentage of the overall store sales

Pie

What chart object is the part of the chart that displays data

Plot Area

A selected chart is deleted by doing what

Pressing the Delete key

What chart type shows changes in values relative to a center point

Radar chart

What is the first step in creating a pie chart

Select the data to be charted

The entire chart and all of its elements is referred to as what

The chart area

T/F A chart can be placed on a separate sheet in a workbook.

True

T/F A chart illustrates the relationship between data.

True

T/F A chart simplifies the understanding of numerical data.

True

T/F A pie chart only includes only one series of data.

True

T/F An adjacent data series is added to a selected chart by dragging a handle of the outlined original data series.

True

T/F Chart layout is the placement of objects on a chart.

True

T/F Charts created in excel can be copied to a Word document.

True

T/F Each Excel chart type has several subtypes

True

T/F The data range of a chart can include non-adjacent cells.

True

What chart type compares pairs of values

XY chart


Set pelajaran terkait

Community Exam 1, Community Health Exam 2, Communities Final

View Set

Development and globalisation:What is globalisation and causes

View Set

PSYCHIATRIC MENTAL HEALTH (VIDEBACK) CHAPTER 24 COGNITIVE DISORDERS

View Set

Chapter 3 Your Professional Image

View Set