GO! Excel 2016 Chapter 3 Practice Exam
A chart title can be taken from a cell in a worksheet. True False
t
A legend is a chart element that identifies the patterns or colors assigned to each category of a chart. True False
t
A pie chart should be considered when you have just one data series to plot. True False
t
Every Excel formula starts with an equal sign (=). True False
t
Formula AutoComplete displays a list of function names that match the letter or two that you type. True False
t
In Excel, you should use parentheses in order to specify the order in which operations needs to occur. True False
t
Numbers that display with E + a number are an exponential notation. True False
t
The Chart Elements button allows you to add, remove, or change chart elements. True False
t
The Format Painter button can be accessed from the mini toolbar. True False
t
The order of data in the worksheet determines how the pie slices are ordered in a pie chart. True False
t
The plot area of a chart is bounded by the axes, including all the data series. True False
t
The y-axis of a chart is also referred to as the value axis. True False
t
When you copy a formula to another cell and the cells in the formula change, the cells are known as relative cell references. True False
t
When you select a worksheet that is part of a group, [Group] displays in the title bar. True False
t
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 False
t
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 False
t
Which of the following resides along the left side of a column chart? The plot area The y-axis The x-axis The legend
the y-axis
In Goal Seek, you enter the specific value that you want to achieve in the ________ box. By changing cell To value Set cell Goal Seek dialog
to value
To what extent can a pie chart be rotated? Up to 360 degrees Up to 180 degrees Up to 45 degrees Up to 90 degrees
up to 360 degrees
Which of the following is the second order of operations? Division Expressions within parentheses Exponentiation Multiplication
Exponentiation
How can you identify the Chart Elements button when you select a chart? It looks like a funnel. It is a green plus sign. It is a percent sign. It looks like a paintbrush.
It is a green plus sign.
Which symbol represents that a cell is an absolute cell reference in a function or formula? * & % $
$
Which of the following displays trends over time? A pie chart A line chart What-if analysis An axis
a line chart
A(n) ________ refers to a cell by its fixed position in the worksheet. data marker absolute cell reference relative cell reference 3-D cell reference
absolute cell reference
A chart and all of its elements is known as the ________. plot area axis chart area chart sheet
chart area
A ________ in a pie chart identifies the pie slices. data series data point data marker data label
data label
A Major unit value in a line chart determines the range of numbers in the value axis. True False
f
A chart sheet contains only a chart and the data used to generate that chart. True False
f
A data marker is a value that originates in a worksheet cell and that is represented in a chart. True False
f
All Excel charts have a minimum of three background elements. True False
f
Bevel is a shape effect that uses bolding and colors to make the edges of a shape appear to be straight or diagonal. True False
f
The chart area is the background and surrounding border of a chart. True False
f
Use the F1 key to cancel a moving border after you have copied and pasted. True False
f
When you group sheets, only one sheet can be viewed in Print Preview. True False
f
________ is an Excel tool that finds the input needed to arrive at a desired result. Goal Seek Formula AutoComplete A bevel A what-if analysis
goal seek
Which of the following is NOT one of the three spatial dimensions of 3-D? Width Length Height Depth
height
In Goal Seek, the ________ box contains the formula that calculates the information you seek. To value By changing cell Set cell Goal Seek dialog
set cell
3-D is short for three-dimensional. True False
t
Goal Seek is a what-if analysis tool. True False
t
To size a chart proportionately, hold down the ________ key and ________. Shift; drag a left or right sizing handle Shift; drag a top or bottom sizing handle Ctrl; drag a corner sizing handle Shift; drag a corner sizing handle
Shift; drag a corner sizing handle
Which of the following is TRUE about a pie chart? A pie chart should be your first choice when there are two data series to plot. It displays data that is arranged in one or more columns or rows or data. A pie chart has a minimum of three data series. It shows the relationship of each part to a whole.
It shows the relationship of each part to a whole.
Where is the Format Painter button located? On the mini toolbar and the Pay Layout tab On the mini toolbar and the Design tab On the Home tab and the Page Layout tab On the mini toolbar and the Home tab
On the mini toolbar and the Home tab
If you edit data in a worksheet that is associated with a pie chart ________. an error message will display a new, second pie chart must be created the pie slices must be manually updated the pie slices will be automatically updated
the pie slices will be automatically updated
In a line chart, which of the following resides along the bottom of the chart? The legend The plot area The x-axis The y-axis
the x-axis
________ is a group of related data points represented by data markers. A data series The x-axis A value axis The y-axis
A data series
Use the ________ key to select A5:A8 and D5:D8. $ Ctrl Alt Shift
ctrl
Consecutive operators with the same level of precedence are calculated from right to left. True False
f
Only one piece of a pie can be exploded. True False
f
