No.
QUESTION
CHOICES
1.
Command Bars in Microsoft Excel 97:
Contain Excel functions and commands
only.
Contain toolbar buttons and menus only
Contain toolbar buttons, menus, AND menu
items
Are customizable by the user.
Can "float" or be docked on
any side of the screen
A and B
C
C, D and E
B and D
A and E
2
In Microsoft Excel, which of the following
References Includes Cell G7
B4:M6
G:G,2:2
M3:GG7
All of the Above
None of the Above
3
In Microsoft Excel, if the name Prices refers
to the areas B1:D4, B2, and E1:E10, then:
AREAS(Prices) equals 2
AREAS(Prices) equals 3
AREAS(Prices) equals 4
AREAS(Prices) equals 5
There is no Areas() function in Excel.
4
In Microsoft Excel, if Cell A1 is formatted
for Time and contains the Time Information "10:00:00
AM", what will be displayed in Cell A2 if its Cell
Formula is: =A1+1 ?
10:00:00
10:00:01
10:01:00
11:00:00
None of the Above
5
In Microsoft Excel, the contents of a cell
can be linked to another cell in:
The same spreadsheet
In another spreadsheet
In another workbook
All of the Above
None of the Above
6
In Microsoft Excel, Headers and Footers may
be included when pages are printed. Where can this Setup information
for Headers and Footers found?
Setup/Preferences Menu Option
Setup/Options Menu Option
Edit/Headers and Footers Menu Option
Tools/Headers and Footers Menu Option
File/Page Setup Menu Option
7
In Microsoft Excel, a range of cells in certain
columns or rows that are printed on every page are referred
to as:
Headers
Footers
Headers and Footers
Titles
None of the Above
8
In Microsoft Excel, which of the following
formulas is incorrect?
=SUM(A1,B1,B2,C2)
=ROUND(SUM(A1:C2),2)
=ROUND(A1:C2,2)
=SUM(ROUND(A1:B1,B2:C2))
All of the Above
9
You have created a document in Microsoft Word
and you want the document to be double spaced. Where would
you look for this setting?
The Format/Paragraph Menu
The File/Page Setup Menu
The Edit/Preferences Menu
The View/Settings Menu
The Format/Page Menu
10
In Microsoft Word, data can be displayed in
rows and columns, just like a spreadsheet. These rows and
columns are called:
Tabbed columns
Chart
Table
Spreadsheet
An Insert
11
Which of the following is NOT an option for
formatting Text in Microsoft Word '97?
Emboss
Engrave
Shadow
3-D
Marching Red Ants
12
You want to keep notes in your Microsoft Word
document about topic references, but you dont want them
to print in the final document. What is the best way to accomplish
this?
Use the Insert/Object/Note Menu item
Write your comments and make the text color white
Use the Insert/Comment Menu Item
Use the Format/Font/Hidden Option
None of the Above
13
Youre writing a standard business letter
in Microsoft Word and want to print an envelope with the recipients
name and address. What is the fastest way to print the envelope?
Use the Tools/Envelopes and Labels Menu Item.
Cut and Paste the name and address information into an envelope
template.
Use a Word Macro to automatically create an Envelope document.
Use the View/Envelope Menu Item
None of the Above
14
Youve inserted a graphic image in your
Microsoft Word document but you want the text to print on
the right side of the graphic. What will you do?
Reformat the paragraph so it is indented far enough to avoid
the graphic.
Put the text in a Text Box next to the graphic so you can
control the text placement.
Use Format/Picture/Wrapping Menu Item
Make the picture smaller so it misses the text.
None of the Above
15
Youre writing a document for your company
in Microsoft Word and want the page Footer to contain different
information beginning on Page 5. What would you need to do
to accomplish this?
Create a Section Break at the bottom of Page 4 and make changes
to the Footer on Page 5
Use the View/Header and Footer Menu Item and change the Footer
on Page 5
Click on the Footer on Page 5 and make the changes.
Any of the above.
None of the above.
16
You use Microsoft Word 97 to develop
documentation for your companys products. The product
name must always be in a special Font. Which is the easiest
way to assure this is done each time the product name is mentioned?
Use search and replace to make the change.
Use the Auto-Correct feature under the Tools Menu
Place the properly formatted name in the clipboard and paste
it each time you need it.
Change the whole document to use the same font so it wont
be an issue.
Use the Insert/Symbol Menu option with the Product Name as
a Symbol.
17
Where do you find the "START" button
in Windows 95/98?
The Start Bar
The Menu Bar
The Icon Bar
The Task Bar
The System Tray
18
When should you use the "Start/Shut Down"
Menu when using Windows 95/98?
Every time before turning the power off to the computer
Only when Windows instructs you to Shut Down or Restart Windows.
Never, except in case of computer problems.
Several times a day.
Only when told to do so by a Systems Administrator.
19
Adding and changing Printer setup information
can be done from the Printers Folder located in the:
Folder Options Menu
Control Panel
Windows 95/98 File/Print Menu
Network Neighborhood
Recycle Bin
20
Where would you normally go to change or add
Internet connections under Windows 95/98?
Dial-Up Networking
Network Neighborhood
Control Panel
Taskbar
None of the Above,
21
Viewing files on your disk drives or on a network
is normally done in Windows 95/95 using:
Internet Explorer
Start/Programs Menu
Windows Outlook Express
Start/Find Menu
Explorer
22
Programs and files on a computer are normally
stored:
In memory
On a CD-ROM Drive
On a Hard Disk Drive
On a Floppy Disk Drive
All of the Above
23
The term "SIMM" refers to:
An Intel Pentium Processor
The Computer's CPU
ISDN Modem
System Bus
Memory
24
Which of the following is NOT a valid computer
hardware term:
Parallel port
Serial port
PSI slot
Serial Mouse
Analog Modem
25
If someones hard disk drive, located
in their computer 100 miles away from your location, appears
as your "F:" Drive, it is because you are connected
to a:
WAN
LAN
BAN
FAN
It is not possible
26
Computer Memory is normally measured in:
Kilobytes
Megabytes
Gigabytes
Terabytes
None of the Above
27
Software that the computer uses to start, or
"boot" is found where:
The Operating System (OS)
File Allocation Table (FAT)
Basic In-Out System (BIOS)
Dynamic Data Exchange (DDE)
Microsoft Windows (WIN)
28
How much information does a High Density 3.5"
disk store?
1.2 MB
1.44 MB
1.6 MB
2.88 MB
1.44 GB
29
A "High Resolution" computer monitor
will have:
High dpi, e.g. .31 dpi
Low dpi, e.g. .26 dpi
256 colors
Resolution isnt measured in dpi or colors
The same resolution as your printer.
30
Which of the following is the correct syntax
for a URL?
john@xyz.com
c:\windows
index.html
aol.com
All of the Above.
31
What type of network connection is NOT a way
of connecting to the Internet?
TCP/IP
Dial-up
ISDN
T1
T3
32
On the Internet, the term "SPAM"
refers to :
Sending E-mail regularly to one person
Difficulty finding information from an Internet Search Engine
Unsolicited bulk E-mail
Service Procedures and Maintenance
None of the Above
33
Which of the following is TRUE about Transmission
Control Protocol/Internet Protocol (TCP/IP) :
It is a collection of protocols, or rules, that govern the
way data travels from one machine to another across networks.
It breaks data up into packets that the network can handle
efficiently.
It verifies that all the packets arrive at their destination
It "reassembles" the data once sent.
All of the Above.
34
The time it takes to load a web page is generally
determined by:
The speed of your computer processor (CPU)
The speed of your modem
The size of your hard drive
The amount of memory in your computer
All of the Above