Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Which application would be used to generate forms, queries, and reports from the
data it stores?
a. | Word | c. | Access | b. | Excel | d. | PowerPoint |
|
|
|
2.
|
Which application would be used to produce letters and résumés?
a. | Word | c. | Access | b. | Excel | d. | PowerPoint |
|
|
|
3.
|
Which application is an e-mail client?
a. | Outlook | c. | Excel | b. | Word | d. | Access |
|
|
|
4.
|
Which application is used to organize, analyze, and chart data?
a. | Outlook | c. | Excel | b. | Word | d. | Access |
|
|
|
5.
|
Which is clicked to expand the window to fill the screen?
a. | Close  | c. | Minimize  | b. | Maximize  | d. | Office Button  |
|
|
|
6.
|
Which is clicked to display a menu of commands for opening, saving, and printing
a document?
a. | Close  | c. | Minimize  | b. | Maximize  | d. | Office Button  |
|
|
|
7.
|
Which interface element displays information about the document?
a. | insertion point | c. | status bar | b. | scroll bar | d. | window corner |
|
|
|
8.
|
Which interface element is used to size the window?
a. | insertion point | c. | status bar | b. | scroll bar | d. | window corner |
|
|
|
9.
|
Which interface element is used to bring unseen parts of the document into
view?
a. | insertion point | c. | status bar | b. | scroll bar | d. | window corner |
|
|
|
10.
|
Which is not an input device?
a. | keyboard | c. | printer | b. | mouse | d. | scanner |
|
|
|
11.
|
Which key is held while pressing a character key to insert uppercase
letters?
a. | Enter | c. | Ctrl | b. | Alt | d. | Shift |
|
|
|
12.
|
Which key is pressed to move the insertion point to the beginning of a line of
text?
a. | End | c. | Delete | b. | Home | d. | Page Up |
|
|
|
13.
|
Which key is pressed to end the current paragraph?
a. | End | c. | Delete | b. | Home | d. | Enter |
|
|
|
14.
|
Pointing to an object and pressing the left mouse button twice is called
a. | pointing. | c. | right-clicking. | b. | double-clicking. | d. | scrolling. |
|
|
|
15.
|
A character can be erased by pressing the
a. | Enter key. | c. | Esc key. | b. | Shift key. | d. | Backspace key. |
|
|
|
16.
|
Which input device is used to select commands and respond to prompts?
a. | scanner | c. | mouse | b. | disk drive | d. | DVD drive |
|
|
|
17.
|
Which is not an input device commonly associated with notebook
computers?
a. | stylus pen | c. | touchpad | b. | trackball | d. | laser printer |
|
|
|
18.
|
Which is not a way to select a command?
a. | click a command | b. | press the command’s access
key | c. | press the Ctrl key | d. | press the command’s keyboard
shortcut |
|
|
|
19.
|
Which is the keyboard shortcut for the Print command?
a. | P | c. | Ctrl+P | b. | Alt+P | d. | Shift+P |
|
|
|
20.
|
Pointing to a button on the toolbar or on the Quick Access Toolbar
a. | displays a menu. | c. | performs an action. | b. | displays a ScreenTip. | d. | moves the insertion
point. |
|
|
|
21.
|
Which is a tab on the Word Ribbon?
a. | Help | c. | Document | b. | Home | d. | Save |
|
|
|
22.
|
The Home tab on
the Word Ribbon contains the
a. | Help
group. | c. | Document
group. | b. | Save group. | d. | Editing group. |
|
|
|
23.
|
Which tab on the Word Ribbon would be considered a contextual tab?
a. | Home | c. | Format | b. | Page Layout | d. | View |
|
|
|
24.
|
To restore a minimized Ribbon
a. | double-click a tab name. | c. | press Shift+R. | b. | press the Alt
key. | d. | point to the
Ribbon. |
|
|
|
25.
|
Which dialog box option allows a value to be typed?
a. | drop-down list | c. | text box | b. | option button | d. | check box |
|
|
|
26.
|
Which key selects the default button in a dialog box?
a. | Alt | c. | Enter | b. | Ctrl | d. | Shift+Enter |
|
|
|
27.
|
Which displays a window with information about using the dialog box?
a. | Close | c. | OK | b. | Help | d. | Cancel |
|
|
|
28.
|
A collection of related data stored on a lasting medium, such as a hard disk, is
called a
a. | file. | c. | letter. | b. | document. | d. | Web page. |
|
|
|
29.
|
Which Save As dialog box element displays the location where the file will be
saved?
a. | File list | c. | Navigation pane | b. | Address bar | d. | File name box |
|
|
|
30.
|
Which Save As dialog box element displays the contents of the current
folder?
a. | File list | c. | Navigation pane | b. | Address bar | d. | File name box |
|
|
|
31.
|
Which Save As dialog box element displays folders and locations available on the
computer?
a. | File list | c. | Navigation pane | b. | Address bar | d. | File name box |
|
|
|
32.
|
An invalid file name contains
a. | numbers. | c. | colons (:). | b. | letters. | d. | spaces. |
|
|
|
33.
|
Which file name is valid?
a. | Cover Letter 1? | b. | Research Notes *2009*02*08 | c. | Chapter 7
Assignment:1 | d. | resume_CISposition |
|
|
|
34.
|
Which extension is added to file names in Word 2007?
a. | .docx | c. | .xlsx | b. | .word | d. | .pdf |
|
|
|
35.
|
Which action removes the document from the application window?
a. | opening a file | c. | quitting an application | b. | closing a
document | d. | saving a
file |
|
|
|
36.
|
Which action removes the application window from the Desktop?
a. | opening a file | c. | quitting an application | b. | closing a
document | d. | saving a
file |
|
|
|
37.
|
Which action transfers a copy of the file contents to the computer’s
memory?
a. | opening a file | c. | quitting an application | b. | closing a
document | d. | saving a
file |
|
|
|
38.
|
A search engine
a. | is an application required to send e-mail messages. | b. | is an application
that searches e-mail attachments for viruses. | c. | is used to locate information on the
Web. | d. | is used to save documents. |
|
|
|
39.
|
Which is used to exclude Web pages in a search?
|
|
|
40.
|
The search criteria florida
–hotel would locate
a. | Web pages with florida and not hotel. | b. | Web pages with both florida and
hotel. | c. | Web pages with florida or hotel. | d. | Web pages with hotel and not
florida. |
|
|
|
41.
|
Microsoft Internet Explorer is a
a. | Web site. | c. | Web browser. | b. | search engine. | d. | Microsoft Office
application. |
|
|
|
42.
|
Which is an operating system feature that allows more than one application to
run at a time?
a. | add-in | c. | pharming | b. | phishing | d. | multitasking |
|
|
|
43.
|
Which is not required to send and receive e-mail messages?
a. | an e-mail address | c. | Internet access | b. | e-mail software | d. | a word
processor |
|
|
|
44.
|
In the e-mail address christina@Lpdatafiles.com,
which part is the user name?
a. | christina | c. | Lpdatafiles | b. | @ | d. | .com |
|
|
|
45.
|
In the e-mail address christina@Lpdatafiles.com,
which part is the domain name?
a. | christina | c. | Lpdatafiles.com | b. | @ | d. | .com |
|
|
|
46.
|
Which type of e-mail server is typically used for outgoing mail?
|
|
|
47.
|
Which refers to using courtesy and professionalism when communicating through
e-mail?
a. | spam | c. | etiquette | b. | phishing | d. | POP3 |
|
|
|
48.
|
Which Mail window pane lists folders where e-mail messages are stored?
a. | Instant Search pane | c. | To-Do Bar | b. | Navigation pane | d. | Reading pane |
|
|
|
49.
|
Which Mail window pane displays the selected message?
a. | Instant Search pane | c. | To-Do Bar | b. | Navigation pane | d. | Reading pane |
|
|
|
50.
|
Which does not display the Address Book when clicked?
|
|
|
51.
|
Which is clicked to select a recipient to receive a copy of the e-mail
message?
|
|
|
52.
|
A file sent along with an e-mail message is called
a. | an attachment. | c. | an insert. | b. | an additional message. | d. | a recipient
file. |
|
|
|
53.
|
Which application is required to view a file in PDF format?
a. | Access | c. | Adobe Reader | b. | Outlook | d. | Internet
Explorer |
|
|
|
54.
|
Which Outlook folder stores unfinished messages that have been automatically
saved by Outlook because they have been left open for a period of time?
a. | Inbox folder | c. | Sent Items folder | b. | Junk E-mail folder | d. | Drafts folder |
|
|
|
55.
|
Which Outlook folder stores messages that have been deleted?
a. | Inbox folder | c. | Deleted Items folder | b. | Junk E-mail folder | d. | Drafts folder |
|
|
|
56.
|
Which Outlook folder stores received messages?
a. | Inbox folder | c. | Sent Items folder | b. | Outbox folder | d. | Drafts folder |
|
|
|
57.
|
Which Mail window pane is used to search messages?
a. | Instant Search pane | c. | To-Do Bar | b. | Navigation pane | d. | Reading pane |
|
|
|
58.
|
Another term for junk e-mail is
a. | add-in. | c. | spam. | b. | POP3. | d. | worm. |
|
|
|
59.
|
Which key is pressed to display the Word Help window?
|
|
|
60.
|
Which application is used to produce professional-looking documents, such as
letters and reports?
a. | Outlook | c. | Excel | b. | Word | d. | Access |
|
|
|
61.
|
Which part of the Word window shows the paper size?
a. | title bar | c. | rulers | b. | insertion point | d. | status bar |
|
|
|
62.
|
In a new Word document, the title bar displays
a. | New. | c. | Book1. | b. | Document1. | d. | Word1. |
|
|
|
63.
|
The process used by Word to determine if the next word will fit on the end of
the current line or if it must go on the next line is called
a. | line length. | c. | editing text. | b. | word wrap. | d. | hyphenation. |
|
|
|
64.
|
To repeat the last action performed, click
a. | Home 
Find. | c. | Redo  . | b. | Home  Again. | d. | Undo  . |
|
|
|
65.
|
To show spaces, tabs, and paragraph characters in a document, click
|
|
|
66.
|
To correct a misspelled word
a. | click Redo 
on the Quick Access Toolbar. | b. | right-click the word, select Ignore Once from the menu, and then retype
the word. | c. | right-click the word and then select the correct spelling from the
menu. | d. | right-click the word and select
Correct Spelling. |
|
|
|
67.
|
To select an entire sentence,
a. | triple-click any word in the sentence. | b. | double-click any word in the
sentence. | c. | press Ctrl and click anywhere in the sentence. | d. | press Shift and
click anywhere in the sentence. |
|
|
|
68.
|
To select text
a. | single-click anywhere in the text. | b. | drag the pointer over the
text. | c. | place the insertion point in the text and press the F9 key twice. | d. | click Home  Select
Text. |
|
|
|
69.
|
Moving selected text using Home
 Cut and Home  Pastea. | cuts the selected text and pastes it in at least two new
locations. | b. | leaves the selected text and pastes a copy at the end of the
document. | c. | has the same results as using Home
 Copy and Home  Paste. | d. | cuts the selected text and pastes a copy into
another place in the document. |
|
|
|
70.
|
Select text and then click Home
 Copy to a. | place a copy of the selected text on the Clipboard. | b. | place a copy of the
selected text at the insertion point. | c. | delete the selected text. | d. | display a dialog box
asking how many copies to place at the insertion point. |
|
|
|
71.
|
The first step in duplicating text is to
a. | click Home 
Paste. | c. | select the text to be duplicated. | b. | delete the text. | d. | click Home 
Cut. |
|
|
|
72.
|
When finding text with the Find and Replace dialog box, the search starts from
the
a. | beginning of the document. | b. | position of the insertion
point. | c. | beginning of the paragraph containing the insertion point. | d. | end of the
document. |
|
|
|
73.
|
If Match case is
selected in the Find and Replace dialog box and the search text is West,
which word will not be found?
a. | West | c. | western | b. | UniWest | d. | Western |
|
|
|
74.
|
Which word will not be found using the search text
side?
a. | roadside | c. | Sidewalk | b. | insidious | d. | insider |
|
|
|
75.
|
The way in which a character is emphasized is called its
a. | font. | c. | shape. | b. | size. | d. | style. |
|
|
|
76.
|
The size of text is measured in
a. | centimeters. | c. | inches. | b. | fonts. | d. | points. |
|
|
|
77.
|
Formatting text in a different font changes the
a. | shape of characters. | c. | characters to subscript. | b. | alignment of
text. | d. | color of
characters. |
|
|
|
78.
|
Superscript is a format that
a. | reduces the size of the text and raises it to the top of the current
line. | b. | reduces the size of the text and lowers it to the bottom of the current
line. | c. | enlarges the size of the text and raises it to the top of the current
line. | d. | enlarges the size of the text and lowers it to the bottom of the current
line. |
|
|
|
79.
|
Subscript is a format that
a. | reduces the size of the text and raises it to the top of the current
line. | b. | reduces the size of the text and lowers it to the bottom of the current
line. | c. | enlarges the size of the text and raises it to the top of the current
line. | d. | enlarges the size of the text and lowers it to the bottom of the current
line. |
|
|
|
80.
|
The first step in formatting a word as bold is to
a. | select the word. | b. | click Home  Bold. | c. | place the insertion
point to the left of the word. | d. | place the insertion point in the middle of the
word. |
|
|
|
81.
|
Which is not a way to format selected characters?
a. | use the Mini toolbar | b. | click options in the Font group on the Home tab | c. | use options in the Office Button
menu | d. | use the Font dialog box |
|
|
|
82.
|
A document can be previewed to
a. | see how the document will appear when printed. | b. | display the Mini
toolbar. | c. | display the Print dialog box. | d. | display the Format tab. |
|
|
|
83.
|
A paragraph that is left aligned
a. | is positioned equally distant from the left and right sides of the
page. | b. | has a jagged left edge and a straight right edge. | c. | has straight edges
at both sides of the paragraph. | d. | has a straight left edge and a jagged right
edge. |
|
|
|
84.
|
A paragraph that is right aligned
a. | is positioned equally distant from the left and right sides of the
page. | b. | has a jagged left edge and a straight right edge. | c. | has straight edges
at both sides of the paragraph. | d. | has a straight left edge and a jagged right
edge. |
|
|
|
85.
|
A paragraph that is center aligned
a. | is positioned equally distant from the left and right sides of the
page. | b. | has a jagged left edge and a straight right edge. | c. | has straight edges
at both sides of the paragraph. | d. | has a straight left edge and a jagged right
edge. |
|
|
|
86.
|
A hyperlink can be followed in Word by clicking the link while holding down
the
a. | Alt key. | c. | Esc key. | b. | Ctrl key. | d. | Shift key. |
|
|
|
87.
|
In Word, the thesaurus can be used to
a. | create a new document with alternate words. | b. | check the grammar of
a selected phrase. | c. | display a list of synonyms for a selected
word. | d. | check the spelling of a selected word. |
|
|
|
88.
|
A synonym for sleep is
a. | alert. | c. | nap. | b. | aware. | d. | slope. |
|
|
|
89.
|
Where are thesaurus results displayed?
a. | in the document | c. | in the Save As dialog box | b. | in the Research task
pane | d. | in a
comment |
|
|
|
90.
|
Which feature in Word allows changes to a document to be recorded so that the
original author can later decide which changes to keep?
a. | automatic formatting of hyperlinks | b. | built-in thesaurus | c. | track changes
feature | d. | document review feature |
|
|
|
91.
|
Which Word feature is not directly related to document
collaboration?
a. | restricting changes | c. | adding comments | b. | tracking changes | d. | inserting special
characters |
|
|
|
92.
|
Margins are
a. | the white region around the text on a page. | b. | located every
0.5" on the ruler. | c. | a paragraph format. | d. | the text on a
page. |
|
|
|
93.
|
Setting an indent affects
a. | only the paragraph that contains the insertion point. | b. | the entire
document. | c. | only the displayed page. | d. | only the sentence that contains the insertion
point. |
|
|
|
94.
|
The default formatting for a paragraph is
a. | no space before and no space after. | b. | no space before and 10 points of space
after. | c. | 10 points of space before and 10 points of space after. | d. | 12 points of space
before and 12 points of space after. |
|
|
|
95.
|
The default line spacing for a paragraph is
a. | 1 line of space. | c. | 1.5 lines of space. | b. | 1.15 lines of space. | d. | 2 lines of
space. |
|
|
|
96.
|
To double-space a paragraph, select
|
|
|
97.
|
Which is not a type of tab stop?
a. | Left | c. | Decimal | b. | Right | d. | Justified |
|
|
|
|
|
|
98.
|
Which line of text is aligned according to the tab stops on the ruler
above?
|
|
|
99.
|
To remove an individual tab stop
a. | drag its marker downwards, off the ruler and into the document. | b. | double-click the
marker on the ruler. | c. | select the tab stop in the Tabs dialog box and
then type Delete. | d. | press the Delete
key. |
|
|
|
100.
|
To select a vertical block of text,
a. | hold down the Shift key and drag. | b. | hold down the Caps Lock key and
drag. | c. | hold down the Ctrl key and drag. | d. | hold down the Alt key and
drag. |
|
|
|
101.
|
Which type of indent was used to format the following text?  a. | hanging indent | c. | right indent | b. | first line indent | d. | endnote |
|
|
|
|
|
|
102.
|
Which type and size of indent is illustrated in the graphic above?
a. | first line indent of 0.25" | c. | first line indent of
0.5" | b. | hanging indent of 0.25" | d. | hanging indent of
0.5" |
|
|
|
103.
|
In a four page document, a header appears on
a. | page 1. | c. | page 2 and 4. | b. | all four pages. | d. | page 1 and 3. |
|
|
|
104.
|
A bulleted list should be used when
a. | each item is of equal importance. | b. | cutting and pasting. | c. | a list has more than
two items. | d. | a priority of importance needs to be shown. |
|
|
|
105.
|
A numbered list should be used when
a. | each item is of equal importance. | b. | cutting and pasting. | c. | a list has more than
two items. | d. | a priority of importance needs to be shown. |
|
|
|
106.
|
An area at the top of a page typically used to include information such as the
page number, file name, or author’s name is called a
a. | bulleted list. | c. | header. | b. | footer. | d. | template. |
|
|
|
107.
|
An area at the bottom of a page typically used to include information such as
the page number, date, or author’s name is called a
a. | bulleted list. | c. | header. | b. | footer. | d. | template. |
|
|
|
108.
|
Which would be the best keyword(s) to type in the Search for box in the Clip Art task pane
when searching for clip art that looks similar to:  a. | clip art | c. | butterfly | b. | computer | d. | graphics |
|
|
|
109.
|
To delete a selected graphic,
a. | press the Enter key. | c. | click Home  Delete. | b. | press the Delete key. | d. | drag it off the
document. |
|
|
|
110.
|
Which button is used to trim away areas of a graphic?
a. | Picture | c. | Crop | b. | Picture Border | d. | Reset Picture |
|
|
|
111.
|
Which button is used to adjust the difference between the lightest and darkest
areas in a graphic?
a. | Picture
Border | c. | Crop | b. | Contrast | d. | Brightness |
|
|
|
112.
|
Which button is used to add effects such as bevels to a graphic?
a. | Border | c. | Picture Border | b. | Picture Shape | d. | Picture Effects |
|
|
|
113.
|
To insert a page break, press
a. | Shift+Enter. | c. | Alt+Enter. | b. | Ctrl+Enter. | d. | Shift+Page
Down. |
|
|
|
114.
|
To delete a footnote,
a. | click Home 
Delete. | b. | click Home  Delete
Footnote. | c. | delete the footnote number in the
text. | d. | delete the first word in the footnote reference at the bottom of the
page. |
|
|
|
115.
|
A master document that includes the basic elements for a particular type of
document is called a
a. | master. | c. | file. | b. | basic document. | d. | template. |
|
|
|
116.
|
Which file name extension is added when a Word document is saved as a
template?
a. | .webx | c. | .html | b. | .dotx | d. | .mhtl |
|
|
|
117.
|
Which file name extension is added when a Word document is saved as a Single File Web Page?
a. | .webx | c. | .htm | b. | .docx | d. | .mht |
|
|
|
118.
|
Which Word view is used to display a document saved as a Web page?
a. | HTML | c. | Full Screen Reading | b. | Normal | d. | Web Layout |
|
|
|
119.
|
A named set of formats is called a
a. | table. | c. | style. | b. | section. | d. | label. |
|
|
|
120.
|
Titles that are often bold and in a larger and different font than the body text
are called
a. | sections. | c. | headings. | b. | styles. | d. | formatted
titles. |
|
|
|
121.
|
Clicking Home 
Change Style  Style Seta. | displays the Quick Styles gallery. | b. | clears the formatting of the current
paragraph. | c. | displays a list of style sets. | d. | creates a new
style. |
|
|
|
122.
|
The intersection of a row and a column in a table is called
a. | a meeting point. | c. | an insertion point. | b. | a cell. | d. | a row
intersection. |
|
|
|
|
|
|
123.
|
How many rows and columns are in the table
above? a. | 3 rows, 3 columns | c. | 4 rows, 3 columns | b. | 3 rows, 4 columns | d. | 4 rows, 4
columns |
|
|
|
124.
|
If the insertion point is in the first cell of a table with 3 rows and 4
columns, pressing the Tab key
a. | moves the insertion point to the next cell in the same row. | b. | moves the insertion
point to the next cell in the same column. | c. | moves the insertion point outside the
table. | d. | inserts a tab in the cell. |
|
|
|
125.
|
A table can be created from text that is separated by
a. | spaces. | c. | paragraphs. | b. | tabs. | d. | page breaks. |
|
|
|
126.
|
To select an entire table
a. | point to the left edge of a cell, and then click. | b. | point to the left of
a row, and then click. | c. | point to the top of a column, and then
click. | d. | click  . |
|
|
|
127.
|
Double-click the boundary between two columns in a table to
a. | select the two columns. | b. | delete the two columns. | c. | change the column to
the right so that it is just wide enough to display the data entirely. | d. | change the column to
the left so that it is just wide enough to display the data entirely. |
|
|
|
|
|
|
128.
|
The images above are examples of
a. | table styles. | c. | table of contents styles. | b. | Outline
views. | d. | SmartArt
graphics. |
|
|
|
|
|
|
129.
|
Which formula was used in the table above to calculate the total
calories?
a. | =AVERAGE(ABOVE) | c. | =SUM(ABOVE) | b. | =AVERAGE(LEFT) | d. | =SUM(LEFT) |
|
|
|
130.
|
A list of headings and corresponding page numbers in a document is called
a
a. | table of contents. | c. | format. | b. | style. | d. | table. |
|
|
|
131.
|
To update a table of contents,
a. | save the document. | b. | press the Enter key. | c. | press the F9
key. | d. | display the document in Outline view. |
|
|
|
132.
|
Before Word can create a table of contents
a. | styles must be applied to the headings. | b. | the document must be
displayed in Outline view. | c. | the document must be
printed. | d. | the document must contain at least 20 pages. |
|
|
|
133.
|
What is added to a document so that parts of it can have different page formats
applied?
a. | a page break | c. | a section break | b. | an indent | d. | a style |
|
|
|
134.
|
A Continuous
section break
a. | continues the same section of a document on the next page. | b. | ends a section and
starts a new section on a new page. | c. | ends a section and starts a new section on the
same page. | d. | continues the same section of a document on the same
page. |
|
|
|
135.
|
A Next Page
section break
a. | continues the same section on the next page. | b. | ends a section and
starts a new section on a new page. | c. | ends a section and starts a new section on the
same page. | d. | continues the same section on the same page. |
|
|
|
136.
|
Information that comes before the body of a report, such as the title page, is
called
a. | end matter. | c. | the table of contents. | b. | front
matter. | d. | the
body. |
|
|
|
137.
|
The information in a report is called
a. | end matter. | c. | the table of contents. | b. | front
matter. | d. | the
body. |
|
|
|
138.
|
Which view displays the organization of a document?
a. | Page Layout view | c. | Outline view | b. | Web Layout view | d. | Normal view |
|
|
|
139.
|
What does Outline view use to determine heading levels and body text?
a. | paragraphs | c. | indents | b. | formats | d. | styles |
|
|
|
140.
|
A list of the sources cited and consulted in preparation of a document is
called
a. | front matter. | c. | a bibliography. | b. | a table of contents. | d. | a citation. |
|
|
|
141.
|
What is used within a document to refer to bibliographic entries?
a. | front matter | c. | bibliography | b. | table of contents | d. | citation |
|
|
|
142.
|
Which SmartArt graphic layout would be used for an organization chart?
a. | Cycle | c. | Hierarchy | b. | Matrix | d. | Process |
|
|
|
143.
|
Which SmartArt graphic layout would be used for a timeline?
a. | Cycle | c. | Hierarchy | b. | Matrix | d. | Process |
|
|
|
144.
|
Which icon represents the SmartArt graphic layout Process?
|
|
|
145.
|
Which icon represents the SmartArt graphic layout Cycle?
|
|
|
146.
|
What do newspapers and magazines use to make lines of text easier to
read?
a. | italic style | c. | columns | b. | section breaks | d. | 8 pt font |
|
|
|
147.
|
Which is an object that can be moved and sized like a graphic but contains
text?
a. | style | c. | column | b. | section | d. | text box |
|
|
|
148.
|
Which is not a common element in a newsletter?
a. | headline | c. | nameplate | b. | byline | d. | an outline |
|
|
|
149.
|
The area at the top page of the first page of a newsletter is called the
a. | headline. | c. | nameplate. | b. | byline. | d. | an outline. |
|
|
|
150.
|
The area that contains the publisher’s contact information in a newsletter
is called the
a. | masthead. | c. | nameplate. | b. | byline. | d. | an outline. |
|
|
|
151.
|
Which is used in a newsletter to allow for different formats?
a. | tabs | c. | indents | b. | tables | d. | sections |
|
|
|
152.
|
How many worksheets are in a new workbook?
|
|
|
153.
|
The intersection of a row and column is a
a. | label. | c. | cell. | b. | value. | d. | sheet tab. |
|
|
|
154.
|
Which of the following is an example of a cell reference?
|
|
|
155.
|
The sheet tabs are used to
a. | display the contents of the active cell. | b. | display the
worksheets in a workbook. | c. | identify a single cell. | d. | create a new
workbook. |
|
|
|
156.
|
Which is not a category of worksheet data?
a. | label | c. | value | b. | date/time | d. | calculations |
|
|
|
157.
|
Which key cancels data entry and restores the original contents of the
cell?
a. | the Enter key | c. | the right-arrow key | b. | the Tab key | d. | the Esc key |
|
|
|
158.
|
Which key enters data and makes the next cell in the column active?
a. | the Enter key | c. | the right-arrow key | b. | the Tab key | d. | the Esc key |
|
|
|
159.
|
When the pointer is moved onto the worksheet, it changes to
|
|
|
160.
|
Which number format displays values with a dollar sign aligned at the left edge
of the cell and two decimal places?
a. | Accounting | c. | Number | b. | Currency | d. | Percentage |
|
|
|
161.
|
Which number format displays values as a percentage with two decimal
places?
a. | Accounting | c. | Number | b. | General | d. | Percentage |
|
|
|
162.
|
Which number format displays numbers the way they are typed?
a. | Accounting | c. | Number | b. | General | d. | Percentage |
|
|
|
163.
|
Number signs (####) displayed in a cell indicate
a. | number signs have been typed as a column title. | b. | the cell is not wide
enough to display the formatted number. | c. | an incorrect format has been
applied. | d. | the Number format has
been applied. |
|
|
|
164.
|
To select the entire worksheet
a. | click the Select All button. | b. | press the Worksheet button. | c. | press
Ctrl+End. | d. | drag the pointer from cell A1 to cell A1048576. |
|
|
|
165.
|
A variety of cell styles is associated with a
a. | cell reference. | c. | template. | b. | theme. | d. | formula. |
|
|
|
166.
|
Which theme is applied to a new workbook?
a. | Apex | c. | Office | b. | Equity | d. | Trek |
|
|
|
167.
|
Which view should be used when preparing a worksheet for printing?
a. | Normal view | c. | Web Layout view | b. | Page Layout view | d. | Outline view |
|
|
|
168.
|
Which view is a worksheet displayed in when a header is inserted?
a. | Normal view | c. | Page Break Preview view | b. | Page Layout
view | d. | Web Layout
view |
|
|
|
Assume cell C8 stores a value of 3 and cell D9
stores a value of 2.
|
|
|
169.
|
What will be displayed when the formula =2*C8+3*D9 is
entered?
a. | 18 | c. | #DIV/O! | b. | 2*C8+3*D9 | d. | 12 |
|
|
|
170.
|
What will be displayed when the formula =C8+D9/0 is
entered?
|
|
|
171.
|
Pressing Ctrl+`
a. | displays the formulas stored in cells. | b. | formats the active cell as
currency. | c. | selects the row that contains the active cell. | d. | enters a modified
formula. |
|
|
|
172.
|
Which key removes the dashed border around copied cells?
a. | the Esc key | c. | the Alt key | b. | the Ctrl key | d. | the Tab key |
|
|
|
173.
|
When moving a range of cells, what needs to be selected before Paste is selected?
a. | cell A1 | b. | the Esc key | c. | a new range of
cells | d. | the upper-left cell of the range where the data is to be
pasted |
|
|
|
174.
|
The Fill handle is
a. | used to change the color of a cell. | b. | used to copy the contents of the selected cell
to adjacent cells. | c. | an icon used to scroll a
worksheet. | d. | a cell representing a column of labels. |
|
|
|
175.
|
Cell references that reflect the row or column they have been copied to are
called
a. | absolute cell references. | c. | copied cell
references. | b. | reflective cell references. | d. | relative cell references. |
|
|
|
176.
|
Data from Word can be copied to an Excel worksheet
a. | only if it contains numeric data. | b. | if it is formatted in
paragraphs. | c. | if it is organized in a table or aligned with tabs and tab stops. | d. | if it is all
uppercase letters. |
|
|
|
177.
|
What appears in the Subject
box when a worksheet is e-mailed from Excel?
a. | the recipient’s name | c. | Attachment | b. | the file name | d. | Excel
|
|
|
|
178.
|
A triangle in the upper-left corner of a cell indicates
a. | the cell has been modified while changes are being tracked. | b. | the worksheet has
been e-mailed. | c. | the cell is a hyperlink. | d. | the cell contents are on the
Clipboard. |
|
|
|
179.
|
Which type of application is required to view an HTML file?
a. | a word processor | c. | a browser | b. | a spreadsheet application | d. | a personal information
manager |
|
|
|
180.
|
Which file name extension is added when an Excel workbook is saved as a Single File Web Page?
a. | .webx | c. | .htm | b. | .xlsx | d. | .mht |
|
|
|
181.
|
A master worksheet that includes the basic elements for a particular type of
worksheet is called
a. | a master. | c. | a basic worksheet. | b. | an HTML workbook. | d. | a template. |
|
|
|
182.
|
What will the formula =SUM(A1:A10) change to if row 3
is deleted?
a. | it will not change | c. | =SUM(A1:A9) | b. | =SUM(B1:B10) | d. | =SUM(A1:A11) |
|
|
|
183.
|
A function performs a calculation that results in
a. | a cell reference. | c. | a range of values. | b. | a label. | d. | a single value. |
|
|
|
184.
|
A technique in which a cell is clicked to place its reference in a formula is
called
a. | selecting. | c. | formula fill. | b. | pointing. | d. | cell
referencing. |
|
|
|
|
|
|
185.
|
Using the data in the worksheet above, what will be displayed by the
formula =MAX(A2:B3)?
|
|
|
186.
|
Using the data in the worksheet above, what will be displayed by the
formula =MIN(A1:B3)?
|
|
|
187.
|
Using the data in the worksheet above, what will be displayed by the
formula =SUM(A1:A3)?
|
|
|
188.
|
Using the data in the worksheet above, what will be displayed by the
formula =SUM(B1:B3)?
|
|
|
189.
|
Using the data in the worksheet above, what will be displayed by the
formula =MIN(B1:B3)?
|
|
|
190.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(B1<>B2,0,–5)?
|
|
|
191.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(A1<MIN(B1:B3),1,A1)?
|
|
|
192.
|
A cell reference that does not change when it is copied is called a(n)
a. | status reference. | c. | absolute cell reference. | b. | relative cell
reference. | d. | currency
reference. |
|
|
|
193.
|
Which key can be used to create an absolute cell reference?
|
|
|
194.
|
What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to cell C7?
a. | =B6*$B$1 | c. | =B7*$B$1 | b. | =B7*$B$2 | d. | =C6*$B$1 |
|
|
|
195.
|
To enter a function into a formula without typing,
a. | click a button in the Function
Library group on the Formulas tab. | b. | double-click a cell. | c. | select the function
from Function Styles gallery. | d. | use the name
box. |
|
|
|
196.
|
Which error value indicates the formula is trying to divide by zero?
a. | #DIV/0! | c. | #NUM | b. | #REF | d. | #### |
|
|
|
197.
|
Which error value indicates the formula contains a reference that is not
valid?
a. | #DIV/0! | c. | #NUM | b. | #REF | d. | #### |
|
|
|
198.
|
Which Error Checking option is selected to remove a green triangle from a
cell?
a. | Remove
Triangle | c. | Delete
Error | b. | Ignore Error | d. | Correct All |
|
|
|
199.
|
What will be displayed by the formula =ROUND(C2, 0)
if the number 21.2534 is stored in C2?
a. | 22 | c. | 21 | b. | =ROUND(C2,0) | d. | 21.25 |
|
|
|
200.
|
What will be displayed by the formula
=ROUND(43.92,-1)?
a. | 43.9 | c. | 40 | b. | =ROUND(43.92,-1) | d. | #REF |
|
|
|
201.
|
What will be displayed by the formula
=ROUND(93.99,-2)?
|
|
|
202.
|
The first step when sorting data in a worksheet is to
a. | click Data  Sort
A to Z  . | c. | select the range to
sort. | b. | click Data  Sort
Z to A  . | d. | select the entire
workbook. |
|
|
|
203.
|
The worksheet data below has been sorted in ascending order. Which column was
the key sort column when the data was sorted?  a. | column A | c. | column C | b. | column B | d. | Inventory |
|
|
|
204.
|
How many arguments does the IF function have?
|
|
|
205.
|
What will be displayed by the formula =IF("blue"<"green","sky","water")?
a. | sky | c. | blue | b. | water | d. | #DIV/O! |
|
|
|
Assume cell A1 stores a value of 5 and cell B1
stores a value of 10.
|
|
|
206.
|
What will be displayed by the formula
=IF(A1=B1,A1,"no")?
|
|
|
207.
|
What will be displayed by the formula
=IF(A1<B1,"yes","no")?
a. | yes | c. | yes no | b. | no | d. | #VALUE |
|
|
|
208.
|
Printing a worksheet in landscape orientation
a. | changes the order of the rows in the worksheet. | b. | fits more columns
and fewer rows on a page. | c. | fits more rows and fewer columns on a
page. | d. | prints the worksheet on both sides of the paper. |
|
|
|
209.
|
What can be used to control how a worksheet is divided into pages?
a. | page breaks | c. | rows | b. | columns | d. | functions |
|
|
|
210.
|
Page Layout 
Print Area  Set Print Area is used to
a. | freeze selected rows and columns. | b. | print only cells containing
formulas. | c. | print a selected part of a worksheet. | d. | print only cells containing
values. |
|
|
|
211.
|
Which formula calculates the monthly payment for a $5,000 loan taken out for 3
years at 7% interest?
a. | =PMT(7%/12, 3, 5000) | b. | =PMT(7%/12, 36, –5000) | c. | =PMT(–5000, 7%/12,
3) | d. | =PMT(–5000, 7%,
3/12) |
|
|
|
212.
|
To make a sheet active,
a. | select the sheet name on the Home tab. | b. | click the appropriate tab at the bottom of the
Excel window. | c. | click the name box until it displays the appropriate sheet. | d. | select the sheet
name on the View
tab. |
|
|
|
213.
|
Sheet order can be changed by
a. | clicking the Insert
Worksheet tab. | b. | dragging a sheet tab to a new
location. | c. | right-clicking a sheet tab and typing a new number for the sheet. | d. | using Home  Cut and Home  Paste. |
|
|
|
214.
|
Changing the data on one sheet automatically updates the data on the other sheet
when the cells are
a. | upgraded. | c. | linked. | b. | pasted. | d. | copied. |
|
|
|
215.
|
When moving a range of cells between sheets, what needs to be selected
before Home 
Paste is clicked? a. | cell A1 | b. | the Esc key | c. | a new range of
cells | d. | the upper-left cell of the range where the data is to be
pasted |
|
|
|
216.
|
Which key removes the dashed border around copied cells?
a. | the Esc key | c. | the Alt key | b. | the Ctrl key | d. | the Tab key |
|
|
|
217.
|
“What-If?” questions are answered by
a. | changing values and noting the results. | b. | inserting a series
of blank columns. | c. | using the IF function. | d. | changing the
formatting and noting the results. |
|
|
|
218.
|
Which allows different data sets to be defined and used within the same
worksheet?
a. | absolute references | c. | scenarios | b. | amortization table | d. | multiple sheets |
|