Excel Competency Final UPDATED Actual
Exam Questions and CORRECT Answers
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a
worksheet in the Excel application. - CORRECT ANSWER✔✔- True
The Accounting Number Style displays values with commas and two decimal places, but no
dollar signs. - CORRECT ANSWER✔✔- False
A function is always structured beginning with the function address and an opening
parenthesis mark. - CORRECT ANSWER✔✔- False
The function inputs are referred to as arguments. - CORRECT ANSWER✔✔- True
To use a "general" formula over and over again but with a different set of numbers, use a
feature called absolute cell referencing. - CORRECT ANSWER✔✔- False
The error message ###### means that there is ____. - CORRECT ANSWER✔✔- insufficient
width in the cell to display data, or negative date/time
The ____ function adds a list of values and/or cell ranges. - CORRECT ANSWER✔✔- Sum
Each function has its own ____, which specifies the function name and order of the
arguments. - CORRECT ANSWER✔✔- syntax
$B$1 is an example of a(n) ____ reference. - CORRECT ANSWER✔✔- absolute
B1 is an example of a(n) ____ reference. - CORRECT ANSWER✔✔- relative
Microsoft Excel charts provide a visual representation of quantitative information, giving the
viewer an overall picture of a set of data. - CORRECT ANSWER✔✔- True
, In a line chart, values are indicated by the filled areas below the lines. - CORRECT
ANSWER✔✔- False
The Alternative Data task pane, which is available from the shortcut menu for a selected
chart, provides options for modifying the values used to generate a chart. - CORRECT
ANSWER✔✔- False
You must make changes to the content of data labels using buttons in the Format Data Labels
task pane. - CORRECT ANSWER✔✔- True
Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine
many smaller segments of a pie chart into a separate smaller chart. - CORRECT
ANSWER✔✔- False
The ____ is the vertical axis where data values are plotted. - CORRECT ANSWER✔✔- y-
axis
The purpose of formatting is to make a chart ____. - CORRECT ANSWER✔✔- easier for the
viewer to understand
Stacked charts do a good job of illustrating the ____ effects of data in categories. -
CORRECT ANSWER✔✔- cumulative
The ____ option of splitting a pie data series into a second, smaller pie chart allows you to
select a cutoff point by percentage, rather than value, and assign all the percentages below
that point to the second plot. - CORRECT ANSWER✔✔- percentage value
With the ____ sub-type, the data to be plotted must be placed by column in this order: high
stock value for the day, low stock value, and, finally, closing stock value. - CORRECT
ANSWER✔✔- High-Low-Close
If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter
the following formula: =3>5. - CORRECT ANSWER✔✔- True
Exam Questions and CORRECT Answers
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a
worksheet in the Excel application. - CORRECT ANSWER✔✔- True
The Accounting Number Style displays values with commas and two decimal places, but no
dollar signs. - CORRECT ANSWER✔✔- False
A function is always structured beginning with the function address and an opening
parenthesis mark. - CORRECT ANSWER✔✔- False
The function inputs are referred to as arguments. - CORRECT ANSWER✔✔- True
To use a "general" formula over and over again but with a different set of numbers, use a
feature called absolute cell referencing. - CORRECT ANSWER✔✔- False
The error message ###### means that there is ____. - CORRECT ANSWER✔✔- insufficient
width in the cell to display data, or negative date/time
The ____ function adds a list of values and/or cell ranges. - CORRECT ANSWER✔✔- Sum
Each function has its own ____, which specifies the function name and order of the
arguments. - CORRECT ANSWER✔✔- syntax
$B$1 is an example of a(n) ____ reference. - CORRECT ANSWER✔✔- absolute
B1 is an example of a(n) ____ reference. - CORRECT ANSWER✔✔- relative
Microsoft Excel charts provide a visual representation of quantitative information, giving the
viewer an overall picture of a set of data. - CORRECT ANSWER✔✔- True
, In a line chart, values are indicated by the filled areas below the lines. - CORRECT
ANSWER✔✔- False
The Alternative Data task pane, which is available from the shortcut menu for a selected
chart, provides options for modifying the values used to generate a chart. - CORRECT
ANSWER✔✔- False
You must make changes to the content of data labels using buttons in the Format Data Labels
task pane. - CORRECT ANSWER✔✔- True
Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine
many smaller segments of a pie chart into a separate smaller chart. - CORRECT
ANSWER✔✔- False
The ____ is the vertical axis where data values are plotted. - CORRECT ANSWER✔✔- y-
axis
The purpose of formatting is to make a chart ____. - CORRECT ANSWER✔✔- easier for the
viewer to understand
Stacked charts do a good job of illustrating the ____ effects of data in categories. -
CORRECT ANSWER✔✔- cumulative
The ____ option of splitting a pie data series into a second, smaller pie chart allows you to
select a cutoff point by percentage, rather than value, and assign all the percentages below
that point to the second plot. - CORRECT ANSWER✔✔- percentage value
With the ____ sub-type, the data to be plotted must be placed by column in this order: high
stock value for the day, low stock value, and, finally, closing stock value. - CORRECT
ANSWER✔✔- High-Low-Close
If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter
the following formula: =3>5. - CORRECT ANSWER✔✔- True
