Question 1

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

Accepted Answer

The Format Chart Area pane can be used t

Question 2

The chart area in Excel 2013:

Accepted Answer

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. 
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.

Question 3

Match between columns
                        Premises: Chart area
Y-axis
Category axis
X-axis
Plot Area

Accepted Answer

The Answer of provides descriptive group names for subdividing a is...

Question 4

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

Accepted Answer

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

Question 5

Match between columns
                        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

Accepted Answer

The Answer of Pie chart and Bar chart and Line is...

Question 6

Match between columns
                        Premises: Gridline
Data label
Axis title
Trendline
Chart title

Accepted Answer

The Answer of label that describes either the category axis is...

Question 7

Which of the following describes a line chart?

Accepted Answer

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. 
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.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of ________ are small white-filled squares that display...

Question 10

A bar chart:

Accepted Answer

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. 
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.

Question 11

A chart is:

Accepted Answer

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. 
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.

Question 12

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

Accepted Answer

The answer of A chart ________ is the label that...

Question 13

The Chart Styles button is:

Accepted Answer

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. 
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.

Question 14

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?

Accepted Answer

When you want to show a relationship bet

Question 15

Pie charts often include percentage data labels.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Match between columns
                        Premises: Data point
Column chart
Category label
Chart
Data series

Accepted Answer

The Answer of group of related data points and numeric is...

Exam 20: Excel : Charts: Depicting Data Visually

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

The chart area in Excel 2013:

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

Which of the following describes a line chart?

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

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

A bar chart:

A chart is:

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

The Chart Styles button is:

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?

Pie charts often include percentage data labels.

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

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

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

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

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

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

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

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

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel: Datasets and Tables: Managing Large Volumes of Data

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

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

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

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

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

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

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

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

Access: Advanced Forms and Reports: Moving Beyond the Basics

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

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

Filters