Modified True/False
Indicate
whether the statement is true or false. If false, change the identified word or phrase to make the
statement true.
|
|
|
1.
|
The Font, Font Size, and Bold buttons are found on the Page Layout
tab.
|
|
|
2.
|
Hiding columns or rows can make it easier to compare data
side-by-side.
|
|
|
3.
|
You can use SmartArt to create a variety of preset graphics, such as
diagrams and charts.
|
|
|
4.
|
Before Excel can convert text into columns, the text must be separated by a
border.
|
|
|
5.
|
The Format drop-down list in the Cells group on the Home tab contains an
option that lets you specify the height of a worksheet row.
|
|
|
6.
|
A border is a graphic or color that appears behind the information in a
worksheet.
|
|
|
7.
|
Center Across Selection involves aligning text across more than one
cell.
|
|
|
8.
|
If you want to set off a cell by placing a red box around it, choose
Home>Styles>Borders.
|
|
|
9.
|
When a worksheet is hidden, you can still access it.
|
|
|
10.
|
The numbers 12, 14, and 24 are examples of font sizes.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
Which tab in the Format Cells dialog box contains the Center Across Section
option?
a. | Font | c. | Border | b. | Alignment | d. | Number |
|
|
|
12.
|
You can rename a worksheet by choosing ____, clicking Rename Sheet, and keying
the new name.
a. | Home>Styles>Cell Styles | c. | Page Layout>Sheet
Options | b. | Home>Cells>Format | d. | Page Layout>Page Setup |
|
|
|
13.
|
In a company’s worksheets, its logo appears in light gray behind the
worksheet cells. This is an example of ____.
a. | cell formatting | c. | a background | b. | table formatting | d. | a border |
|
|
|
14.
|
____ is not an example of a font style.
a. | Bold | c. | Italic | b. | Border | d. | Underline |
|
|
|
15.
|
Which of the following cannot be specified on the Font tab in the Format
Cells dialog box?
a. | Font size | c. | Font alignment | b. | Font style | d. | Font color |
|
|
|
16.
|
Horizontal alignment is used to align the contents of a ____.
a. | worksheet | c. | row | b. | cell | d. | column |
|
|
|
17.
|
Which tab in the Format Cells dialog box contains the option to change a
word’s color?
a. | Font | c. | Border | b. | Patterns | d. | Number |
|
|
|
18.
|
To access the Paste Special command, ____.
a. | click the Paste Special button in the Clipboard group | b. | click the Paste
drop-down arrow and choose Paste Special | c. | choose Home>Styles>Cell
Styles | d. | choose Home>Cells>Format |
|
|
|
19.
|
Which of the following is not a category of graphic available in
SmartArt?
a. | Process | c. | Hierarchy | b. | Function | d. | List |
|
|
|
20.
|
To insert an organizational chart into a worksheet, choose ____.
a. | Home>Styles>Cell Styles | c. | Insert>Illustrations>SmartArt | b. | Home>Cells>Insert | d. | Insert>Illustrations>Picture |
|
|
|
21.
|
If you want to insert a graphic that will illustrate how different data items on
the worksheet are related to one another, you could use ____.
a. | SmartArt | c. | a background | b. | a theme | d. | a table style |
|
|
|
22.
|
.After you apply a table style to a range of data, the ____ contextual tab
appears on the Ribbon.
a. | Table Tools | c. | Quick Styles | b. | Style | d. | Page Layout |
|
|
|
23.
|
Which of the following is not a task that the Design tab allows you to
perform?
a. | Add a Total Row. | c. | Add a Header Row. | b. | Add a Function. | d. | Add a Last
Column. |
|
|
|
24.
|
You can apply a theme by choosing ____.
a. | Home>Styles>Format as Table | c. | Home>Cells>Format | b. | Home>Styles>Cell
Styles | d. | Page
Layout>Themes>Themes |
|
|
|
25.
|
One way to make a column wider is to choose ____.
a. | Home>Cells>Format and click Column Width | b. | Home>Styles>Cell Styles and click the desired width | c. | Home>Alignment>Center | d. | Page Layout>Page
Setup>Columns |
|
|
|
26.
|
When a column is hidden, ____.
a. | the letter of the hidden column appears in the formula bar | b. | the column before
the hidden column is in light blue and the column header is bolded | c. | the line between the
columns before and after it is thicker than normal | d. | The letter associated with the hidden column is
not shown. |
|
|
|
27.
|
To use Hide & Unhide, choose Home>Cells>Format, and look under ____.
a. | Cell Size | c. | Organize Sheets | b. | Visibility | d. | Background |
|
|
|
28.
|
Changing font color affects ____.
a. | only the tab color of the current worksheet | b. | only the contents of
the currently selected cells | c. | all of the cells in the current
worksheet | d. | all of the worksheets in the current the workbook |
|
|
|
29.
|
Which of the following tools can be used to organize a workbook?
a. | Hiding a worksheet. | c. | Assigning colors to worksheet tabs. | b. | Renaming
worksheets. | d. | All of the
above. |
|
|
|
30.
|
When a worksheet is hidden, ____.
a. | its tab is still visible at the bottom of the workbook | b. | it has been erased
from the workbook | c. | you can use the Unhide Sheet command to make it
visible again | d. | you can click the Select All button to make it visible
again |
|
|
|
31.
|
Which of the following is not a category of options that appears when you
choose Home>Cells>Format?
a. | Cell Size | c. | Font Color | b. | Organize Sheets | d. | Visibility |
|
|
|
32.
|
If you do not want a worksheet’s gridlines to be printed, choose
____.
a. | Page Layout>Sheet Options and deselect Gridlines | b. | View>Show/Hide
and deselect Gridlines | c. | Home>Cells>Format and click
Hide | d. | View>Show/Hide and click Hide |
|
|
|
33.
|
____ alignment lets you align the contents of a cell to its top, center, or
bottom.
a. | Page | c. | Vertical | b. | Horizontal | d. | Gridline |
|
|
|
34.
|
You can hide a worksheet’s column headings by going to the _____ group on
the _____ tab.
a. | Cells; Home | c. | Workbook Views; View | b. | Styles; Home | d. | Show/Hide; View |
|
|
|
35.
|
Which of the following tasks can you perform on the View tab?
a. | Hide a particular row in a worksheet. | b. | Hide a worksheet’s
gridlines. | c. | Hide a particular worksheet in a workbook. | d. | Apply a theme to a
workbook. |
|
|
|
36.
|
If you want a row to be just tall enough so that all of its contents are
visible, ____.
a. | double-click the row heading’s top edge | b. | choose
Home>Alignment>Bottom Align | c. | choose
Home>Alignment>Center | d. | choose AutoFit Row Height in the Format list on
the Home tab |
|
|
|
37.
|
Choose Page Layout>Page Setup>Background to ____.
a. | place a border around an entire worksheet | b. | make the background
of a worksheet a solid color | c. | use the contents of a graphical file as a
worksheet’s background | d. | apply a theme to a
workbook |
|
Matching
|
|
|
Match each item with the correct statement. a. | Style | e. | SmartArt | b. | Background | f. | Vertical alignment | c. | Border | g. | Font
size | d. | Font | h. | Horizontal alignment |
|
|
|
38.
|
Appears behind the information on a worksheet.
|
|
|
39.
|
Examples include Arial and Cambria.
|
|
|
40.
|
A set of formatting traits.
|
|
|
41.
|
Can be used to frame a group of cells.
|
|
|
42.
|
Top-to-bottom placement of contents in a cell.
|
|
|
43.
|
Includes values such as 9, 10, and 16.
|
|
|
44.
|
Side-to-side placement of contents in a cell.
|
|
|
45.
|
Can be used to create diagrams and graphical lists.
|