Excel Chapter 3
Use the ________ key to select A5:A8 and D5:D8.
Ctrl
Which symbol represents that a cell is an absolute cell reference in a function or formula?
$
Which of the following is the first order of operations?
Expressions within parentheses
How can you identify the Chart Elements button when you select a chart?
It is a green plus sign.
When you print a chart sheet, how is it automatically formatted?
It is centered on the page.
Which of the following is TRUE about a pie chart?
It shows the relationship of each part to a whole.
Where is the Format Painter button located?
On the mini toolbar and the Home tab
_______ is a group of related data points represented by data markers.
a data series
Which of the following displays trends over time?
a line chart
A(n) ________ refers to a cell by its fixed position in the worksheet.
absolute cell reference
A chart and all of its elements is known as the ________.
chart area
Which of the following is the second order of operations?
exponentiation
A Major unit value in a line chart determines the range of numbers in the value axis. t/f
false
A chart sheet contains only a chart and the data used to generate that chart. t/f
false
Bevel is a shape effect that uses bolding and colors to make the edges of a shape appear to be straight or diagonal. t/f
false
Consecutive operators with the same level of precedence are calculated from right to left. t/f
false
In a formula, a % sign designates that a cell in a formula is an absolute. t/f
false
Only one piece of a pie can be exploded. t/f
false
The chart area is the background and surrounding border of a chart. t/f
false
Use the F1 key to cancel a moving border after you have copied and pasted. t/f
false
When you group sheets, only one sheet can be viewed in Print Preview. t/f
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
In Goal Seek, the ________ box contains the formula that calculates the information you seek.
set cell
In a line chart, which of the following resides along the bottom of the chart?
the x-axis
Which of the following resides along the left side of a column chart?
the y-axis
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. t/f
true
A chart title can be taken from a cell in a worksheet. t/f
true
A graphic image can be inserted into the background of a chart. t/f
true
A legend is a chart element that identifies the patterns or colors assigned to each category of a chart. t/f
true
A pie chart should be considered when you have just one data series to plot. t/f
true
Every Excel formula starts with an equal sign (=). t/f
true
Goal Seek is a what-if analysis tool. t/f
true
If you change the value in a cell referenced in a formula, the result of the formula will automatically recalculate. t/f
true
In Excel, you should use parentheses in order to specify the order in which operations needs to occur. t/f
true
The Chart Elements button allows you to add, remove, or change chart elements. t/f
true
The Format Painter button can be accessed from the mini toolbar. t/f
true
The order of data in the worksheet determines how the pie slices are ordered in a pie chart. t/f
true
The plot area of a chart is bounded by the axes, including all the data series. t/f
true
The y-axis of a chart is also referred to as the value axis. t/f
true
When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references. t/f
true
When you select a worksheet that is part of a group, [Group] displays in the title bar. t/f
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. t/f
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. t/f
true
You must select ________ on a worksheet to create a pie chart.
two rangers
To what extent can a pie chart be rotated?
up to 360 degrees
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