How can we help?

You can also find more resources in our Help Center.

27 terms

Tutorials 4-6

STUDY
PLAY
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.