Excel Competency
$B$1 is an example of a(n) ____ reference.
Absolute
Stacked charts do a good job of illustrating the ____ effects of data in categories.
Cumulative
The Accounting Number Style displays values with commas and two decimal places, but no dollar signs.
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.
False
You must make changes to the content of data labels using buttons in the Format Data Labels task pane.
True
The purpose of formatting is to make a chart ____.
Easier for the viewer to understand
In a line chart, values are indicated by the filled areas below the lines
False
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
High-low-close
The error message ###### means that there is ____.
Insufficient width in the cell to display data, or negative date/time
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.
Percentage value
B1 is an example of a(n) ____ reference.
Relative
The ____ function adds a list of values and/or cell ranges.
Sum
Each function has its own ____, which specifies the function name and order of the arguments.
Syntax
A function is always structured beginning with the function address and an opening parenthesis mark.
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.
True
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.
True
Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.
True
The function inputs are referred to as arguments.
True
To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing.
True
The ____ is the vertical axis where data values are plotted.
Y-Axis