True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
When using in-cell editing, to delete a character or adjacent characters you can
use the mouse to drag through the character or characters and then press the DELETE key or click the
Cut button on the Standard toolbar.
|
|
|
2.
|
Excel can display characters in only three font colors: black, red, and
blue.
|
|
|
3.
|
To display the New Document dialog box, click the Office Button and then click
New.
|
|
|
4.
|
PowerPoint automatically sizes text to fit a placeholder.
|
|
|
5.
|
Word provides an Undo button that can be used to cancel the most recent command
or action.
|
|
|
6.
|
You cannot save PowerPoint 2007 files in previous version formats.
|
|
|
7.
|
A selected graphic can be resized using the Shape Height and Shape Width text
boxes in the Size group on the Format tab in the Picture Tools tab.
|
|
|
8.
|
Text entered in a cell cannot be realigned.
|
|
|
9.
|
To remove a border from a paragraph, position the insertion point in the
paragraph, click the Border button arrow on the Home tab, and then click the No Border button in the
Border gallery.
|
|
|
10.
|
The shortcut keys, CTRL+ENTER, instruct Word to insert an automatic page break
immediately above the insertion point and position the insertion point immediately below the
automatic page break.
|
|
|
11.
|
To import external data from a World Wide Web site, it is necessary to have
access to the Internet.
|
|
|
12.
|
The NOW function is a date and time function.
|
|
|
13.
|
To delete the contents of a cell, select the cell contents by pointing to the
left edge of the cell and clicking when the mouse pointer changes direction, and then press the
DELETE key.
|
|
|
14.
|
In addition to the basic solid underline, Word has many decorative underlines
that are available through the Underline gallery.
|
|
|
15.
|
CTRL+F1 allows you to minimize or maximize the Ribbon.
|
|
|
16.
|
In Word, the default typing mode is overtype mode.
|
|
|
17.
|
The AVERAGE function requires that the argument (the range) be included within
parentheses before the function name.
|
|
|
18.
|
A character is a dot on the screen that contains a color.
|
|
|
19.
|
Graphics and animations, as well as text, can be entered on the Outline tab in
the Normal view.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
Figure 4-2
|
|
|
20.
|
In the accompanying figure, how was the Insert Table dialog box accessed?
a. | by clicking the Insert Table button in the content placeholder | b. | by clicking the
Office Button | c. | by clicking the Insert Object button in the content placeholder | d. | by clicking the Home
tab |
|
|
|
21.
|
Headers print in the top margin ____ inch from the top of every page.
a. | one-quarter | c. | three-quarters of a(n) | b. | one-half | d. | one |
|
|
|
22.
|
If the Picture Tools and Format tabs are active and a graphic is selected, how
do you deselect it?
a. | click the Clear Graphic button on the Picture Tools and Format
tabs | b. | click the Undo button | c. | click Clear on the Picture Tools and Format
tabs | d. | click outside the graphic |
|
|
|
23.
|
The shortcut keys for the _____ character formatting are CTRL+SHIFT+PLUS
SIGN.
a. | underline words, not spaces | c. | case of letters | b. | superscript | d. | all capital letters |
|
|
|
Figure 3-1
|
|
|
24.
|
In the accompanying figure, why did the Format tab appear automatically on the
Ribbon?
a. | it is always available with this particular slide layout | b. | it is always
available on the Ribbon | c. | because the text in the placeholder is
selected | d. | because the placeholder border is selected |
|
|
|
25.
|
The ____ is ideal for returning the worksheet to its original state after you
have changed the values in a worksheet to answer a what-if question.
a. | Undo button | c. | Cut button | b. | Redo button | d. | Copy button |
|
|
|
26.
|
__________ are a collection of worksheets.
a. | Work hours | c. | Booklets | b. | Papers | d. | Workbooks |
|
|
|
27.
|
In addition to creating a series of values, dragging the fill handle instructs
Excel to ____ the format of a cell to a range.
a. | delete | c. | move | b. | copy | d. | cut |
|
|
|
Figure 3-2
|
|
|
28.
|
In the accompanying figure, what is the set of three blue boxes with circles
inside and the arrow across them known as?
a. | Text panes | c. | SmartDesign | b. | SmartArt | d. | WordArt |
|
|
|
29.
|
If you click the Grow Font button too many times and make the font size too big,
you can click the ____ button until the desired font size is displayed.
a. | Reduce Font | c. | Small Font | b. | Shrink Font | d. | Reduce Selected
Text |
|
|
|
30.
|
To change the color of entered text if the Mini toolbar is not displayed, use
the Font Color button arrow on the ____ tab.
a. | Home | c. | Format | b. | Page Layout | d. | References |
|
|
|
Figure 1-5
|
|
|
31.
|
The small squares and circles around a selected graphic, as shown in Figure 1-5,
are called ____ handles.
a. | dimension | c. | shape | b. | base | d. | sizing |
|
|
|
32.
|
Which key on the keyboard toggles between Insert mode and Overtype mode?
a. | Insert | c. | Tab | b. | Enter | d. | Num Lock |
|
|
|
33.
|
Microsoft PowerPoint is a complete _____ program that allows you to produce
professional-looking slide shows.
a. | spreadsheet | c. | personal information management | b. | database | d. | presentation graphics |
|
|
|
34.
|
Most Excel specialists who build Web queries use the worksheet returned from the
Web query as an engine to supply data to another ____ in the workbook.
a. | worksheet | b. | cell | c. | range | d. | dialog box |
|
|
|
Figure 1-1
|
|
|
35.
|
As shown in Figure 1-1, a(n) ____ is a set of choices, often graphical, arranged
in a grid or in a list.
a. | menu | c. | unit | b. | index | d. | gallery |
|
|
|
36.
|
When you complete a copy, the values and formats in the destination area are
replaced with the values and formats of the ____ area.
a. | target | c. | cell | b. | range | d. | source |
|
|
|
37.
|
The person or persons requesting the worksheet should supply their requirements
in a __________ document.
a. | test issues | c. | requirements | b. | blank | d. | certified |
|
|
|
38.
|
To search for a special character, first click the More button in the Find
dialog box and then use the ____ button.
a. | Characters | c. | Special | b. | Options | d. | Advanced |
|
|
|
39.
|
A _____ consists of a group of frequently used styles formatted so they look
pleasing when used together.
a. | style set | c. | font set | b. | format index | d. | color scheme |
|
|
|
40.
|
The ____ of the worksheet shows the actual formulas you have entered, rather
than the resulting values.
a. | Formulas Print symbol | c. | formulas version | b. | Actual symbol | d. | current version |
|
|
|
41.
|
Copying, deleting, inserting, and moving ranges of cells have the potential to
____.
a. | improve consistency of the workbook | c. | improve consistency of the
cells | b. | render a worksheet useless | d. | improve consistency of the worksheet |
|
|
|
Figure 2-1
|
|
|
42.
|
In the accompanying figure, what are the two boxes on the slide known as?
a. | title text placeholders | c. | placeholders | b. | shape
boxes | d. | text
boxes |
|
|
|
43.
|
A __________ is a series of two or more adjacent cells in a column or row or a
rectangular group of cells.
a. | neighbor | c. | nearby cell | b. | range | d. | bunch |
|
|
|
44.
|
A tag name is an identifier that links a(n) ____ to a source.
a. | citation | c. | index | b. | field | d. | attribute |
|
|
|
Figure 4-1
|
|
|
45.
|
In the accompanying figure, what font does the Live Preview show as the body
font?
a. | Georgia | c. | It cannot be determined. | b. | Trebuchet
MS | d. | Urban |
|
|
|
46.
|
The number of worksheets that a workbook can contain is __________.
a. | unlimited | c. | 9,999,999 | b. | limited by computer memory | d. | limited by the number you add to
it |
|
|
|
47.
|
With ____ editing, the selected item is moved to the new location and then
inserted there.
a. | cut-and-paste | c. | inline | b. | copy-and-carry | d. | drag-and-drop |
|
|
|
48.
|
When running a slide show, a ____ appears near your mouse pointer when you
right-click.
a. | Start menu | b. | Microsoft Office submenu | c. | pop-up
menu | d. | Slide Show view menu |
|
|
|
49.
|
The formulas version verifies that you entered formulas, rather than ____, in
formula-based cells.
a. | functions | c. | text | b. | numbers | d. | dollar signs |
|
|
|
Figure 2-2
|
|
|
50.
|
In the accompanying figure, what are the four small slides called?
a. | graphics | c. | images | b. | icons | d. | thumbnails |
|
|
|
51.
|
To select multiple cells, rows, or columns in a table that are not adjacent to
one another, select the first cell and then hold down the ____ key while selecting the next cell,
row, or column.
a. | CTRL | c. | ENTER | b. | ALT | d. | SHIFT |
|
|
|
52.
|
The Copy button copies the contents and format of the source area to the Office
____, a reserved place in the computer’s memory.
a. | Ribbon | c. | Folder | b. | File | d. | Clipboard |
|
|
|
53.
|
_____ are types of changes that occur when text has been omitted from a document
and must be inserted later.
a. | Deletions | c. | Modifications | b. | Additions | d. | All of the
above |
|
|
|
54.
|
Elements such as lines, arrows, callouts, and banners that can be added to a
slide are known as ____.
a. | shapes | c. | symbols | b. | characters | d. | drawings |
|
|
|
55.
|
The _____ feature in PowerPoint allows you to create bulleted lists, combine
words and images, find and replace text, and use multiple fonts and type sizes.
a. | charting | c. | drawing | b. | collaborating | d. | word processing |
|
|
|
56.
|
PowerPoint can produce slides based on an outline created in all of the
following EXCEPT:
a. | Word | c. | a word-processing program | b. | Excel | d. | a Web page |
|
|
|
57.
|
To select a block of text, click at the beginning of the selection, scroll to
the end of the selection, position the mouse pointer at the end of the selection, hold down the _____
key, and then click (or drag through the text).
|
|
|
58.
|
When assigned to a cell, the ____ function returns a number that corresponds to
the system date and time beginning with December 31, 1899.
a. | SYSDATE | c. | DATETIME | b. | NOW | d. | CURRENT |
|
|
|
59.
|
If the top of a set of characters is chopped off, then line spacing may be set
to ____.
a. | About | c. | Near | b. | Cut | d. | Exactly |
|
|
|
60.
|
The ____ is a blinking vertical bar that indicates where text, graphics, and
other items will be inserted.
a. | end mark | c. | insertion point | b. | scroll point | d. | status bar |
|