Exam 10: Analyzing and Charting Financial Data

Explore all topics

Mya has asked for your advice.A colleague told her to remove the legend from her pie chart because it takes up too much space.What would be a better piece of advice to give Mya?

(Multiple Choice)

4.8/5

(38)

Question 61

You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.

(Multiple Choice)

4.8/5

(44)

Question 62

In the figure above,fv and type are ____.

(Multiple Choice)

5.0/5

(34)

Question 63

To move one slice of a pie chart away from the pie creates a(n)____.

(Multiple Choice)

4.9/5

(38)

Question 64

Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

(Multiple Choice)

4.8/5

(38)

Question 65

A ________ contains the actual values that are plotted on the chart.

(Multiple Choice)

4.8/5

(42)

Question 66

______ are horizontal and vertical lines that help you compare data and category values.

(Short Answer)

4.8/5

(38)

Question 67

In a line chart,the data markers are the points connected by the line._________________________

(True/False)

4.8/5

(40)

Question 68

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

(Multiple Choice)

4.8/5

(38)

Question 69

Pie charts are most effective with ten or fewer slices._________________________

(True/False)

4.7/5

(47)

Question 70

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

(Multiple Choice)

4.9/5

(36)

Question 71

When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________

(True/False)

4.8/5

(39)

Question 72

Combination charts enable you to show three sets of data using the chart type that is best for each data set._________________________

(True/False)

4.9/5

(43)

Question 73

A pie slice is a data marker that represents ____ from a data series.

(Multiple Choice)

4.8/5

(35)

Question 74

The PMT function calculates the payment required in each period to pay back the loan.___________

(True/False)

4.9/5

(36)

Question 75

Showing 61 - 75 of 75

Mya has asked for your advice.A colleague told her to remove the legend from her pie chart because it takes up too much space.What would be a better piece of advice to give Mya?

You can choose Center,Inside End,Outside End,or Best Fit for the data label positions in the in the ____ pane.

In the figure above,fv and type are ____.

To move one slice of a pie chart away from the pie creates a(n)____.

Mya has decided she needs to move her chart so that it appears below her data source. Before she can move or resize her chart she must ______.

A ________ contains the actual values that are plotted on the chart.

______ are horizontal and vertical lines that help you compare data and category values.

In a line chart,the data markers are the points connected by the line._________________________

The _______ displays the data series in separate columns side-by-side so that you can compare the relative heights of the columns in the three series.

Pie charts are most effective with ten or fewer slices._________________________

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________

Combination charts enable you to show three sets of data using the chart type that is best for each data set._________________________

A pie slice is a data marker that represents ____ from a data series.

The PMT function calculates the payment required in each period to pay back the loan.___________

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters