Chpt. 3 (Comp)
Consecutive operators with the same level of precedence are calculated from right to left
False
Only one piece of the pie can be exploded
False
The chart area is the background and surrounding border of a chart
False
Use the F1 key to cancel a moving border after you have copied and pasted
False
When you select the data range for a pie chart, you should be sure to include the total cell on a worksheet
False
To what extent can a pie chart be rotated
Up to 360 degrees
_______ 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 chart and all of its elements is known as the _______
chart area
A __________ in a pie chart identifies the pie slices
data label
You must select ________ on a worksheet to create a pie chart
Two ranges
Which symbol represents that a cell is an absolute cell reference in a function or formula
$
If B4 contains the formula =$F$5 and you copy and paste B4 into D8, what will the formula be in D8?
$F$5
If you edit data in a worksheet that is associated with a pie chart _________
the pie slices will be automatically updated
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
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
A location chart compares values and shows categories across geographical regions
False
All Excel charts have a minimum of three background elements
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
A Major unit value in a line chart determines the range of numbers in the value axis
False
Which of the following displays trends over time
A line chart
Use the ______ key to select A5:A8 and D5:D8
Ctrl
Which of the following is the second order of operation
Exponentiation
Which of the following is the first order of operation
Expressions within parantheses
__________ is an Excel tool that find the input needed to arrive at a desired result
Goal Seek
Which of the following is not one of the three spatial dimensions of #-D?
Height
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 the whole
Where is the Format Painter button located
On the mini toolbar and the Home tab
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
3-D is short for three-dimensional
True
A funnel chart is named that way because the values decrease gradually, allowing the bars to resemble a funnel
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
Funnel charts show values across the stages in a process
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
In a map chart, each region displays shading to indicate the values in the data series
True
Numbers that display with E + a number are an exponential notation
True
Rate = amount of increase/base is the mathematical formula to calculate a rate of increase
True
Rotating the chart can provide a better perspective to the chart
True
The Chart Elements button allows you to add, remove, or change chart elements
True
The base is considered the starting point
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
Value after increase = base x percent for new value is the formula for calculating the value after an increase by multiplying the original value by the percent for a new value
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
You can edit the data or label in a cell by double-clicking the cell and then positioning the insertion point within the cell
True