Filters
Question type
Study Flashcards

A bar chart:


A) uses a line to connect data points in order to show trends over a period of time.
B) compares values across categories using horizontal bars.
C) shows each data point in proportion to the whole data series as a slice in a circular pie.
D) separates one or more pie slices from the rest of the pie chart.

E) All of the above
F) B) and D)

Correct Answer

verifed

verified

Match the chart elements to their meanings:

Premises
Chart area
Y-axis
Category axis
X-axis
Plot Area
Responses
provides descriptive group names for subdividing a data series
vertical line that borders the plot area to provide a frame of reference
contains a graphical representation of values in a data series
contains an entire chart and all of its elements
horizontal line that borders the plot area to provide a frame of reference

Correct Answer

Chart area
Y-axis
Category axis
X-axis
Plot Area

________ are small white-filled squares that display when a chart is selected.

Correct Answer

verifed

verified

Excel includes the placeholder text Chart Title below a chart when you create the chart.

A) True
B) False

Correct Answer

verifed

verified

Which of the following describes a line chart?


A) A line chart separates one or more pie slices from the rest of the pie chart.
B) A line chart shows each data point in proportion to the whole data series as a slice in a circular pie.
C) A line chart emphasizes magnitude of changes over time by filling in the space between lines with a color.
D) A line chart uses a line to connect data points in order to show trends over a period of time.

E) C) and D)
F) B) and C)

Correct Answer

verifed

verified

A column sparkline could compare averages of prices or averages of test scores.

A) True
B) False

Correct Answer

verifed

verified

Displaying too much label content in a chart can clutter the chart.

A) True
B) False

Correct Answer

verifed

verified

Match the following terms to their meanings:

Premises
Data point
Column chart
Category label
Chart
Data series
Responses
group of related data points
numeric value that describes a single value on a chart
displays data comparisons vertically in columns
text that describes a collection of data points in a chart
visual representation of numerical data

Correct Answer

Data point
Column chart
Category label
Chart
Data series

When might you want to create an X Y (scatter)chart? What type of data might be best suited for a this type of chart?

Correct Answer

verifed

verified

When you want to show a relationship bet...

View Answer

Match the following terms to their meanings:

Premises
Gridline
Data label
Axis title
Trendline
Chart title
Responses
label that describes either the category axis or the value axis
line used to depict trends and forecast future data
label that describes a chart
value or name of a data point
line that extends from the horizontal or vertical axis through the plot area

Correct Answer

Gridline
Data label
Axis title
Trendline
Chart title

A chart is:


A) a group of related data points in an Excel window.
B) a visual depiction of numerical data.
C) a set of numeric values shown on a worksheet.
D) text that describes a group of data points.

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

The chart area in Excel 2013:


A) is always a fill of a picture or a texture.
B) contains the entire chart and all of its elements.
C) is a vertical line that borders the plot area to provide a frame of reference for measurement.
D) is a horizontal line that borders the plot area to provide a frame of reference for measurement.

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

Pie charts often include percentage data labels.

A) True
B) False

Correct Answer

verifed

verified

The Chart Styles button is:


A) located on the right side of a chart.
B) located on the left side of a chart.
C) is accessed from the Insert tab.
D) on the Format tab.

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

A(n) ________ is a key that identifies the color,gradient,picture,texture,or pattern of each data series in a chart.


A) label
B) trendline
C) legend
D) axis

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

A chart ________ is the label that describes the entire chart;it should reflect the purpose of the chart.

Correct Answer

verifed

verified

A bar chart is one of the most common types of charts used in Excel.

A) True
B) False

Correct Answer

verifed

verified

Describe the three Format task panes that allows you to format with fill and border elements of a chart.

Correct Answer

verifed

verified

The Format Chart Area pane can be used t...

View Answer

Match the following descriptions to their type of chart:

Premises
relationship of individual data points to the whole
multiple data series
each data series in different line color
compares groups set side by side
single data series
Responses
Pie chart
Bar chart
Line chart
Stacked column chart
Clustered column chart

Correct Answer

relationship of individual data points to the whole
multiple data series
each data series in different line color
compares groups set side by side
single data series

When you create a pie chart,Excel does not create a legend.

A) True
B) False

Correct Answer

verifed

verified

Showing 61 - 80 of 100

Related Exams

Exam 1

Office Fundamentals and File Management

100 Questions

Exam 3

Word: Document Presentation: Editing and Formatting

100 Questions

Exam 4

Word: Document Productivity: Working With Tables and Mail Merge

100 Questions

Exam 5

Word: Collaboration and Research: Communicating and Producing Professional Papers

100 Questions

Exam 6

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

100 Questions

Exam 7

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

100 Questions

Exam 8

Word: Document Automation: Forms,macros,and Security

100 Questions

Exam 9

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

104 Questions

Exam 10

Power: Introduction to Powerpoint: Creating a Basic Presentation

108 Questions

Exam 11

Power: Presentation Development: Planning and Preparing a Presentation

111 Questions

Exam 12

Power: Presentation Design: Illustrations and Infographics

102 Questions

Exam 13

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

100 Questions

Exam 14

Power: Infographics: Creating Text Charts, tables, and Graphs

100 Questions

Exam 15

Power: Interactivity and Advanced Animation: Engaging the Audience

100 Questions

Exam 16

Power: Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 17

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

100 Questions

Exam 18

Excel: Introduction to Excel: What Is a Spreadsheet

100 Questions

Exam 19

Excel: Formulas and Functions: Performing Quantitative Analysis

100 Questions

Exam 21

Excel: Datasets and Tables: Managing Large Volumes of Data

100 Questions

Exam 22

Excel: Subtotals, Pivot-tables, and Pivot-charts

103 Questions

Exam 23

Excel : What-If Analysis

103 Questions

Exam 24

Excel: Specialized Functions

103 Questions

Exam 25

Excel: Statistical Functions

103 Questions

Exam 26

Excel : Multiple-Sheet Workbook Management

103 Questions

Exam 27

Excel: Imports, web Queries, and Xml

103 Questions

Exam 28

Excel : Collaboration and Workbook Distribution

108 Questions

Exam 29

Excel: Templates, styles, and Macros

103 Questions

Exam 30

Access : Introduction to Access: Finding Your Way Through an Access Database

100 Questions

Exam 31

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

100 Questions

Exam 32

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

100 Questions

Exam 33

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

100 Questions

Exam 34

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

100 Questions

Exam 35

Access : Action and Specialized Queries: Moving Beyond the Select Query

100 Questions

Exam 36

Access: Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 37

Access: Get Connected: Exchanging Data Between Access and Other Applications

100 Questions

Exam 38

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

100 Questions

Show Answer