To open the Navigation Pane, tap or click the ____ Button.
a. Open Navigation Pane
b. Open Pane
c. Shutter Bar Open/Close
d. Navigation Bar Show/Hide
You can nest IF functions as deep as you want, but after you get beyond a nest of three
IF functions, the logic becomes difficult to follow.
a. True
b. False
A background feature called ____ allows you to move the background from the slide
borders in varying distances by a percentage.
a. offsets
b. onsets
c. reduction
d. expansion
A ___ field allows the user to select from a list of values.
a. list
b. lookup
c. combo
d. value
In your encryption algorithm, you removed every third letter. Which algorithm did you
use?
a. substitution
b. transposition
c. expansion
d. compaction
Which of the following is an electronic device, operating under the control of
instructions stored in its own memory, that can accept data, process the data according
to specified rules, produce results, and store the results for future use?
a. input device
b. computer
c. output device
d. both a and c
Which of the following is the path to the Increase or Decrease Indent button?
a. (HOME tab | Clipboard group)
b. (HOME tab | Editing group)
c. (HOME tab | Alignment group)
d. (HOME tab | Number group)
Which of the following best describes e-commerce?
a. a customer (consumer) experience requiring the Internet, cash, a shopping cart, and
videos
b. a business transaction that occurs over an electronic network such as the Internet
c. the sale of electronic goods and services that enable an Internet connection
d. a transaction between two businesses that are bartering and auctioning goods and
services via secure telephonic connections
Green computing involves reducing electricity consumed and environmental waste
generated when using a computer. Which of the following is a valid strategy for
supporting green computing?
a. Buy battery-operated computers only
b. Dispose of replaced computers by selling them on a website
c. Buy a computer from a retailer who will dispose of your old computer properly
d. Replace a computer as soon as a newer, more efficient model is available
Joining tables in a query creates an ad hoc relationship, that is, a relationship between
tables created for a specific purpose.
a. True
b. False
You can use ____ options to repeat a background image many times vertically and
horizontally on a slide.
a. formatting
b. duplicating
c. tiling
d. arranging
Which of the following kinds of players is a program that allows you to view images
and animation, listen to audio, and watch video files on your computer?
a. compression
b. entertainment
c. media
d. video
One effective strategy for creating strong passwords includes changing common words
to symbols.
a. True
b. False
A hot spot is a wireless network that provides Internet connections to mobile computers
and devices.
a. True
b. False
An iCalendar represents a universal calendar format used by several email and calendar
programs.
a. True
b. False
The small squares and circles around a selected graphic are called ____ handles.
a. sizing
b. shape
c. base
d. dimension
A(n) ____________________ conveys a visual representation of data.
Secure sites typically use digital certificates along with security protocols.
a. True
b. False
Online shopping sites generally use a session cookie to keep track of items in a user’s
shopping cart as shown in the accompanying figure.
a. True
b. False
A ____ is a prewritten formula that is built into Excel.
a. function
b. feature
c. task
d. calculation
One study found that a certain percentage of wireless connections like the kind in the
accompanying figure are unsecured, leaving them susceptible to hackers. What was that
percentage?
a. 25
b. 35
c. 55
d. 75
Your browsing history is a list of all websites you have visited over a period of time.
a. True
b. False
Quick Steps allows you to customize email actions that you use most often.
a. True
b. False
Eyestrain associated with CVS is not thought to have serious or long-term
consequences.
a. True
b. False
Which of the following is the term for known specific patterns of viruses?
a. virtual viruses
b. virus traces
c. virus signatures
d. virus items
A ____ is a specific design with coordinating colors, fonts, and special effects.
a. placeholder
b. slide show
c. chart
d. document theme
What is the term for an electronic document on the web that can contain text, graphics,
animation, audio (sound), and video?
a. webpage
b. webnet
c. web reader
d. web host
A requirements document includes a needs statement, source of data, summary of
calculations, and any other special requirements for a worksheet.
a. True
b. False
Which of the following kinds of UPS runs off a battery?
a. offline UPS
b. UPS utility
c. standby UPS
d. online UPS
Which of the following kinds of computing refers to an environment of servers that
house and provide access to resources users access through the Internet?
a. disperse
b. cloud
c. digital
d. liberated
Worksheet ____________________ typically contain descriptive information about
items in rows or contain information that helps to group the data in the worksheet.
Status option that shows time with a slashed bar.
____________________ indicates how characters are emphasized.
In the Microsoft account area, you can use the _________________________ link to
sign in to your Microsoft account.
____________________ changes a photo colors into brown, gold, and yellow.
Communications protocol used to retrieve incoming email messages.
____________________ software is provided for use, modification, and redistribution
and usually can be downloaded from the web at no cost.
As shown in the accompanying figure, the _________________________ shows the
current page followed by the total number of pages in the document, the number of
words in the document, and an icon to check spelling and grammar.
To print a copy of a relationship, tap or click the _____________________ button
shown on the accompanying figure.
Moves the insertion point to the end of data in a cell.
Thin, lightweight mobile computer with a screen in its lid and a keyboard in its base
Describe the structure of a typical email message, including the two main areas of the
message and the components of each of those areas.
Identify the letter of the choice that best matches the phrase or definition.
a. parenthetical reference
b. works cited
c. header
d. Click and Type
e. shortcut keys
f. vertical ruler
g. AutoCorrect
h. field
i. endnote
j. tag name
Used in MLA style instead of noting each source at the bottom of the page.
Track team tasks according to who is responsible for completion
The brightness and contrast of an image are changed in ____________________
percentage increments.
Press the ____________________ key(s) to select the previous cell from the one in
which the insertion point appears.
Discuss document properties. Include definitions of these terms: standard properties
and automatically updated properties. Be sure to give at least two reasons why
document properties are valuable.
Spell-checking a worksheet.
The case that contains and protects the motherboard, hard disk drive, memory, and
other electronic components of the computer from damage
A computer, usually with limited processing power, that enables users to send data to
and/or receive information from a server