CPSC Practice Test Questions and Answers
A ________ contains the actual values that are plotted on the chart. - ANSWER-data
series (not source)
A chart sheet can contain ____. - ANSWER-only one chart
A data ____ table describes the fields you plan to maintain in a table. - ANSWER-
definition
All template files have a(n) ____ extension. - ANSWER-xtlx
Excel functions are organized into ____ categories. - ANSWER-13 (charts = 10)
If Excel successfully accessed the link and updated the values from the source
document, the status in the Edit Links dialog box will be ____. - ANSWER-OK
If the VLOOKUP function cannot find the lookup value, the _________ error value is
displayed in the cell. - ANSWER-#N/A
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may
be numbers or ____. - ANSWER-cell references
One of the great advantages of ____ references is that you can quickly generate row
and column totals without having to worry about revising the formulas as you copy them
to new locations. - ANSWER-relative
The ____ condition requires that all of the selected criteria be true for the record to be
displayed - ANSWER-and
The ____ condition requires that all of the selected criteria be true for the record to be
displayed. - ANSWER-and
The ____ criteria filter requires the records displayed to be greater than or equal to and
less than or equal to the specified numbers. - ANSWER-between
The fields you use to order your data are called sort ____. - ANSWER-fields
The fill handle copies ____. - ANSWER-content and format
The range of values or _______, of an axis is based on the values in the data source. -
ANSWER-scale
Use ____ references when you want different formulas to refer to the same cell. -
ANSWER-absolute
A ________ contains the actual values that are plotted on the chart. - ANSWER-data
series (not source)
A chart sheet can contain ____. - ANSWER-only one chart
A data ____ table describes the fields you plan to maintain in a table. - ANSWER-
definition
All template files have a(n) ____ extension. - ANSWER-xtlx
Excel functions are organized into ____ categories. - ANSWER-13 (charts = 10)
If Excel successfully accessed the link and updated the values from the source
document, the status in the Edit Links dialog box will be ____. - ANSWER-OK
If the VLOOKUP function cannot find the lookup value, the _________ error value is
displayed in the cell. - ANSWER-#N/A
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may
be numbers or ____. - ANSWER-cell references
One of the great advantages of ____ references is that you can quickly generate row
and column totals without having to worry about revising the formulas as you copy them
to new locations. - ANSWER-relative
The ____ condition requires that all of the selected criteria be true for the record to be
displayed - ANSWER-and
The ____ condition requires that all of the selected criteria be true for the record to be
displayed. - ANSWER-and
The ____ criteria filter requires the records displayed to be greater than or equal to and
less than or equal to the specified numbers. - ANSWER-between
The fields you use to order your data are called sort ____. - ANSWER-fields
The fill handle copies ____. - ANSWER-content and format
The range of values or _______, of an axis is based on the values in the data source. -
ANSWER-scale
Use ____ references when you want different formulas to refer to the same cell. -
ANSWER-absolute
