CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
A __________ chart shows the relationship of each part to a whole.
bar
column
scatter
pie - (answer)Pie
A data __________ is a value that originates in a worksheet cell.
legend
slice
marker
point - (answer)point
To display the Format Data Labels pane, after clicking the edge of the chart, you __________.
right-click any data Label and from the menu click More Options
Press Ctrl and click any data Label
Press Shift and click any data Label
Click Chart Elements, point to Data Labels, click the arrow to the right, and finally click More Options -
(answer)Click Chart Elements, point to Data Labels, click the arrow to the right, and finally click More
Options
,CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
_________ is a what-if analysis tool that finds the input needed in one cell to arrive at the desired result
in another cell.
Goal Seek
Filtering
Cell manipulation
Scenario modeling - (answer)Goal Seek
In terms of the order of operations, which of the following statements is FALSE?
Multiplication and division are performed before addition and subtraction.
Expressions within parentheses are performed first.
Consecutive operators with the same level of precedence are calculated from right to left.
Exponentiation, if present, is performed before multiplication and division. - (answer)Consecutive
operators with the same level of precedence are calculated from right to left.
__________ is the Excel feature which, after typing an equal sign and the beginning letter or letters of a
function name, displays a list of function names that match the typed letter(s).
,CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
Function Auto Fill
Formula AutoFill
Function AutoComplete
Formula AutoComplete - (answer)Formula AutoComplete
A __________ chart shows trends over time.
Open Hint for Question 7 in a new window.
line
bar
surface
pie - (answer)line
The value axis is also known as the __________.
legend
x-axis
base
y-axis - (answer)y-axis
A(n) __________ borders the chart plot area and is a line that serves as a frame of reference for
measurement.
, CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
axis
bevel
data marker
legend - (answer)axis
A number that displays E + a number indicates __________.
an addition error
that the value is expressed in exponential notation.
an overflow error
an extracted value - (answer)that the value is expressed in exponential notation.
To display the Select Data Source dialog box, __________.
point to any of the numbers on the value axis and double-click
click Select Data in the Data group on the Design tab
click Select Data in the Design group on the Data tab
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
A __________ chart shows the relationship of each part to a whole.
bar
column
scatter
pie - (answer)Pie
A data __________ is a value that originates in a worksheet cell.
legend
slice
marker
point - (answer)point
To display the Format Data Labels pane, after clicking the edge of the chart, you __________.
right-click any data Label and from the menu click More Options
Press Ctrl and click any data Label
Press Shift and click any data Label
Click Chart Elements, point to Data Labels, click the arrow to the right, and finally click More Options -
(answer)Click Chart Elements, point to Data Labels, click the arrow to the right, and finally click More
Options
,CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
_________ is a what-if analysis tool that finds the input needed in one cell to arrive at the desired result
in another cell.
Goal Seek
Filtering
Cell manipulation
Scenario modeling - (answer)Goal Seek
In terms of the order of operations, which of the following statements is FALSE?
Multiplication and division are performed before addition and subtraction.
Expressions within parentheses are performed first.
Consecutive operators with the same level of precedence are calculated from right to left.
Exponentiation, if present, is performed before multiplication and division. - (answer)Consecutive
operators with the same level of precedence are calculated from right to left.
__________ is the Excel feature which, after typing an equal sign and the beginning letter or letters of a
function name, displays a list of function names that match the typed letter(s).
,CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
Function Auto Fill
Formula AutoFill
Function AutoComplete
Formula AutoComplete - (answer)Formula AutoComplete
A __________ chart shows trends over time.
Open Hint for Question 7 in a new window.
line
bar
surface
pie - (answer)line
The value axis is also known as the __________.
legend
x-axis
base
y-axis - (answer)y-axis
A(n) __________ borders the chart plot area and is a line that serves as a frame of reference for
measurement.
, CCC EOC ALL Questions Complete UPDATE/PRACTICE QUESTIONS AND CORRECT
VERIFIED ANSWERS(Solutions) ASSURED SUCCESS/GRADED A+
axis
bevel
data marker
legend - (answer)axis
A number that displays E + a number indicates __________.
an addition error
that the value is expressed in exponential notation.
an overflow error
an extracted value - (answer)that the value is expressed in exponential notation.
To display the Select Data Source dialog box, __________.
point to any of the numbers on the value axis and double-click
click Select Data in the Data group on the Design tab
click Select Data in the Design group on the Data tab
