Question 1

To print only a chart,select the chart,click the ________ tab,and click Print.

Accepted Answer

File

Question 2

Describe the display of horizontal axis and vertical axis titles on a chart.

Accepted Answer

If you add a horizontal axis title to a chart,it displays below the category labels.If you add a vertical axis titles,it displays as a rotated title on the left side of the value axis.

Question 3

To create a chart in Excel 2013,select the data and click the:

Accepted Answer

A) Chart tab. 
B) Chart Elements button. 
C) Quick Analysis button. 
D) Chart Styles button. 
A) Chart tab. 
B) Chart Elements button. 
C) Quick Analysis button. 
D) Chart Styles button. C

Question 4

A(n)________ chart is a derivative of a scatter chart in which both axes are value axes.

Accepted Answer

The answer of A(n)________ chart is a derivative of a...

Question 5

A data label is:

Accepted Answer

A) a visual representation of numerical data. 
B) the value or name of a data point. 
C) a line used to depict trends and forecast future data. 
D) a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area. 
A) a visual representation of numerical data. 
B) the value or name of a data point. 
C) a line used to depict trends and forecast future data. 
D) a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Question 6

Where does a sparkline display?

Accepted Answer

A) In a single cell 
B) On a separate worksheet from the data 
C) In a range below the data 
D) Always to the right of the data 
A) In a single cell 
B) On a separate worksheet from the data 
C) In a range below the data 
D) Always to the right of the data

Question 7

The purpose of a sparkline is to present a complex chart on a full chart sheet.

Accepted Answer

A) True 
 B)False

Question 8

Default chart sheet names include sheet1,sheet2,etc.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT a task pane in Excel 2013 used to format a chart?

Accepted Answer

A) Format Chart Area 
B) Format Plot Area 
C) Format Data Series 
D) Format Titles and Axes 
A) Format Chart Area 
B) Format Plot Area 
C) Format Data Series 
D) Format Titles and Axes

Question 10

Which of the following is FALSE about sparklines?

Accepted Answer

A) Sparklines do not include an axis label. 
B) Sparklines display in a single cell. 
C) Sparklines include an automatically-created chart title. 
D) Sparklines present a condensed,simple visual illustration of data. 
A) Sparklines do not include an axis label. 
B) Sparklines display in a single cell. 
C) Sparklines include an automatically-created chart title. 
D) Sparklines present a condensed,simple visual illustration of data.

Question 11

A chart sheet:

Accepted Answer

A) is a label that describes the chart. 
B) enables you to adjust the size of a chart. 
C) contains a single chart and no spreadsheet data. 
D) is a miniature chart contained in a single cell. 
A) is a label that describes the chart. 
B) enables you to adjust the size of a chart. 
C) contains a single chart and no spreadsheet data. 
D) is a miniature chart contained in a single cell.

Question 12

A(n)________ label is text that describes a collection of data points in a chart.

Accepted Answer

The answer of A(n)________ label is text that describes a...

Question 13

A default chart sheet is named ________.

Accepted Answer

The answer of A default chart sheet is named ________....

Question 14

A chart filter in Excel 2013:

Accepted Answer

A) controls which charts are printed and which are visible on the screen of a workbook. 
B) controls which data series and categories are visible in a chart. 
C) displays a list of all charts in a workbook in order to select which charts you want to print. 
D) displays all chart types and filters that are available for the data you want to present. 
A) controls which charts are printed and which are visible on the screen of a workbook. 
B) controls which data series and categories are visible in a chart. 
C) displays a list of all charts in a workbook in order to select which charts you want to print. 
D) displays all chart types and filters that are available for the data you want to present.

Question 15

What is a chart sheet and what are its limitations?

Accepted Answer

A chart sheet is a worksheet that contai

Question 16

When you hover the mouse pointer over a chart,Excel 2013 display a(n)________ with the name of that chart element.

Accepted Answer

The answer of When you hover the mouse pointer over...

Question 17

Which of the following is NOT a style that affects the look of a data series?

Accepted Answer

A) Flat 
B) Stacked 
C) 3-D 
D) Beveled 
A) Flat 
B) Stacked 
C) 3-D 
D) Beveled

Question 18

When you update data in a worksheet,you must press F9 to update the data in the associated chart.

Accepted Answer

A) True 
 B)False

Question 19

A(n)________ column chart compares groups of columns set side by side for easy display.

Accepted Answer

The answer of A(n)________ column chart compares groups of columns...

Question 20

A chart filter controls which data series and categories are visible on a chart in Excel.

Accepted Answer

A) True 
 B)False

Exam 20: Excel : Charts: Depicting Data Visually

To print only a chart,select the chart,click the ________ tab,and click Print.

Describe the display of horizontal axis and vertical axis titles on a chart.

To create a chart in Excel 2013,select the data and click the:

A(n)________ chart is a derivative of a scatter chart in which both axes are value axes.

A data label is:

Where does a sparkline display?

The purpose of a sparkline is to present a complex chart on a full chart sheet.

Default chart sheet names include sheet1,sheet2,etc.

Which of the following is NOT a task pane in Excel 2013 used to format a chart?

Which of the following is FALSE about sparklines?

A chart sheet:

A(n)________ label is text that describes a collection of data points in a chart.

A default chart sheet is named ________.

A chart filter in Excel 2013:

What is a chart sheet and what are its limitations?

When you hover the mouse pointer over a chart,Excel 2013 display a(n)________ with the name of that chart element.

Which of the following is NOT a style that affects the look of a data series?

When you update data in a worksheet,you must press F9 to update the data in the associated chart.

A(n)________ column chart compares groups of columns set side by side for easy display.

A chart filter controls which data series and categories are visible on a chart in Excel.

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