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. |
|
|
5.
|
When you use an advanced filter, what happens to the data that does not meet the
criteria you set.
a. | It is displayed dimly. | c. | It is deleted | b. | It is temporarily hidden | d. | Its value is
changed. |
|
|
6.
|
What is the total of a group of tiems within a larger set of items?
a. | Subtotal | c. | AutoSum | b. | Grand Total | d. | Total |
|
|
7.
|
Which of the following tools identifies inaccurate data?
a. | Data Validation | c. | Circle Invalid Data | b. | Group and Outline Data. | d. | Evaluate Formula
|
|
|
8.
|
What does Evaluate Formula do?
a. | Points to possible sources of an error. | c. | Steps through a
calculation | b. | Displays tracer arrows | d. | Displays an explanation of an error. |
|
|
9.
|
Which of the following hot key commnds will move you down one screen?
a. | CTRL + Page UP | c. | CTRL + Page Down | b. | Page Up | d. | Page Down |
|
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 |
|
|
10.
|
Changes that are made to the appearance of a cell
or cell range only if it meets certain conditions.
|
|
11.
|
Preset icons, such as arrows, flags, and symbols,
that highlight specifi c values.,
|
|
12.
|
Degree of difference between light and dark parts
of an image.,
|
|
13.
|
Dot or box on the edges of a graphic that allows
you to resize the image.,
|
|
14.
|
Part of a chart that indicates what each color or
pattern represents.,
|
|
15.
|
The lightness or darkness of a
graphic
|
|
16.
|
Turning a graphic clockwise (to the right) or
counterclockwise (to the left).
|
|
17.
|
Allows the user to create, edit, delete, and view
all conditional formatting rules in a worksheet or workbook.
|
|
18.
|
Not in agreement
|
|
19.
|
Variants of color that are based on the values in
a range.
|
|
20.
|
Changing the height or width of a graphic in
percentages.
|
|
21.
|
A colored bar added to cells based on the value of
the data.
|
|
22.
|
Dot or box on the edges of a graphic that allows
you to resize the image.,
|
|
23.
|
Pattern.
|
|
24.
|
A tool to format numbers in a way that is not
listed in the Format Cells dialog box.
|
|
25.
|
To use.
|
|
|
a. | Advanced Filter | h. | Subset | b. | Criteria | i. | Subtotal | c. | Data Validation | j. | Convert | d. | Duplicate
Value | k. | Error | e. | Evaluate Formula | l. | Interpret | f. | Name | m. | Sum | g. | Name Manager
|
|
|
26.
|
To construe or understand in a particular way
|
|
27.
|
When you use an advanced filter, only those items in a range of cells or table
that meet certian ________________ or conditions will be displayed.
|
|
28.
|
A(n) _______________ can be used in a formula in the same way as a conventional
cell reference.
|
|
29.
|
Where all values in a row are an exact match of
all values in another row
|
|
30.
|
A small amount of data selected from a larger amount.
|
|
31.
|
The total of a group of items.
|
|
32.
|
Change
|
|
33.
|
Error-checking tool to locate invalid formulas
|
|
34.
|
A filter that specifies multiple criteria for displaying data.
|
|
35.
|
A mistake made when entering data, creating formulas etc
|
|
36.
|
The sum of a group of items within a larger set of items.
|
|
37.
|
Ensuring that data is correct based on specifi c criteria.
|
|
38.
|
A tool that finds, modifi es, or deletes the defi`ned names used in a
workbook.
|