Which of the following chart types use one data series to display each value as a percentage of the whole?
pie
Which of the following displays the result of a formula?
cell
If your formula includes a syntax error, Excel displays an error message or returns an error code as the formula result.
true
Which of the following commands should you use to prevent column and row headings from scrolling off the screen?
Freeze Panes command
What must you do to enter a number as a label in a cell?
Type an apostrophe before the number.
The answer to the mathematical expression 3 + (2 + 4) * 4 is 27.
true
A chart layout is a preset combination of colors and effects for a chart, its background, and its elements.
false
When you use a picture as a fill, you can use the Stack and Scale setting to stretch it across the data marker.
false
Source data are the cells that contain values and labels to be graphed in the chart.
true
The Fill Handle is a useful tool for formatting worksheet cells.
false
Clicking a chart element opens its Format pane.
false
Before using the Merge & Center command, what cell should contain the data?
upper-left cell
A legend is the chart element that explains the symbols, textures, or colors used to differentiate data series.
true
Which of the following functions retrieves a value from a range or table of cells located in another area of the worksheet?
LOOKUP
What would you call the number values located on top of the bars in a column chart?
data label
You can print chart objects with the worksheet data or on separate sheets.
true
In Excel, a group of cells is called a range.
true
You can apply some formats, such as fill or font color, from the Home tab for a selected chart element.
true
WordArt is a text box with preset font style, fill, and text effects.
true
By default, text and values are oriented horizontally from left to right, but you can change text orientation to display text vertically or at an angle.
true
Another name for the base or bottom of a 3-D chart is chart floor.
true
Which of the following is the fixed location of a cell referenced in a formula or dialog box?
absolute reference
It is possible to replace a chart title box with WordArt.
true
Which of the following formulas correctly adds the values in cells E4 and E5?
0
In a pie chart, a data series is a slice of a pie.
false
Which of the following mathematical operations is always performed last?
subtraction
Which of the following would be a way to emphasize the highest sales month?
all of the above
An area chart uses one data series to display each value as a percentage of the whole.
false
You can use the following acronym to help remember the order of mathematical operations: Please Excuse My Dear Aunt Sally.
true
Which of the following keys create a default chart sheet for selected data?
F11
The cell address $G4 is a relative cell address.
false
Which of the following features would you want to use to center worksheet titles over multiple cells?
Merge & Center
Which of the following is not true about filters?
Filters alter the source data range.
In a chart, which of the following can you fill with pictures?
all of the above
In Excel, you can create nested IF functions that allow for more than one logical test.
true
Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
$F2
Which of the following is included in calculations?
values
Once you have created a chart, it is possible to change the chart type.
true
Excel treats any empty cell in an array as if it has a value of 1.
false
Which of the following statements is not true?
It is possible to change some bar charts into column charts, but not all.
Which of the following functions counts the number of cells in a range based on specified criteria?
COUNTIF
A circular reference occurs when the formula references the wrong cell address.
false
After you choose a color for a chart element, you can refine it to use a gradient, a variegated blend of the color.
true
The feature that resizes the column width or row height to accommodate the width or height of the largest entry is called the AutoWiden feature.
false
In Excel, the active cell displays a solid border around the cell, and the reference for the active cell appears in the Name box.
true
To activate edit mode, double-click the cell or press F2.
true