Multiple Choice
Identify the choice that best completes the
statement or answers the question.
|
|
|
1.
|
When you start the Excel program, a new blank
____________ displays. a. | database | c. | workbook | b. | presentation | d. | document |
|
|
|
2.
|
Use the ____________ dialog box to insert a
footer on a chart sheet. a. | Insert | c. | Page Setup | b. | Print Preview | d. | Page Format |
|
|
|
3.
|
The most common type of home network
is: a. | a peer-to-peer (P2P) network | c. | a client/server
network | b. | a WAN | d. | a
token ring LAN |
|
|
|
4.
|
A ____________ allows sharing of a broadband
Internet connection. a. | router | c. | phone cord | b. | hub | d. | HPNA adapter |
|
|
|
5.
|
Which topology is used, most often, as a
peer-to-peer network?
|
|
|
6.
|
Press ____________ to move the active cell one
position to the right. a. | Shift + Enter | c. | Enter | b. | Shift + Tab | d. | Tab |
|
|
|
7.
|
In performing calculations, ____________ are
processed first. a. | expressions within parentheses | c. | addition and
subtraction | b. | comparison operators | d. | multiplication and division |
|
|
|
8.
|
When you place the insertion point in the middle
of a word and start typing, the existing text moves to the right to make space for your new
keystrokes. This is an example of ____________ mode. a. | type | c. | edit | b. | overtype | d. | insert |
|
|
|
9.
|
Software that lets you create letters, budgets,
and graphs is called: a. | operating system software | c. | application
software | b. | system software | d. | utility software |
|
|
|
10.
|
Each column in a database is called a
__________. a. | record | c. | field | b. | table | d. | index |
|
|
|
11.
|
The _____________ is used in combination with
other keys to perform shortcuts and special tasks. a. | Control (Ctrl) key | c. | Function key | b. | Alpha key | d. | Windows key |
|
|
|
12.
|
Which file format enables users to share, view,
and print any file?
|
|
|
13.
|
Each row in a database is called a
__________. a. | field | c. | table | b. | record | d. | cell |
|
|
|
14.
|
The base 2 number system is also
called: a. | hexadecimal notation | c. | binary notation | b. | unary notation | d. | decimal
notation |
|
|
|
15.
|
Sophisticated networks generally use which of
the following hardware devices to ease the flow of data packets throughout the network? a. | Firewalls | c. | Routers and switches | b. | USB ports | d. | Network interface cards
(NICs) |
|
|
|
16.
|
To make a cell reference absolute, ____________
are inserted into the cell reference. a. | dollar signs | c. | parenthesis | b. | brackets | d. | exclamation
marks |
|
|
|
17.
|
Which of the following is NOT an example of a
WAN: a. | The computers in a lab at your school connected to the computers in a lab at another
school in your town | c. | A computer at a bank’s main branch connected with a LAN at the bank’s
branch office across town | b. | LANs connected in a single
building | d. | A LAN at the main
university campus connected with a LAN at the university extension
site |
|
|
|
18.
|
A computer network is defined as two or more
computers connected via ____________________ so that they can communicate with each
other. a. | software and hardware | c. | software | b. | the Internet | d. | hardware |
|
|
|
19.
|
Macromedia Dreamweaver is an example
of: a. | desktop publishing software | c. | educational
software | b. | self-hypnosis software | d. | Web page authoring software |
|
|
|
20.
|
The decimal number system uses the
numbers: a. | 0 through 9 | c. | 0 and 1 | b. | 1 and 2 | d. | 1 through 10 |
|
|
|
21.
|
From the Format Cells dialog box, click the
____________ tab in order to wrap text. a. | Alignment | c. | Font | b. | Pattern | d. | Border |
|
|
|
22.
|
Ethernet networks are named for: a. | the type of operating system installed on every node | c. | the type of transmission media
used | b. | the type of NIC installed in every node | d. | the protocol
used |
|
|
|
23.
|
a. | Alternate Load Usage | c. | Arithmetic Logic Unit. | b. | Alter, Load, and
Use | d. | Adding Logic and
Usability |
|
|
|
24.
|
On a column chart, the category labels display
along the ____________ axis.
|
|
|
25.
|
It takes __________ bits to make a
byte.
|
|
|
26.
|
a. | Central Processing Unit | c. | Central Processor for
Users | b. | Computer Processors for Users | d. | Computer Processing
Unit |
|
|
|
27.
|
The base 16 number system is also
called: a. | decimal notation | c. | unary notation | b. | binary notation | d. | hexadecimal
notation |
|
|
|
28.
|
The most popular transmission media option for
wired Ethernet networks is: a. | unshielded twisted-pair cable (UTP) | c. | power-line
cable | b. | coaxial cable | d. | fiber optic cable |
|
|
|
29.
|
You can enter data on several worksheets at the
same time by selecting and ____________ multiple worksheets. a. | joining | c. | grouping | b. | merging | d. | combining |
|
|
|
30.
|
A(n) __________ is found in one of two states,
off or on. a. | binary switch | c. | vacuum tube | b. | integrated circuit | d. | electrical
switch |
|
|
|
31.
|
A ____________ is approximately one billion
bytes. a. | gigabyte | c. | bit | b. | megabyte | d. | kilobyte |
|
|
|
32.
|
The weakest link in any computer security system
is: a. | the network | c. | the operating system | b. | its users | d. | USB ports |
|
|
|
33.
|
To select an entire paragraph, you
can: a. | press [Ctrl] + [A] | c. | double-click. | b. | press
[Ctrl] + [P]. | d. | triple-click |
|
|
|
34.
|
The data transfer rate of a wireless network is
usually measured in:
|
|
|
35.
|
Using 8 bits, the ____________ code can
represent the 26 uppercase letters and the 26 lowercase letters in the English language and
punctuation symbols as well as special characters. a. | ASCII | c. | EBCDIC | b. | hexadecimal | d. | Unicode |
|
|
|
36.
|
The base 10 number system is also
called: a. | hexadecimal notation | c. | binary notation. | b. | unary notation | d. | decimal
notation |
|
|
|
37.
|
The binary number system uses the
numbers: a. | 1 and 2 | c. | 0 and 1 | b. | 0 through 9 | d. | 1 through 10 |
|
|
|
38.
|
Which type of paragraph alignment has the text
aligned on both the left and right margins? a. | Center alignment | c. | Justified alignment | b. | Left alignment | d. | Right alignment |
|
|
|
39.
|
The term bit is short for: a. | binary digit | c. | binary number | b. | megabyte | d. | binary language |
|
|
|
40.
|
The ____________ are the values that an Excel
function uses to perform calculations or operations. a. | numbers | c. | arguments | b. | formulas | d. | criteria |
|
|
|
41.
|
Which transmission media is able to transmit
data the fastest? a. | Fiber optic cable | c. | Wireless | b. | Twisted pair cable | d. | Coaxial cable |
|
|
|
42.
|
A wireless network uses which of the following
as its transmission media? a. | Laser waves | c. | Fiber-optic waves | b. | Sound waves | d. | Radio waves |
|
|
|
43.
|
Which Word screen element displays the location
of margins, indents, columns, and tab stops for the selected paragraph(s)? a. | Ruler | c. | Vertical scroll bar | b. | Status bar | d. | Ribbon |
|
|
|
44.
|
If a home network is connected to the Internet,
which of the following do you need to send data between the home network and the
Internet? a. | A hub | c. | A router | b. | A switch | d. | A cable |
|
|
|
45.
|
The hexadecimal number system uses the
numbers: a. | 0 through 15 | c. | 1 through 10 | b. | 0 through 9 | d. | 0 through 9 and letters
A–F |
|
|
|
46.
|
Devices such as monitors and printers that are
connected to the computer are called: a. | processing devices | c. | input devices | b. | peripheral devices | d. | system devices |
|
|
|
47.
|
The cell address F7 indicates that the
cell: a. | contains a label value of “F7 | c. | s performing a function involving a
variable called “F.” | b. | is at row 7, column F of the
worksheet | d. | is at row F,
column 7 of the worksheet |
|
|
|
48.
|
Public places at which you can wirelessly
connect to the Internet are known as: a. | gateways | c. | hotspots | b. | links | d. | wired spots. |
|
|
|
49.
|
What is the best thing a company can do to
prevent its electronic data from being stolen? a. | Shut off access on computers to flash drives | c. | Disconnect employees’
computers from the Internet | b. | Install hidden cameras | d. | Establish detailed security
policies |
|
|
|
50.
|
In a 64-bit processor, the 64 refers to the
__________ size. a. | letter | c. | word | b. | processor | d. | RAM |
|
|
|
51.
|
a. | are built into the motherboard on each node | c. | enable nodes in a network to
communicate with each other | b. | are always Ethernet NICs | d. | are only necessary on servers in a
client/server network |
|
|
|
52.
|
Network architectures are classified according
to: a. | the way in which they are controlled and the distance between their
nodes | c. | the speed at which the processor runs | b. | the distance between the hub and the
router. | d. | the bandwidth
supplied by the connection |
|
|
|
53.
|
Which of the following is NOT an example of a
network node? a. | A printer | c. | A computer | b. | A modem | d. | An NOS |
|
|
|
54.
|
Which Word screen element displays a list of
commands related to things you can do with a document such as opening, saving, printing, or
sharing? a. | Scroll box | c. | Menu bar | b. | Office button | d. | Ribbon |
|
|
|
55.
|
____________ is used to copy the formatting of
one cell to other cells. a. | Format theme | c. | Fill color | b. | AutoFit | d. | Format Painter |
|
|
|
56.
|
QuickBooks and Peachtree are examples
of: a. | business accounting software. | c. | educational
software | b. | business spreadsheet software | d. | course management
software |
|
|
|
57.
|
All formulas begin with the ____________
sign. a. | = (equal) | c. | – (minus) | b. | + (plus) | d. | * (asterisk |
|
|
|
58.
|
A chart that is displayed as an object within a
worksheet is called a(n): a. | embedded chart | c. | grid chart | b. | chart table | d. | chart sheet |
|
|
|
59.
|
The following are steps in the CPU machine cycle
EXCEPT: a. | store | c. | fetch | b. | generate | d. | decode |
|
|
|
60.
|
In which dialog box are you able to control line
spacing? a. | Formatting | c. | Line | b. | Paragraph | d. | Print |
|