COMPUTER LIT EXAM 2
header row
A ______ contains column headings or field names in a data source.
font
A ______ is the design of the typeface.
newsgroup and message board
A ______ serves as a discussion site where users can post messages asking for assistance.
tag
A(n) ______ can be added to a message header to alert the recipient about the priority of the message.
absolute
A(n) ______ cell reference does not change when the formula is copied or moved.
Router
A(n) ______ directs the flow of data from a local area network to another network connection.
protocol
A(n) ______ is a description of the rules computers must follow to facilitate device identification and data transfer.
chart
A(n) ______ is a graphic representation of your worksheet data.
spreadsheet
A(n) ______ is a grid of rows and columns into which you enter text and data and numerical data.
Network
A(n) ______ is a group of two or more computers linked together.
operator
A(n) ______ is a symbol that indicates the mathematical operation to perform.
header
A(n) ______ is descriptive text that is printed in the top margin of a worksheet.
hyperlink
A(n) ______ is formatted in a different color with an underline to designate it.
cell
A(n) ______ is the intersection of a single row and a single column.
private
A(n) ______ network limits its accessibility to only authorized users.
animation
Adding a(n) ______ adds special visual or sound effects to text or an object in your presentation.
the equal sign
All Excel formulas begin with ______.
FaceTime
All of the following are examples of Web-based e-mail services EXCEPT: ______.
Notes Page view
Allows you to add speaker notes
crosshair
Amy is new to using Excel and is learning how to enter data. Amy learns that when you point to the fill handle, the pointer changes to a ______.
points
An example of a font size is 12 ______.
status bar
As you enter text in a Word document, the information in the ______ changes to reflect the page number for the current position of the insertion point.
red
As you enter text in a document, _____ wavy lines may appear under words with possible spelling issues.
right
By default, Excel aligns numbers at the ______ of the cell.
one
By default, new blank workbooks include ______ worksheet(s).
Bluetooth
Cable media comes in all of the following types EXCEPT: ______.
Cate has finished entering data and formatting her worksheet, and she is ready to print and share it with others. Cate wants to share her workbook electronically, but she doesn't want the recipients to be able to modify the data. One of her options is to save it as a(n) ______ file.
Entrance effects
Control how the object enters onto the slide
Exit effects
Control how the object leaves the slide
Ctrl+C
Copy
Ctrl+X
Cut
formula
Data entered into a cell is also displayed in the ______ bar.
Emphasis effects
Draw attention to an object that is already visible on the slide
notes
Each ______ page shows an image of a slide, along with the information you entered that goes with that slide.
worksheet
Excel refers to a spreadsheet as a ______.
points
Font size is measured in ______.
complex
Formulas containing more than one operator are called ______ formulas.
Slide Sorter view
Gives you an overall picture of your presentation and enables you to easily add and delete slides
motion path
Greta is enhancing her presentation by adding animations. Greta can customize her animation by creating a(n) ______.
Reading view
Has simple controls that make it easy to review the slides
36
How many points are in a 1/2 inch?
Slide Show
Hyperlinks are only functional in ______ view.
red
If Word cannot find in its dictionary, it will underline the word with a wavy ______ line.
word wrap
If the text you are entering extends beyond the right margin, the ______ feature will automatically move the text to the next line.
all of the above
If you are not sure you want to send an e-mail, which of the following options should you consider before clicking Send?
presentation
In PowerPoint, a document file is called a(n) ______.
Peer-to-peer
In a(n) ______ network, all the connected computers are equal.
semicolon
In the To: text box, a ______ is automatically inserted between each e-mail address.
sizing
In the accompanying figure, the circles and squares at the edges of the graphic are called ______ handles.
credentials
Information that authenticates your identity on a server is known as your ______.
filename
Jeremy is preparing a presentation on e-mail basics to present to his computer club. Jeremy knows that an e-mail address consists of all of the following EXCEPT: ______.
attachment
Jeremy knows that a basic e-mail message should include all of the following EXCEPT: ______.
office
Microsoft provides access to a gallery of clip art files at ______.com.
paper clip
Molly is using Outlook to manage her e-mail messages. Molly receives an e-mail with a(n) ______ icon. She knows this means the message has an attachment.
routers
Most WANs consist of two or more LANs and are connected by ______.
Tab
Move the insertion point to the right one cell
Insert
Nolan is teaching Jessica some basic editing techniques she can use in Microsoft Word. Nolan tells Jessica that by default, Word enters text in a document using ______ mode.
Ctrl
On the Slides tab, to select noncontiguous slides, press and hold ______ while selecting slides.
Backspace
On your PC, the ______ key removes the character to the left of the insertion point.
Ctrl+V
Paste
Page Up
Press ______ to move to the previous slide in the presentation.
Ctrl+A
Select All
Virtual Private Network
Simon is in charge of network security at a medium-sized company. His boss has asked him to give an overview of the company's network security to the board of directors. Simon tells the board that he set up a(n) ______ for employees so they can access work files from home.
IP address
Simon tells the board that all of the employee computers have a unique ______.
transitions
Slide ______ are settings that control how a slide is introduced as you move from one slide to another.
false
T/F 1A is an example of a cell reference.
true
T/F A computer network requires both software and hardware components.
false
T/F A red exclamation mark in an e-mail message list indicated that the sender considers the e-mail spam.
false
T/F A router joins all the devices of a network together.
true
T/F A server can support file sharing.
true
T/F A unique signature can be created for each e-mail account.
false
T/F An attachment consists of text or pictures that you create so Outlook can add it to the end of any outgoing messages.
false
T/F Any attachments should be in the subject line of the e-mail.
false
T/F Drag-and-drop editing can be used to move text, but not to copy text.
false
T/F If you do not use a placeholder, delete it so that it won't show up in Slide Show view.
false
T/F In Excel, a cell's width is automatically adjusted when the font size changes.
false
T/F Microsoft Word allows you to manage your e-mail.
true
T/F Networks can be categorized by type such as LANs or WANs.
true
T/F Notes are not displayed on the side when the presentation is shown in Slide Show view.
true
T/F PowerPoint helps you create, edit, and manipulate professional-looking slides.
true
T/F Press Ctrl+End to move to the last slide in a presentation.
false
T/F Press the down arrow to move to the next screen in a spreadsheet.
true
T/F Protocols ensure that information created by one system can be interpreted and read by another.
true
T/F Selected text will be replaced when any letters or numbers on the keyboard are pressed.
true
T/F Text can be deselected at any time by clicking somewhere in the document window.
false
T/F The Internet is a private network that can only be accessed by users with a passcode.
true
T/F The Ribbon in Excel is similar to the Ribbon used in Word.
true
T/F The content in the Outline tab is automatically updated when new text is added or edited.
false
T/F The default view for a presentation is Outline view.
false
T/F The formula =$A1 contains an absolute reference.
true
T/F The word count, which is a count of the number of words in your document, appears in the status bar.
false
T/F To change chart data in a slide, you must return to Excel, make the changes, and then update your slide.
true
T/F To create a minus sign in a formula, use the hyphen key.
true
T/F To enter data in a cell, you must first make the cell active.
true
T/F To replace, move, copy, or delete text, you need to select it first.
true
T/F To select an entire row, click the row heading.
true
T/F Using the Replace command, you can change occurrences of the same text individually or all at once with the new text indicated.
true
T/F When FW: appears in a recipient's e-mail, he or she knows that the sender has forwarded the message.
true
T/F When additional files are opened on top of the blank default Document1 file during a Word session, they are named Document2, Document3, etc., by default.
true
T/F When creating formulas, there must be a closing parenthesis for every opening parenthesis.
false
T/F When moving a clip art image, the pointer will change to a two-headed arrow.
true
T/F When you add a new column to your spreadsheet, the data shifts to the right.
true
T/F When you crop an image, you remove portions of it permanently.
false
T/F When you send an e-mail, all you need is the first part of the user's e-mail address.
false
T/F When you turn on the Reply All feature, senders will automatically receive a reply when you receive their e-mail.
true
T/F When you use the Cut and Copy commands, the data and formats are also moved or copied.
true
T/F You assign bullets when creating an unordered list.
true
T/F You can add tables and simple charts to illustrate numerical data or trends.
false
T/F You can change the sequence in which a formula is solved by using hyphens.
true
T/F You can copy and paste tables and charts from Word and Excel documents into a slide.
true
T/F You can distribute soft copies of your presentation electronically.
false
T/F You can exit Slide Show view at any time by pressing the Ctrl+End keys.
false
T/F You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.
false
T/F You can only create a hyperlink to text, not a graphic object.
true
T/F You can use the Format Painter feature to copy attributes assigned to a cell.
document
The Ctrl+A keyboard shortcut selects an entire ______.
INSERT
The Hyperlink button is located on the ______ tab.
master
The Slide ______ is the main slide that stores information about the theme and slide layouts of a presentation.
INSERT
The WordArt button is located on the ______ tab.
active
The ______ cell is the cell that is selected.
AutoComplete
The ______ feature displays suggestions that you could perform using a scientific calculator.
clipboard
The ______ is a temporary storage place in the computer's memory.
clipboard
The ______ is a temporary storage place in your computer's memory.
Internet
The ______ is a worldwide system composed of thousands of smaller networks.
slide pane
The ______ is the area in the presentation window that contains the slide content.
Slides tab
The ______ shows a thumbnail for each slide in the presentation file.
sparklines
The accompanying figure shows ______ in column F.
margins
The blank spaces around the edges of the pages are called ______.
Normal view
The default view
Slide Sorter
The figure above shows a presentation in ______ view.
INSERT
The header and footer commands are located on the ______ tab.
Trigger
The instruction that starts the animation segment
value
The text or number you enter in a cell is often referred to as a(n) ______.
Slide Show view
The view you use when you present the show to your audience
?
The wildcard character that searches for a single character is ______.
slide pane
Timothy is new to PowerPoint and is learning about the PowerPoint window. Timothy knows that the ______ includes dotted borders to identify placeholders when you can insert text and graphics.
Name box
Timothy knows that the PowerPoint window includes all of the following elements EXCEPT: ______
normal
To apply a theme, the presentation must be shown in ______ view.
either A or B
To move one cell to the right, press ______.
Home
To move to the first cell in a row, press ______.
clear
To remove the data and the formats from a cell, you need to ______ the cell.
all of the above (an e-mail address, slides in another presentation, slides in the same presentation)
To which of the following can you create a hyperlink in PowerPoint?
$A$1
Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that ______ is an absolute cell reference.
format painter
Using the ______ is a quick and easy way to copy formatting from one paragraph to another.
Motion paths
What an object follows on a slide
edit
When you ______ a document, you change the document by making revisions or corrections.
toggle
When you ______ an option, you alternate between the on and off states.
freeze
When you ______ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.
Document1
When you first start Word, a new blank document appears and is automatically titled ______.
white plus sign
When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a)n ______.
I-beam
When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ______.
hand
When you position the mouse pointer over a hyperlink in Slide Show view, it changes to an) ______ icon.
range
When you select a group of cells, the group is called a(n) ______.
gateway
Which of the following is NOT a classification type for a network?
Use bullets to show the steps in a process or data that should be examined in order.
Which of the following is NOT a design guideline when creating a new presentation?
Press the up arrow key.
Which of the following is NOT a method to advance to the next slide in Slide Show view?
Video
Which of the following is NOT a type of graphic?
Adobe Dreamweaver
Which of the following is NOT a type of server operating system?
hackers
Which of the following is NOT an example of malicious code?
Spin
Which of the following is NOT one of the animation categories?
When entering the cell reference, the column letters must be uppercase.
Which of the following is NOT true about creating formulas?
once set up, a network requires very little ongoing maintenance and management
Which of the following is NOT true about network risks?
Cc is an option to send someone a message without the other recipients knowing
Which of the following is NOT true about sending an e-mail message?
all of the above are true.
Which of the following is true about e-mail addresses?
all of the above are true
Which of the following is true about the benefits of networking?
online conferencing
You can use ______ to conduct a meeting involving yourself and one or more other participants at different sites.
VoIP
You can use ______ to make phone calls with an Internet connection.
You can use ______ to send and receive messages in dynamic, two-way communications.
instant messaging
You can use ______ to send and receive messages in real time.
Pen Options Tool
You can use the ______ to add annotations to a slide.
Statistical
______ formulas perform calculations that describe large quantities of data.
Mathematical
______ formulas perform calculations that you could perform using a scientific calculator.
graphics
______ include shapes, clip art, photographs, WordArt, SmartArt, tables, and charts.
Server
______ operating systems provide network control and include special functions for connecting computers and other devices.
zoom
______ options enable you to increase and decrease the size of text and graphics on the screen.
Print Layout
______ view displays the document on the screen as it will appear when printed.
Draft
______ view shows only the basic document to make editing easier.
Ctrl+Home
moves the insertion point to the beginning of the worksheet
Shift+Tab
moves the insertion point to the left one cell
Up arrow
moves the insertion point to the previous row
Page Up
moves the insertion point to the previous screen
down arrow
to move down one line
ctrl + down arrow
to move down one paragraph
left arrow
to move left one character
right arrow
to move right one character
ctrl + home
to move to the beginning of the document
home
to move to the beginning of the line
ctrl + end
to move to the end of the document
end
to move to the end of the line
page down
to move to the next screen
ctrl + right arrow
to move to the next word
page up
to move to the previous screen
ctrl + left arrow
to move to the previous word
up arrow
to move up one line
ctrl + up arrow
to move up one paragraph
