Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Which custom format would display a value of 7987
as 7,987?
a. | 0,000 | c. | #,### | b. | *,*** | d. | @,@@@ |
|
|
|
2.
|
The Corrections button is found in which Picture
Tools group?
a. | Arrange | c. | Adjust | b. | Picture Styles | d. | Styles |
|
|
|
3.
|
What part of a chart gives information about what
the different colors and patterns represent?
a. | Brightness | c. | Contrast | b. | Legend | d. | Color Scale |
|
|
|
4.
|
How can you format most parts of a
chart?
a. | Choose Chart Tools>Layout | c. | Click the part of the chart that
you want to change | b. | Choose Format>Chart | d. | Double-click the part of the chart that you
want to change. |
|
Matching
|
|
|
a. | Brightness | i. | Legend | b. | Color Scale | j. | Rotate | c. | Conditional
Formatting | k. | Scale | d. | Conditional Formatting
Manager | l. | Sizing
Handle | e. | Contrast | m. | Conflict | f. | Custom Number Format | n. | Trend | g. | Data
Bar | o. | Utilize | h. | Icon Set |
|
|
|
5.
|
Changes that are made to the appearance of a cell
or cell range only if it meets
certain conditions.
|
|
|
6.
|
Preset icons, such as arrows, flags, and symbols,
that highlight specifi c values.,
|
|
|
7.
|
Degree of difference between light and dark parts
of an image.,
|
|
|
8.
|
Dot or box on the edges of a graphic that allows
you to resize the image.,
|
|
|
9.
|
Part of a chart that indicates what each color or
pattern represents.,
|
|
|
10.
|
The lightness or darkness of a
graphic
|
|
|
11.
|
Turning a graphic clockwise (to the right) or
counterclockwise (to the left).
|
|
|
12.
|
Allows the user to create, edit, delete, and view
all conditional formatting rules in a worksheet or workbook.
|
|
|
13.
|
Not in agreement
|
|
|
14.
|
Variants of color that are based on the values in
a range.
|
|
|
15.
|
Changing the height or width of a graphic in
percentages.
|
|
|
16.
|
A colored bar added to cells based on the value of
the data.
|
|
|
17.
|
Dot or box on the edges of a graphic that allows
you to resize the image.,
|
|
|
18.
|
Pattern.
|
|
|
19.
|
A tool to format numbers in a way that is not
listed in the Format Cells dialog
box.
|
|
|
20.
|
To use.
|