excel 3
Use the ________ key to select A5:A8 and D5:D8
Ctrl
When you print a chart sheet, how is it automatically formatted
It is centered on the page
Which symbol represents that a cell is an absolute cell reference in a function or formula
$
To what extent can a pie chart be rotated
360
is a group of related data points represented by data markers
a data series
A(n) ________ refers to a cell by its fixed position in the worksheet
absolute cell reference
A ________ in a pie chart identifies the pie slices
data label
Which of the following is the first order of operations
expressions within parentheses
A chart sheet contains only a chart and the data used to generate that chart
false
A data marker is a value that originates in a worksheet cell and that is represented in a chart
false
Bevel is a shape effect that uses bolding and colors to make the edges of a shape appear to be straight or diagonal
false
Consecutive operators with the same level of precedence are calculated from right to left
false
In a formula, a % sign designates that a cell in a formula is an absolute
false
Only one piece of a pie can be exploded
false
Use the F1 key to cancel a moving border after you have copied and pasted
false
When you group sheets, only one sheet can be viewed in Print Preview
false
When you select the data range for a pie chart, you should be sure to include the total cell on the worksheet
false
________ is an Excel tool that finds the input needed to arrive at a desired result
goal seek
Which of the following is NOT one of the three spatial dimensions of 3-D
height
Which of the following is TRUE about a pie chart
it shows the relationship of each part to a whole
Which of the following displays trends over time
line chart
In Goal Seek, the ________ box contains the formula that calculates the information you seek.
set cell
If you edit data in a worksheet that is associated with a pie chart
the pie slices will be automatically updated
To size a chart proportionately, hold down the ________ key and ________
Shift; drag a corner sizing handle
Where is the Format Painter button located
On the mini toolbar and the Home tab
In Goal Seek, you enter the specific value that you want to achieve in the ________ box
to value
3-D is short for three-dimensional
true
A chart and all of its elements is known as the
true
A graphic image can be inserted into the background of a chart
true
A legend is a chart element that identifies the patterns or colors assigned to each category of a chart
true
A pie chart should be considered when you have just one data series to plot
true
Every Excel formula starts with an equal sign (=)
true
Formula AutoComplete displays a list of function names that match the letter or two that you type
true
Goal Seek is a what-if analysis tool
true
If you change the value in a cell referenced in a formula, the result of the formula will automatically recalculate
true
In Excel, you should use parentheses in order to specify the order in which operations needs to occur
true
Numbers that display with E + a number are an exponential notation
true
The Format Painter button can be accessed from the mini toolbar
true
The chart area is the background and surrounding border of a chart
true
The order of data in the worksheet determines how the pie slices are ordered in a pie chart.
true
The plot area of a chart is bounded by the axes, including all the data series
true
The y-axis of a chart is also referred to as the value axis
true
When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references
true
When you select a worksheet that is part of a group, [Group] displays in the title bar.
true
When you select two ranges on a worksheet to create a pie chart, there must be the same number of cells selected in each of the two ranges
true
You can edit the data or a label in a cell by double-clicking the cell and then positioning the insertion point within the cell
true
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as
what-if analysis
AutoFill will fill a series when you establish a pattern
with two or more cells
In a line chart, which of the following resides along the bottom of the chart
x-axis
Which of the following resides along the left side of a column char
y-axis
