Text is used to place ____ on an Excel worksheet.
a. column titles
b. row titles
c. worksheet titles
d. filenames
Which of the following kinds of file utilities shrink the size of a file(s)?
a. unit
b. file compression
c. matrix
d. conversion
A photo’s color intensity can be modified by changing the brightness and content.
a. True
b. False
Switching between PowerPoint views help you review your presentation’s design,
content, and organization.
a. True
b. False
Which of the following is built into an upright cabinet that stands alone?
a. rack server
b. tower server
c. blade server
d. bay server
Tap or click Mute if you do not want your audience to hear any recorded sounds.
a. True
b. False
A document may wordwrap differently depending on the type of printer being used.
a. True
b. False
Borders may be added ____ a paragraph.
a. above
b. below
c. to the left of
d. in the middle of
Research indicates that the more text messages students send, the more easily they find
formal writing.
a. True
b. False
Which of the following does your financial institution use to reduce fraud?
a. digital forensics system
b. iris recognition system
c. signature verification system
d. hand geometry system
To remove spyware, users need to obtain a special program that can detect and delete it.
a. True
b. False
Which of the following allows access to high-speed Internet services through the cable
television network?
a. cable transceiver
b. cable modem
c. cable receiver
d. cable dialer
In which gesture do you quickly touch and release one finger two times?
a. double-pinch
b. double-stretch
c. double-tap
d. double-hold
What term is used to illustrate the gap between those with and those without access to
technology?
a. digital divide
b. mobile stratification
c. technology caste system
d. none of the above
When a word processing program user formats a document, what does the user change?
a. the document’s appearance
b. the document’s content
c. the document’s reliability
d. the document’s clipboard
The NETWORKDAYS function checks a formula for correctness.
a. True
b. False
Outlook does not automatically display a newly created calendar until you select it.
a. True
b. False
You have purchased your first tablet and the use of gestures for interacting with the
touch screen is taking a little bit of getting used to. You take a quick online tutorial to
familiarize yourself with the gestures.
You want to display a shortcut menu in order to quickly show you all of the possible
actions at a particular moment in your use of the tablet. Which of the following gestures
does the tutorial tell you to use?
a. tap
c.press and hold
b. pinch
d.swipe
Your manager has asked you to shift usage and consumption of technology resources
from a local environment managed by in-house IT staff to the Internet. What kind of
computing will allow you to accomplish her goal?
a. disperse
b. digital
c. cloud
d. liberated
When you enter a domain name, the DNS server translates the domain name to its
associated IP address of that data and information can be routed to the correct computer.
a. True
b. False
As shown in the accompanying figure, which of the following kinds of program
protects a computer against viruses by identifying and removing any computer viruses
found in memory, on storage media, or on incoming files?
a. hoax
b. secure
c. antivirus
d. antispyware
Low saturation produces vivid colors.
a. True
b. False
A feature, called wordwrap, allows users to type words in a paragraph continually
without pressing the ENTER key at the end of each line.
a. True
b. False
Most e-commerce actually takes place between businesses. What is this called?
a. consumer-to-business (C2B) e-commerce
b. business-to-consumer (B2C) e-commerce
c. consumer-to-consumer (C2C) e-commerce
d. business-to-business (B2B) e-commerce
Which of the following is a collection of computers and devices connected together, as
shown in the accompanying figure, often wirelessly, via communications devices and
transmission media?
a. client base
b. baseline
c. network
d. server farm
A date stamp shows the date a workbook, report, or other document was created or the
time period it represents.
a. True
b. False
After he gives his presentation, Min decides he would like to create a website devoted
to the topic of climate change. What feature of his Office 365 subscription allows him
to do so?
a. Exchange Online
b. file sharing
c. a built-in hosted public website
d. access to multiple computers and mobile devices
How many chart types does Excel offer?
a. 5
b. 10
c. 29
d. 50
When you use the keyboard to scroll to a different position in the document, the ____
automatically moves when you press the desired keys.
a. roster
b. insertion point
c. alt tag
d. smart tag
A new colleague of yours has been eyeing your computer skills with envy, as you seem
to know all of the shortcuts. He wants to know what your “secret” is.
Which of the following allows you to remove character formatting?
a. Press and hold down the CTRL key and then click the paragraph.
b. Move the mouse to the left of the first line until the mouse pointer changes to a
right-pointing block arrow and then click.
c.Move the mouse to the left of the text until the mouse pointer changes to a
right-pointing block arrow and then triple-click.
d.Press the CTRL+SPACEBAR keys.
Which of the following keys toggles between Insert mode and Overtype mode?
a. INSERT
b. ENTER
c. TAB
d. ALT
Which of the following is an example of an operating system?
a. C++
b. C#
c. Windows
d. Visual Basic
In the Bavant Publishing database, a one-to-many relationship exists between the Book
Rep table and the Customer table.
a. True
b. False
To find duplicate records in a table, use the _____ Query Wizard.
a. Duplicate Records
b. Same Records
c. Duplicate Primary Key
d. Find Duplicates
A(n) ____________________ is a named collection of stored data, instructions, or
information and can contain text, images, video, and audio.
Protects a network’s resources from intrusion.
One type of system software is a(n) ____________________ system, which is a set of
programs that coordinates all the activities among computer hardware devices.
When you have created a filter using Advanced Filter/Sort, you can save the filter
settings as a query by using the ____________________ command on the Advanced
menu.
Cloud computing is changing how users access and pay for
_________________________ .
____________________ affects the coolness or the warmness of photos.
____________________ software is mass-produced, copyrighted software that meets
the needs of a wide variety of users, not just a single user or company.
____________________ is a technique that can be used to conceal data that might not
be relevant to a particular report or sensitive data that others should not see.
In Word, the term, ____________________, refers to returning the formatting to the
Normal style.
Assigns a value to a cell based on a logical test.
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
information, and store the information for future use
Describe the six steps that you would perform to propose a new time for a meeting in
Outlook.
A(n) ____________________ represents an appointment that is scheduled over a
period of days.
Careful ____________________ can reduce your effort significantly and result in a
worksheet that is accurate, easy to read, flexible, and useful.
A(n) ____________________ is a predefined formula that performs common
calculations such as adding the values in a group of cells.
Discuss note taking software and how it is used.
A website that encourages members in its online community to share their interests,
ideas, stories, photos, music, and videos with other registered users.
List and briefly describe six chart types from which you can choose in Excel. Mention
how you select the appropriate type of chart.
Identify the letter of the choice that best matches the phrase or definition.
a. ALT+PAGE DOWN
b. ARROW
c. CTRL+HOME
d. HOME
e. CTRL+F
f. END
g. INSERT
h. SHIFT+RIGHT ARROW
i. BACKSPACE
j. SPACEBAR
Selects the cell at the beginning of the row that contains the active cell.