True/False
Indicate whether the
statement is true or false.
Concepts:
|
|
|
1.
|
The motherboard is a synonym for the main circuit board inside the system
unit.
|
|
|
2.
|
The primary purpose of application software is to help people carry out tasks
using a computer.
|
|
|
3.
|
You must have a static IP address to access the Internet.
|
|
|
4.
|
The major advantage of person-to-person payments is that the payment service is
the only entity that sees your credit card number and therefore can't misuse it or store it on
an unsecured computer.
Excel:
|
|
|
5.
|
The name of the active workbook appears in the status bar of the Excel
window.
|
|
|
6.
|
The AutoComplete feature automatically completes an entry based on previous
entries in a column.
|
|
|
|
|
|
7.
|
Item 1 in the figure above is called the Quick Excel Toolbar and includes
buttons for commonly used commands, such as Save and Undo.
|
|
|
8.
|
Item 2 in the figure above is pointing to the Name box
|
|
|
9.
|
Item 3 in the figure above is called a tab.
|
|
|
10.
|
Item 4 in the figure above is used for selecting all of the contents in the
active worksheet only.
|
|
|
11.
|
Item 5 in the figure above, nicknamed “fx”, is used for adding
special effects to Excel charts.
PowerPoint
|
|
|
12.
|
During a slide show, the audience does not see the contents of the notes
pane.
|
|
|
13.
|
In Slide Sorter view, all slides appear as miniature thumbnails.
|
|
|
14.
|
In Normal view, you can examine the outline of the entire presentation.
|
|
|
15.
|
Slide Sorter view is good for rearranging slides.
|
|
|
16.
|
Speaker notes, or notes, are prepared for the presenter only.
|
|
|
17.
|
The Clip Art task pane includes the ability to search for a specific
picture.
|
|
|
18.
|
When you make changes on the Slide Master, the changes usually take effect on
all the slides in the presentation.
|
|
|
19.
|
You cannot show a PowerPoint presentation on a computer unless PowerPoint has
been installed on the computer.
Word:
|
|
|
20.
|
As you type a document in Word, you must press the Enter key at the end of each
line to activate the word wrap feature.
|
|
|
21.
|
You can save time using the Spelling and Grammar checker since you do not need
to proofread your document.
|
|
|
22.
|
When you paste an item from the Clipboard into a document, the item remains on
the Clipboard so you can paste it again somewhere else if you want.
|
|
|
23.
|
When you double-click the Format Painter button, it stays selected until you
click it again.
|
|
|
24.
|
When using a Numbered list, if you delete a line item, you need to renumber the
items.
|
|
|
25.
|
When sorting a column in a table, the cells in a row move together as one
entity.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the
question.
Concepts:
|
|
|
26.
|
A computer is a device that ____.
a. | accepts data | b. | stores data | c. | produces
output | d. | All of the above |
|
|
|
27.
|
A personal computer that requests data from a server is called a ____.
a. | client | b. | mask | c. | circuit | d. | PDA (Personal Digital
Assistant) |
|
|
|
28.
|
Most computers store data in a(n) ____ format as a series of 1s and 0s.
a. | analog | b. | digital | c. | logical | d. | executable |
|
|
|
29.
|
A(n) ____ system, such as Windows, UNIX, or Mac OS, is essentially the master
controller for all of the activities that take place within a computer.
a. | matrix | b. | operating | c. | control | d. | panel |
|
|
|
30.
|
Every Web page has a unique address called a(n) ____.
a. | HTTP (Hypertext Transfer Protocol) | b. | protocol | c. | URL (Uniform
Resource Locator) | d. | FTP (file Transfer
Protocol) |
|
|
|
31.
|
A(n) ____ is a software program that runs on your computer and helps you access
Web pages.
a. | explorer | b. | browser | c. | navigator | d. | manager |
|
|
|
32.
|
You want to include your boss on a message to your hired freelancer, but do not
want the hired freelancer to see that your boss is included on the message. How can you achieve
this?
a. | Cc: your boss on the message | b. | Bcc: your boss on the
message | c. | add a priority to the message | d. | none of the
above |
|
|
|
33.
|
Your roommate wants to regain peak performance on her disk. You suggest she uses
a(n) _____ utility to rearrange the files on a disk so that they are stored in contiguous
clusters.
a. | application software | b. | defragmentation | c. | file
shredder | d. | operating system |
|
|
|
34.
|
You want a Web site that encrypts data traveling between your computer and an
HTTP server; making your data secure when sent. Look for Web pages that start with ____.
a. | www. | b. | http: | c. | https: | d. | Both b and c |
|
|
|
35.
|
Computers represent numeric data using the ____ number system.
a. | binary | b. | analog | c. | digital | d. | ASCII |
|
|
|
36.
|
The prefix ____ means billion.
a. | giga- | b. | kilo- | c. | tera- | d. | exa- |
|
|
|
37.
|
If a program exceeds the allocated space in RAM, the operating system uses an
area of the hard disk called ____ memory to store parts of a program or data file until they are
needed.
a. | volatile | b. | capacitor | c. | virtual | d. | integrated |
|
|
|
38.
|
The ROM ____ tells the computer how to access the hard disk, find the operating
system, and load it into RAM.
|
|
|
39.
|
Hard disk and tape storage technologies can be classified as ____
storage.
a. | optical | b. | digital | c. | analog | d. | magnetic |
|
|
|
40.
|
____ time is the average time it takes a computer to locate data on the storage
medium and read it.
a. | Identification | b. | Isolation | c. | Access | d. | Find |
|
|
|
41.
|
A ____ operating system provides process and memory management services that
allow two or more programs to run simultaneously.
a. | network | b. | multiuser | c. | pipelined | d. | multitasking |
|
|
|
42.
|
____ is a music compression file format that stores digitized music in such a
way that the sound quality is excellent, but the file size remains relatively small.
|
|
|
43.
|
____ makes the uncompiled program instructions available to programmers who want
to modify and improve the software.
a. | Shareware | b. | Freeware | c. | Open source
software | d. | Public domain software |
|
|
|
44.
|
A file ____ is defined as the arrangement of data in a file and the coding
scheme that is used to represent the data.
a. | schema | b. | native | c. | format | d. | type |
|
|
|
45.
|
An operating system maintains a list of files called a ____ for each storage
disk, tape, CD, or DVD.
a. | chain | b. | table | c. | linked
list | d. | directory |
|
|
|
46.
|
In the file specification, C:\Music\Reggae\Marley One Love.mp3, C is the
_____.
a. | drive letter | b. | primary folder | c. | filename | d. | extension |
|
|
|
47.
|
Windows ____ is a utility program bundled with the Windows operating system that
is designed to help you organize and manipulate the files that are stored on your computer.
a. | Navigator | b. | Explorer | c. | Finder | d. | Browser |
|
|
|
48.
|
A computer ____ is a set of program instructions that attaches itself to a file,
reproduces itself, and spreads to other files.
a. | lurker | b. | virus | c. | horse | d. | worm |
|
|
|
49.
|
A ____ is a computer program that seems to perform one function while actually
doing something else.
a. | boot sector virus | b. | file virus | c. | macro
virus | d. | Trojan horse |
|
|
|
50.
|
Some worms, designed to generate a lot of activity on a network by flooding it
with useless traffic, result in _____.
a. | Halting of Communication attacks | b. | Denial of Service attacks | c. | Overriding Worm
attacks | d. | Flooding Network attacks |
|
|
|
51.
|
The ____ is an important group of files used by the Windows operating system to
store configuration information about all of the devices and software installed on a computer
system.
a. | Index | b. | Setup | c. | Registry | d. | Control Panel |
|
|
|
52.
|
An example of a LAN (Local Area Network) is _____.
a. | a school computer lab | b. | a home network | c. | both a &
b | d. | none of the above |
|
|
|
53.
|
Most wireless LANs transport data as _____ signals.
a. | transponder | b. | satellite | c. | microwave | d. | RF |
|
|
|
54.
|
________ is an example of a high-bandwidth communications system.
a. | DSL | b. | Dial-up | c. | neither of the
above | d. | all of the above |
|
|
|
55.
|
The technology in which a message is divided into several parcels that can be
routed independently to their destination is called ________.
a. | packet switching | b. | handshaking | c. | circuit
switching | d. | protocol |
|
|
|
56.
|
Today’s most popular wireless LAN technology is compatible with Ethernet
and called _____.
a. | Wi-Fi | b. | Bluetooth | c. | HomePNA | d. | None of the
above |
|
|
|
57.
|
____ transfers files between local and remote host computers.
a. | IP (Internet Protocol) | b. | TCP (Transmission control
Protocol) | c. | FTP (File Transfer Protocol) | d. | TELNET (Telecommunication
Network) |
|
|
|
58.
|
Many Internet servers have an easy-to-remember name, such as nike.com. The
official term for this name is _____.
a. | organizational name | b. | domain name | c. | IP
name | d. | none of the above |
|
|
|
59.
|
Which connection is usually too expensive for individuals?
a. | DSL | b. | Cable | c. | T3 | d. | none of the
above |
|
|
|
60.
|
____ is a protocol that works in conjunction with TCP/IP to get Web resources to
your desktop.
|
|
|
61.
|
Web sites use cookies to _____.
a. | monitor your path through a site | b. | gather information that allows a Web server to
present ad banners | c. | collect personal information and retain it for
the next time you visit the Web site | d. | All of the
above |
|
|
|
62.
|
In some of the regions of the world, e-commerce obstacles include _____.
a. | language barriers | b. | economic factors | c. | lack of electrical
service | d. | All of the above |
|
|
|
63.
|
Most shopping carts work because they use ____ to store information about your
activities on a Web site.
a. | packets | b. | cookies | c. | ROM | d. | tags |
|
|
|
64.
|
PayPal is an example of a(n) _____.
a. | certificate authority | b. | authentication agency | c. | person-to-person
payment service | d. | All of the above |
|
|
|
65.
|
When you use a digital camera, your photos are stored as ____ graphics.
a. | vector | b. | 3-D | c. | analog | d. | bitmap |
|
|
|
66.
|
Camera manufacturers sometimes express the resolution of digital cameras as
__________.
a. | gigapixels | b. | megapixels | c. | kilopixels | d. | micropixels |
|
|
|
67.
|
____ graphics are a very popular format for Web graphics, but they are limited
to 256 colors.
|
|
|
68.
|
Images that you intend to post as Web pages should be saved as ____, which can
be opened by today's popular browsers.
a. | GIF | b. | JPEG | c. | PNG | d. | Any of the
above |
|
|
|
69.
|
One clue that an image might be a ____ graphic is a flat, cartoon-like
quality.
a. | bitmap | b. | raster | c. | vector | d. | pixelated
Excel:
|
|
|
|
70.
|
Excel is an electronic version of a(n) ____.
a. | database | c. | expression | b. | spreadsheet | d. | formula |
|
|
|
71.
|
By default, an Excel workbook is made up of ____ worksheets.
|
|
|
72.
|
The intersection of a row and column is known as a ____.
a. | cell | c. | reference | b. | range | d. | border |
|
|
|
73.
|
The characters +, -, *, and / are examples of ____.
a. | formulas | c. | arithmetic operators | b. | values | d. | calculations |
|
|
|
74.
|
The expression used to calculate values displayed in a worksheet is called a(n)
____.
a. | formula | c. | operator | b. | equation | d. | relation |
|
|
|
75.
|
An Excel formula always begins with a(n) ____.
a. | parentheses | c. | plus sign | b. | equals sign | d. | colon |
|
|
|
76.
|
The formula used to multiply cell A1 by cell C1 is ____.
a. | =A1*C1 | c. | =A1/C1 | b. | C1*A1 | d. | A1*C1 |
|
|
|
77.
|
A(n) ____ is a group of cells.
a. | cluster | c. | selection | b. | adjunct | d. | range |
|
|
|
78.
|
____ headings are identified by a number.
a. | Sheet | c. | Row | b. | Workbook | d. | Column |
|
|
|
79.
|
What is the result of the expression =50/(10*5)?
|
|
|
80.
|
To change the order of operations, enclose part of the formula in ____.
a. | brackets | c. | parentheses | b. | italics | d. | quotation marks |
|
|
|
81.
|
What is the syntax for a SUM formula adding the values of Cell F6 to F9?
a. | /SUM(F9:F6) | b. | =SUM(F6/F9) | c. | =END(F6:F9) | d. | =SUM(F6:F9)
PowerPoint:
|
|
|
|
82.
|
When you click the Slide Show button on the status bar, the slide show
starts
beginning with the ____ slide.
a. | first | c. | title | b. | last | d. | current |
|
|
|
83.
|
PowerPoint provides design ____, which are files that contain colors and formats
for the background and the type style for titles, accents, and other text.
a. | masters | c. | templates | b. | slides | d. | codes |
|
|
|
84.
|
After you create a bullet, what do you press to create the next bullet?
____
a. | Enter | c. | the Increase List Level button | b. | Tab | d. | Spacebar |
|
|
|
85.
|
You’re preparing to give a presentation to your class about the research
you’ve done on information technology. You want to provide the audience with paper copies of
your presentation to take with them. However, you do not want to waste paper and would like to
include several slides per page. What can you do? ____
a. | Print handouts of your presentation | b. | Print the Notes pages from your
presentation | c. | Print the Outline view from your presentation | d. | Print Slides of your
presentation |
|
|
|
86.
|
To exit a slide show, press ____.
|
|
|
87.
|
Font size is measured in ____.
a. | inches | c. | picas | b. | points | d. | pixels |
|
|
|
88.
|
To insert slides from another presentation, the first step is to ____.
a. | click Insert on the menu bar and then click Slides from File | b. | go to the slide
after which you want to insert the slides | c. | go to the slide before which you want to insert
the slides | d. | open the Slide Finder dialog box
|
|
|
|
Word:
|
|
|
89.
|
Item 1 in the figure above is a ____.
a. | word wrap symbol | c. | paragraph mark | b. | nonprinting ScreenTip | d. | space mark |
|
|
|
90.
|
Item number 2 in the figure above was created by ____.
a. | the person typing the document | c. | the Insert Date
feature | b. | the AutoComplete feature | d. | the AutoDate feature |
|
|
|
91.
|
Item number 3 in the figure above was created by the ____.
a. | person typing the document | c. | AutoCorrect
feature | b. | AutoComplete feature | d. | AutoDate feature |
|
|
|
92.
|
Item number 4 in the figure above is pointing to the ____.
a. | Quick Access Toolbar | c. | Ribbon | b. | Office Button | d. | Quick Access
Group |
|
|
|
|
|
|
93.
|
Item 1 in the figure above ____.
a. | represents how your document will look when printed | b. | is turned
on | c. | is called Print Layout | d. | all of the
above |
|
|
|
94.
|
The buttons in item 2 of the figure above are called ____ buttons.
a. | Layout | c. | View | b. | Document | d. | Zoom |
|
|
|
95.
|
Item number 3 in the figure above is called the ____.
a. | Zoom Out button | c. | Zoom slider | b. | Zoom In button | d. | Zoom level |
|
|
|
96.
|
Item number 4 in the figure above ____.
a. | changes if item 3 is moved | c. | is also displayed in the document
title bar | b. | can also be found in the Zoom dialog box | d. | both a and b are
correct |
|
|
|
97.
|
The insertion point ____.
a. | is a vertical line | b. | blinks | c. | shows where
characters will appear when you start typing | d. | all of the
above |
|
|
|
98.
|
The Word feature that checks for errors in your document as you type and
automatically corrects common errors is called ____.
a. | AutoText | c. | AutoType | b. | AutoCorrect | d. | Office
Assistant |
|
|
|
99.
|
To reveal a nonprinting character, click the ____ button on the Paragraph
tab.
a. | Reveal Nonprinting | c. | Show/Hide Paragraphs | b. | Show Nonprinting Characters | d. | Display
Characters |
|
|
|
100.
|
The ____ key removes characters to the right of the insertion point.
a. | Backspace | c. | Delete | b. | Esc | d. | End |
|
|
|
101.
|
If rulers are not visible, click the Ruler check box on the ____ tab.
a. | Home | c. | Display | b. | Preview | d. | View |
|
|
|
102.
|
Choosing ____ will skip a currently flagged spelling error but recognize all
future instances.
a. | Change | c. | Ignore Once | b. | Skip | d. | Ignore All |
|
|
|
103.
|
When you move the pointer over the selection bar, it changes to a ____.
a. | cross-hair arrow | c. | left-facing arrow | b. | right-facing arrow | d. | cross bar |
|
|
|
|
|
|
104.
|
To move a paragraph to the left, you would click the button indicated by Item
____ in the above figure.
|
|
|
105.
|
Item 3 in the above figure indicates the ____.
a. | document height | c. | left margin | b. | document width | d. | right margin |
|
|
|
106.
|
Item ____ in the above figures indicates an indented paragraph.
|
|
|
107.
|
Indent markers are show by Item ____ in the above figure.
|
|
|
108.
|
Clicking the button indicated by Item 2 in the above figure would ____.
a. | move the paragraph to the left | c. | move the document to the
right | b. | move the paragraph to the right | d. | move the document to the
left |
|
|
|
109.
|
To remove a hyperlink from a document, right-click the link and then click
____.
a. | Remove Hyperlink | c. | Live Hyperlink | b. | Delete Hyperlink | d. | Rename
Hyperlink |
|
|
|
110.
|
Which of the following is true of Header and Footer view? ____
a. | The document text is dimmed. | c. | You can still edit the main
text. | b. | Special tools appear on the Ribbon. | d. | both a and b |
|