WorksheetsMicrosoft Excel: Chapter 3 Test Review
Total questions: 54
Worksheet time: 28mins
(a) analysis looks at how future results might change based on varying inputs or data.
Calculate a percentage of a total by dividing the individual value by the total value.
True
False
(a) means to insert an object in a destination document so that it can still be edited by the source application.
Excel will always display an error message when improperly placed parentheses can cause logic flaws in a formula.
True
False
An (a) chart is a chart that exists as an object in the worksheet alongside the data.
The (a) area is the overall background for the chart and all its elements.
Making data or formatting changes to an Excel chart embedded in Word also changes the original data or chart in Excel.
True
False
Separating one slice of a pie chart from the rest of the chart is called:
Reforming
Exploding
Adjusting
Emphasizing
To maintain the link, the source and destination files do not need to remain in their original locations.
True
False
When you change the data or chart formatting in a linked chart and open the destination file again, the link causes the destination chart to update as well.
True
False
Sorting data in a pie chart changes the order of the pie slices.
True
False
An (a) sheet is a chart that exists on a separate sheet in the workbook.
Changes to a linked object in the destination document are automatically made to the object in the source document.
True
False
The horizontal axis is the axis that goes from top to bottom.
True
False
A(n) (a) is a calculation of proportion.
An embedded chart in the destination file may also be displayed as an icon.
True
False
Match the chart type to its description.
Scatter
Shows the relationship of each value in a single series to the total for the series
Connects points of data, making them effective for showing changes over time, such as trends
Compares individual or sets of values
Also called XY charts, represent data points as dots
Match the chart type to its description.
Pie
Shows the relationship of each value in a single series to the total for the series
Connects points of data, making them effective for showing changes over time, such as trends
Compares individual or sets of values
Also called XY charts, represent data points as dots
Match the chart type to its description.
Line
Shows the relationship of each value in a single series to the total for the series
Connects points of data, making them effective for showing changes over time, such as trends
Compares individual or sets of values
Also called XY charts, represent data points as dots
Match the chart type to its description.
Column
Shows the relationship of each value in a single series to the total for the series
Connects points of data, making them effective for showing changes over time, such as trends
Compares individual or sets of values
Also called XY charts, represent data points as dots
The process of saving worksheet data to the Internet is called (a) .
You can automatically republish your data whenever you change the workbook, using the (a) option in the Publish as Web Page dialog box.
One reason to rotate a pie chart's slices is to enhance the chart's appearance.
True
False
A(n) (a) object can add decorative text on a worksheet or chart sheet.
The shape representing each data point of a chart is a:
Data marker
Data series
Legend
Plot area
A link to an Excel chart in a Word document allows you to start Excel from inside Word.
True
False
(a) are the areas of a 3-D chart that frame the data series.
The axis of a chart on which categories are plotted is called the X axis.
True
False
For charts with multiple series, you have to format the data labels for each series independently.
True
False
Use the Chart Filters shortcut button to display selected data elements of a chart.
True
False
Selecting multiple rows of chart data creates multiple categories.
True
False
When there are multiple nested pairs of parentheses, Excel calculates:
From the innermost pair, working outward
From right to left
From the outermost pair, working inward
From left to right
(a) is a text description of a graphic that a screen-reading program can use to describe graphic content.
To show the structure of a company or institution, create a(n):
Pie chart
Bubble chart
Bar chart
Organization chart
To update a chart picture, you need to change the data in Excel and paste a new picture.
True
False
The (a) is a key that identifies each data series in a chart.
You can link or embed an Excel chart into another document, such as a Word document.
True
False
A chart is also known as a graph.
True
False
A set of related data points to be charted is a:
Legend
Data marker
Plot area
Data series
If you paste an Excel chart into Word, the Word file is the:
Embedded file
Linked file
Source file
Destination file
Once you create a chart, you cannot change its chart type.
True
False
To find the percentage of a value, convert the percentage to a decimal, and then multiply.
True
False
After you create a pie chart, you can move it to its own chart sheet.
True
False
The Recommended Charts feature examines your data and provides recommended chart types based on the type of your data.
True
False
A SmartArt graphic is a pre-drawn graphic used to illustrate a specific data relationship.
True
False
HTML format:
Is an Excel-based format
Cannot be used to publish a chart
Is a single file web page format in which the text, page format, and supporting graphics for a web page are stored in one file
Is a format in which the text and page format is stored in one file and the graphics and other elements are stored in separate files
When you need to be able to position text freely on a chart or worksheet, you can insert a:
Label
Legend
Floating cell
Text box
Lines of measurement along the category and value axis are called:
Walls
Tick marks
Objects
Text boxes
When selecting data to plot, you can include blank columns or rows.
True
False
If you select an embedded chart before choosing the Print command, only the chart will print.
True
False
To calculate a value in A1 with a percentage increase in A2 added to it, use this formula:
=(1+A2)*A1
=(A2)*A1+A2
=(1+A1)*A2
=A2*A1
The simplest way to include an Excel chart within another document is to paste its picture.
True
False
Once you have selected a chart type, you cannot add or remove chart elements from the chart layout.
True
False
You can change the coloring for a single slice of a pie chart.
True
False
