Question 1

Sizing handles display as small,black-filled circles to resize a chart.

Accepted Answer

A) True 
 B)False

Question 2

Describe the difference between an X-axis and a Y-axis.

Accepted Answer

The X-axis of a chart is a horizontal bo

Question 3

The ________ of a chart is a horizontal border that provides a frame of reference for measuring data horizontally.

Accepted Answer

The answer of The ________ of a chart is a...

Question 4

Match between columns
                        Premises: Surface chart
Bar chart
Bubble chart
Doughnut chart
Radar chart

Accepted Answer

The Answer of uses each category as a spoke and is...

Question 5

You can switch data used in a chart to create the horizontal axis and the legend.

Accepted Answer

A) True 
 B)False

Question 6

The Y-axis:

Accepted Answer

A) is text that describes a collection of data points in a chart. 
B) is a vertical line that borders the plot area to provide a frame of reference for measurement. 
C) compares values for one set of data. 
D) is a horizontal line that borders the plot area to provide a frame of reference for measurement. 
A) is text that describes a collection of data points in a chart. 
B) is a vertical line that borders the plot area to provide a frame of reference for measurement. 
C) compares values for one set of data. 
D) is a horizontal line that borders the plot area to provide a frame of reference for measurement.

Question 7

A(n)________ is a line used to depict trends and forecast future data.

Accepted Answer

The answer of A(n)________ is a line used to depict...

Question 8

The ________ of a chart is a key that identifies each data series of the chart.

Accepted Answer

The answer of The ________ of a chart is a...

Question 9

The ________ of a chart is the region containing the graphical representation of the values in a data series.

Accepted Answer

The answer of The ________ of a chart is the...

Question 10

A column chart is most effective with four to eight categories that display.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: Chart Styles button
Chart Filter button
Chart Elements button
Design tab
Quick Analysis button

Accepted Answer

The Answer of indicates a data series or category displayed is...

Question 12

What does a chart filter do?

Accepted Answer

A chart filter controls which data serie

Question 13

Which of the following is NOT controlled by choosing a chart style?

Accepted Answer

A) Color of the chart area 
B) Sparklines 
C) Plot area 
D) Data series 
A) Color of the chart area 
B) Sparklines 
C) Plot area 
D) Data series

Question 14

Match between columns
                        Premises: Sizing handles
Chart sheet
Chart filter
Chart style
Chart title

Accepted Answer

The Answer of worksheet that contains only a single chart is...

Question 15

By default,Excel inserts a chart on its own chart sheet.

Accepted Answer

A) True 
 B)False

Question 16

To move a chart from one sheet to another,click the ________ tab and click Move Chart.

Accepted Answer

The answer of To move a chart from one sheet...

Question 17

Which of the following is NOT a type of sparkline?

Accepted Answer

A) Bar 
B) Line 
C) Column 
D) Win/loss 
A) Bar 
B) Line 
C) Column 
D) Win/loss

Question 18

When you select a range of cells and hover the mouse over the selected range,what happens in Excel 2013?

Accepted Answer

The Quick Analysis button in the bottom-

Question 19

If you embedded a chart on the same sheet as the data source,you cannot print the chart only.

Accepted Answer

A) True 
 B)False

Question 20

When choosing an appropriate chart style,what should you consider?

Accepted Answer

An appropriate chart style should comple

Exam 20: Excel : Charts: Depicting Data Visually

Sizing handles display as small,black-filled circles to resize a chart.

Describe the difference between an X-axis and a Y-axis.

The ________ of a chart is a horizontal border that provides a frame of reference for measuring data horizontally.

You can switch data used in a chart to create the horizontal axis and the legend.

The Y-axis:

A(n)________ is a line used to depict trends and forecast future data.

The ________ of a chart is a key that identifies each data series of the chart.

The ________ of a chart is the region containing the graphical representation of the values in a data series.

A column chart is most effective with four to eight categories that display.

What does a chart filter do?

Which of the following is NOT controlled by choosing a chart style?

By default,Excel inserts a chart on its own chart sheet.

To move a chart from one sheet to another,click the ________ tab and click Move Chart.

Which of the following is NOT a type of sparkline?

When you select a range of cells and hover the mouse over the selected range,what happens in Excel 2013?

If you embedded a chart on the same sheet as the data source,you cannot print the chart only.

When choosing an appropriate chart style,what should you consider?

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