Deck 5: Technology

Question 1

In Microsoft Word, where are margin controls located?

A)Edit
B)Page Setup
C)Auto Format
D)View Normal Layout

Answer 1

Page Setup

Question 2

Which steps would you follow in Microsoft Word to place a picture you have already stored, into a document?

A)Edit-Find-Insert
B)Insert-Picture-From File
C)Tools-Insert-Picture
D)Insert-From File-Image

Answer 2

Insert-Picture-From File

Question 3

Which best describes the icons that appear on a Microsoft Word toolbar for aligning text?

A)The letters L,C,R
B)Series of six horizontal lines
C)Pictures of a page with text
D)Arrows pointing left, right, and up and down

Answer 3

Series of six horizontal lines

Question 4

In a spreadsheet such Microsoft Excel, how can you manipulate data in a column to appear in alphabetical order?

A)Sort descending
B)Sort ascending
C)Sort alpha
D)Sort list

Question 5

Which of the following demonstrates a correctly designed formula for calculating the value of each of a series of cells in one column multiplied together?

A)"=PRODUCT(A1:A9)"
B)"=SUM(A1:C9)"
C)"=AVGA1:A10"
D)"=(COSA1:C10)"

Question 6

Which of the following demonstrates a correctly designed formula for determining the sum of the value of two cells in one row?

A)"=SUM(A1:C1)"
B)"=(A1:C1)"
C)"=(A1+B1)"
D)"=SUMA1+B1"

Question 7

When using a database, communication is done using SQL, which stands for which of the following?

A)Structured Query Language
B)Simple Query Linguistics
C)Storing Quality Language
D)Simplified Quality Logistics

Question 8

When using a database such as Microsoft Access, what character is used to separate words in data labels?

A)/
B)a space
C)_
D)*

Question 9

In Microsoft Word, which of the following functions is not available when right clicking on highlighted text?

A)Copy
B)Paste
C)Save
D)Bullet or number

Question 10

Which of the following electronic extensions for websites and e-mail addresses does not designate a specific type of group or organization?

A).edu
B).gov
C).net
D).co.jp

Question 11

On a basic PC, all drives and files can be accessed through which of the following?

A)Control Panel
B)My Computer
C)Settings
D)Internet Explorer

Question 12

When e-mail correspondence is received, it can be passed on to other e-mail accounts using which of the following functions?

A)Reply
B)Attachment
C)Forward
D)Carbon Copy

Question 13

When sending a file attachment with e-mail correspondence, what is the best way to locate the file?

A)Use the Browse button in the attachment feature and double click the file
B)Use Search from the Start menu and double click the file
C)Use My Computer to locate then copy and paste the attachment into the e-mail body
D)Use My Computer to locate, open, choose send to, and designate the e-mail recipient

Question 14

In Microsoft Excel, multiple spreadsheets together are referred to as which of the following?

A)Workbook
B)Template
C)File
D)Collection

Question 15

When using a word processing program, what is the best way to format information within a document that needs to in organized and aligned in rows and columns?

A)Tables
B)Text boxes
C)Diagrams
D)Databases

Question 16

Which of the following is a port used for transferring data between a computer and other external devices such as cameras and printers?

A)USB
B)Modem
C)CPU
D)Coaxial

Question 17

If a computer application and mouse become frozen, what is the best way to proceed without losing data in other applications that are open?

A)Turn computer off and restart in Safe Mode
B)Press Ctrl-Alt-Del and end the problem application from the task list
C)Disconnect the mouse and reconnect
D)Press F12 and select Troubleshoot

Question 18

In a Microsoft Access database, which of the following is a column on a datasheet that sets aside space for a certain type of data?

A)field
B)key
C)object
D)value

Question 19

Which computer function can be run periodically from System Tools to help your computer run faster and more efficiently?

A)System restore
B)Disk defragmentation
C)Utility manager
D)Disk backup

Question 20

In Microsoft Word, what function does the icon with a picture of a magnifying glass over a piece of paper perform?

A)Zoom in
B)Print preview
C)Spell check
D)Highlight text

Question 21

What is one way to change the name of a document without creating a new or additional document?

A)After opening, choose Save As and type in the new name
B)When the document is open double click on the name at the top of the screen and type in the new name
C)From File choose Open, right click on the file, choose Rename and type in the new name
D)When the document is open from File choose Page Setup, type new name in Document Title bar

Question 22

Which of the following can not be inserted into a Word document?

A)A diagram
B)A . jpg file
C)A video
D)A graph

Question 23

What is the primary usage of a flash drive, also referred to as a jump drive or USB drive?

A)Permanent storage of digital images such as photos
B)Temporary storage of files for transport
C)Large capacity external storage for media files exceeding 2GB
D)Back up of computer hard drive files

Question 24

Which two-key combination allows you to copy highlighted text in most computer applications?

A)Shift-C
B)Control-C
C)Shift-Enter
D)Control-Enter

Question 25

What abbreviation appears next to the bar for inserting functions in a Microsoft Excel spreadsheet?

A)if
B)fun
C)fx
D)fc

Question 26

Which common font is not considered a safe choice for web page browsing?

A)Times New Roman
B)Verdana
C)Arial
D)Papyrus

Question 27

Which is not a method for moving text in a word processing document?

A)Highlight, left click and hold down mouse, drag
B)Highlight, right click, choose cut, insert cursor, right click, choose paste
C)Highlight, click Control-C, insert cursor, click Control-V, delete from original location
D)Highlight, right click and drag, insert cursor, click Insert-Text

Question 28

In a spreadsheet such as Microsoft Excel, what is the command for combining multiple cells?

A)Merge cells
B)Marry cells
C)Format cells
D)Copy cells

Question 29

In Microsoft Excel, what function does SUMIF perform?

A)Addition of all cells
B)Addition of all cells within certain specifications
C)Addition of all cells with positive numbers
D)Addition of all cells in one column

Question 30

What Microsoft Excel action can keep a worksheet's contents from being altered?

A)Protect sheet
B)Share worksheet
C)Data sort
D)Reveal formatting

Question 31

Why should typing in all capital letters be avoided in e-mail communication?

A)It is considered to be shouting
B)It is not grammatically correct
C)It is more difficult for people to read
D)It takes up more space on a server

Question 32

Which of the following cannot be inserted into a spreadsheet?

A)Picture
B)WordArt
C)Diagram or chart
D)PowerPoint presentation

Question 33

What is the name of the location where cut or copied text, images, formulas, and other information can be placed for insertion into a document or spreadsheet at a later point?

A)Folder
B)Clipboard
C)Window
D)Worksheet

Question 34

Databases offer which of the following advantages?

A)Simple format for creating multimedia presentations
B)Organized storage of information for access by multiple users
C)Advanced statistical calculations with minimal human effort
D)Eliminates the need for data entry

Question 35

When sending an e-mail message, the BCC tool does which of the following?

A)Sends the message to the original recipient and copies the message to someone else without the original recipient's knowledge
B)Sends the message to multiple people, all of whom can view the addresses of other people receiving the message
C)Sends the message at a later specified date
D)Sends the message and notifies the sender when the recipient has open it

Question 36

What is an electronic signature in e-mail correspondence?

A)A legally binding agreement to a proposition or contract
B)A path through which sender's and receiver's correspondence can be tracked by authorized personnel
C)Information about the sender that automatically attaches to each e-mail sent
D)The address to which people send your email

Question 37

Google, Alta Vista, and MSN are all examples of which of the following?

A)ISP's
B)Search engines
C)Browsers
D)Network servers

Question 38

Which of the following is not a data entry fields on a typical e-mail form?

A)To
B)Subject
C)CC
D)Date

Question 39

What program is needed to open or read files with a .pdf extension?

A)Microsoft Word
B)Adobe Acrobat
C)Java
D)QuickTime

Question 40

What type of file is followed by a . gif extension?

A)Certain word processing documents
B)Spreadsheets
C)Pictures
D)E-mails