CGS 2518 TEST #1 QUESTIONS AND
ANSWERS
When a formula contains a typographical error, unnecessary or missing punctuation,
incorrect order of arguments, or an incorrect cell reference, it returns: - Answer-An error
message that begins with a number sign (#)
This useful Excel function evaluates a specified condition or statement and returns one
value if the condition or statement is true and another value if it is false: - Answer-IF
The Excel tool button that allows you to step through each part of a formula is called: -
Answer-Evaluate Formula
It is important to remember that Excel calculates these operations before any others are
performed: - Answer-Items in parentheses
The type of chart that shows percentages of a whole and has no axes is a: - Answer-Pie
chart
An Excel chart that is displayed on its own sheet in the workbook is called a: - Answer-
Chart sheet
In a histogram chart, the category labels are shown: - Answer-On the horizontal axis
A chart that includes two chart types such as a line chart and a column chart is referred
to as a: - Answer-Combination chart
A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a
pattern or trend is called a/an: - Answer-Sparkline
To apply changes to your chart's Shape Fill, Shape Outline, or Shape Effects
separately, use the: - Answer-Format tab
The text label that describes each data series in a chart is called the: - Answer-Category
label
When you want to visually represent the numeric data in a worksheet, Excel helps you
create an appropriate: - Answer-Chart
A variegated blend of colors in a chart element is called a: - Answer-Gradient
The Excel chart element that displays averages in your data and can be used to
forecast data by plotting future approximate averages is the: - Answer-Trendline
ANSWERS
When a formula contains a typographical error, unnecessary or missing punctuation,
incorrect order of arguments, or an incorrect cell reference, it returns: - Answer-An error
message that begins with a number sign (#)
This useful Excel function evaluates a specified condition or statement and returns one
value if the condition or statement is true and another value if it is false: - Answer-IF
The Excel tool button that allows you to step through each part of a formula is called: -
Answer-Evaluate Formula
It is important to remember that Excel calculates these operations before any others are
performed: - Answer-Items in parentheses
The type of chart that shows percentages of a whole and has no axes is a: - Answer-Pie
chart
An Excel chart that is displayed on its own sheet in the workbook is called a: - Answer-
Chart sheet
In a histogram chart, the category labels are shown: - Answer-On the horizontal axis
A chart that includes two chart types such as a line chart and a column chart is referred
to as a: - Answer-Combination chart
A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a
pattern or trend is called a/an: - Answer-Sparkline
To apply changes to your chart's Shape Fill, Shape Outline, or Shape Effects
separately, use the: - Answer-Format tab
The text label that describes each data series in a chart is called the: - Answer-Category
label
When you want to visually represent the numeric data in a worksheet, Excel helps you
create an appropriate: - Answer-Chart
A variegated blend of colors in a chart element is called a: - Answer-Gradient
The Excel chart element that displays averages in your data and can be used to
forecast data by plotting future approximate averages is the: - Answer-Trendline
