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