College Computing Excel Exam
data label
A ________ in a pie chart identifies the pie slices.
active cell
A cell surrounded by a black border and ready to receive data is the:
chart area
A chart and all of its elements is known as the ________
true
A chart title can be taken from a cell in a worksheet. true or false?
line chart
A chart type that displays trends over time is a:
range finder
A feature that outlines cells in color to indicate which cells are used in a formula is called:
true
A graphic image can be inserted into the background of a chart. true or false?
true
A legend is a chart element that identifies the patterns or colors assigned to each category of a chart. true or false?
axis
A line that serves as a frame of reference for measurement in a chart is a(n) ________
true
A pie chart should be considered when you have just one data series to plot. true or false?
sum
A predefined formula that adds all the numbers in a selected range.
bevel
A shape effect that uses shading and shadows is a ________.
chart sheet
A workbook sheet that contains only a chart is a(n) ________.
pie chart
A(n) ________ displays the relationship of each part of a whole.
data point
A(n) ________ is a value in a worksheet cell that is represented in a chart by a data marker.
=
All formulas in Excel must begin with a ______
yes
Can you can double-click a sheet tab to rename it?
true
If a cell is too narrow to display a result of a formula or function, the ##### message displays. True or False?
true
If you change the value in a cell referenced in a formula, the result of the formula will automatically recalculate. true or false?
it will automatically update
If you edit data in a worksheet that is associated with a pie chart ________
numbers
In Excel 2016, row heading are identified by ________.
workbook
On startup, Excel displays a new blank
false
The Unfreeze command locks columns and rows into place. True of False?
exploding
The action of pulling out a pie slice from a pie chart is called:
false
The category axis is also known as the y-axis. True or False
cell
The intersection of a column and row is known as a _________
y-axis
The value axis is also known as the ________
arguments
The values that an Excel function uses to perform calculations or operations are the:
sheet1, sheet2, etc.
What are the default names of worksheets?
in the lower right corner of a cell
Where is the fill handle located?