Advertisement Upgrade to remove ads

to show trends or relationships across data

For which of the following reasons would you choose to use a chart or graph

series name

Referring to the figure above, an example of a _____ _____ is row 9.

pie

The ______ is the only one of the following charts to compare relative values from different categories to the whole

chart sheet

Placing a chart in a ______ displays only the chart and no worksheet cells.

data markers

The columns and pie slices in the charts above are ________.

legend

Referring to the figure above, the rectangular area to the right of the pie chart (listing Cash, U.S. Stocks, Non-U.S. Stocks, and Bonds) is the ______.

must format each slice separately

Since each slice of a pie represents a different value in the series, you ________.

exploded pie chart

To move one slice of a pie chart away from the pie creates a(n) ________.

perspective

A 90 degree __________ value exaggerates the 3-D effect, making distant objects appear very small.

paste the chart as a Picture

If you do not want a chart to reflect new values in the data source, you should_______.

sparklines

In the above figure, the data markers shown in the cells in the column labeled "Performance," are _________.

major tick mark

A ______ acts like line on a ruler, making it easier to read a charts scale.

mmm dd, yyyy

To display Mar 17, 2008 as a custom format, you would type ______ in the Format Code: box in Excel.

#,##0"k"

Which of the following would result in adding the value 'k' to the end of each number on a charts vertical axis?

z-axis

On a 3-D chart, the _____ represents the object's depth

C2:F12

Which of the following represents a range of data in excel?

2Table

Which of the following is NOT a vaild table name?

Descending

______ order arranges labels in reverse alphabetical order, from Z to A.

none of these

After data is filter you can ______ it

AND

The ______ condition requires that all of the selected criteria be true for a record to be displayed.

OR

The ______ condition requires that only one of the selected criteria be true for a record to be displayed

Contains

The ______ criteria filter requires the records displayed to have the specified text string anywhere.

Between

The _____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers

leave the lower boxes empty

In the figure above, if you only want to set one criterion for this filter you'll ____

$20,001

In the figure above, the 20,000 indicates the price of a piece of artwork. Records with artwork with the following values meet the criteria: _______

Convert to Range

To calculate subtotal for a table, first use the _____ button on the Table Tools Design tab

outlines

In addition to displaying subtotals, the Subtotal feature "_____" your worksheet so you can control the level of detail that is displayed.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set