Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
You can enter the correct range in a function by typing the beginning and ending cell
pont separated by a ____.
a. semi-colon (;)
b. colon (:)
c. period (.)
d. none of the above
The adjusted cell point in a copied and pasted formula are called ____ cell point.
a. related
b. relative
c. pasted
d. alternative
To use Range Finder to verify that a formula contains the intended cell reference, click
or tap the cell with the formula you want to check.
a. True
b. False
When you set up a worksheet, you should use cell reference in formulas whenever
possible, rather than ____ values.
a. logical
b. constant
c. consistent
d. calculated
If formulas located in other cells reference cells in a deleted row or column, Excel does
not adjust these cell reference but instead displays the ____ error message.
a. #NULL!
b. #DIV/0!
c. #N/A
d. #REF!
The MLA style uses the term bibliographical reference for works cited.
a. True
b. False
The Accounting number format assigns a floating dollar sign.
_________________________
To display the Total row in a datasheet, tap or click the Sum button on the ribbon.
____________________
A field that has the Calculated data type can store a unique sequential number that
Access assigns to a record.____________________
In the accompanying figure, the slashed bars indicate a(n) Out of Office appointment.
_________________________
When the Book Rep table is related to the Customer table, it is possible to view the
customers of a given book rep when you are viewing the datasheet for the Book Rep
table. The customers for the book rep will appear below the book rep in a split form.
____________________
Microsoft Office 2007 is the newest version of Microsoft Office. _______________
A color scheme in Word is a document theme that identifies 24 complementary colors
for text, background, accents, and links in a document. _________________________
If you accidentally undo an action, you can use the Redo button to redo it.
_________________________
A recurring appointment repeats on the calendar at regular intervals.
_________________________
A default value is a value that Access will display on the screen in a particular field
before the user begins adding a recor
d.____________________
The Office 365 subscription provides access to most Office applications wherever you
are working. _______________
To delete a field, press and hold or right-click the column heading for the field, and then
tap or click Remove Field on the shortcut menu. ____________________
Cooler colors tend to pull away from the reader. _________________________
Once the office app's Help window is open, you can search for help using the Table of
Contents, clicking the links in the Help window, or entering search text in the 'Search
online help' text box. _______________
If you do not use the mini toolbar, it remains on the screen. _______________
RTF supports fewer formats than HTML or Plain Text, as well as hyperlinks.
_________________________
An input device is any hardware component that allows you to enter data and
instructions into a computer or mobile device. _________________________
A text box allows you to emphasize or set off text that you consider important for your
audience to read.
_________________________
You can resize images by dragging the sizing handles to a desired location.
_________________________
If you want to conserve ink or toner, you can instruct Word to print draft quality
documents. _________________________
Thumbnails in the Picture gallery display the more common color saturation, color
tone, and recolor adjustments.
_________________________
A(n) footer is text and/or graphics that print at the bottom of every page.
_________________________
To insert a field between existing fields, press and hold or right-click the column
heading for the field that will follow the new field, and then tap or click Insert Column
on the shortcut menu. ____________________
A multilookup field is a field that contains more than one value.
____________________
The conclusion, which follows the introduction, consists of several paragraphs that
support the topic._________________________
The Standard toolbar appears whenever you select text. _________________________
In a worksheet, columns typically contain information that is similar to a list.
_________________________
The Reading Pane displays the content of a message without requiring you to open the
message. _________________________
Appointments, events, and meetings are examples of calendar items.
_________________________
In designing a worksheet, visual aesthetics should come first.
_________________________
You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a
worksheet. _________________________
Word has many Quick Access keys for your convenience while typing.
_________________________
Typing an ordinal followed by a space or a hyphen makes part of the ordinal into a(n)
subscript. _________________________
An email address contains an exclamation point to separate the user name from the
domain name. _________________________
You are going to make a decision about a server purchase based on whether it is a rack
server, a blade server, or a tower server. On which of the following are you basing your
decision?
a. resolution
b. base index
c. aggregator
d. form factor
To delete WordArt text outline, click ____ in the Text Outline gallery.
a. Delete Outline
b. No Outline
c. Reverse Outline
d. Invisible Outline
Which of the following is the development and maintenance of webpages?
a. web distribution
b. web publishing
c. web convergence
d. e-commerce
A paragraph is a segment of text with the same format that begins when you press the
ENTER key and ends when you press the ENTER key again.
a. True
b. False
____ is the difference between the darkest and lightest areas of an image.
a. Contrast
b. Color
c. Style
d. Brightness
FOIA enables public access to most government records.
a. True
b. False
As you edit some photos from your summer vacation, you decide to remove a blurry
area of one of your photos. Which tool will you use for this?
a. crop
b. resize
c. compress
d. contrast
To calculate statistics for only those records that satisfy certain criteria, select ____ as
the entry in the Total row for the field, and then enter the criterion in the Criteria row.
a. Having
b. Where
c. Restrict
d. Find
To change the print orientation from portrait to landscape, tap or click the ____ button
on the PRINT PREVIEW tab.
a. Portrait/Landscape
b. Orientation
c. Switch Orientation
d. Landscape
You would make a color in a graphic ____ if you wanted to remove part of a graphic or
see text or colors behind a graphic.
a. opaque
b. transparent
c. translucent
d. transfigured
Which of the following is an example of data on a grade report?
a. total semester hours
b. grade point average
c. course names
d. total credits
Which of the following is a computer that allows users to upload and/or download files
using FTP?
a. FTP server
b. FTP network
c. FTP client
d. FTP base unit
In your encryption algorithm, you swapped adjacent characters. Which algorithm did
you use?
a. substitution
b. transposition
c. expansion
d. compaction
To move to the end of the document, press the ____ key(s).
a. DOWN ARROW
b. END
c. CTRL+DOWN ARROW
d. CTRL+END
Gradient fill is one color shade gradually progressing to another shade of the same color
or one color progressing to another color.
a. True
b. False
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the
text.
a. demoting
b. decreasing
c. promoting
d. increasing
Which of the following is a small version of a larger graphic on a webpage?
a. keyframe
b. thumbnail
c. applet
d. extraction
What is the role of the W3C?
a. own and control the Internet
b. oversee research and set standards for many areas of the Internet
c. control the World Wide Web; monitor and govern the use of data and information
communicated over the Internet
d. supervise and approve corporate and commercial use of the World Wide Web
In the accompanying figure, the key symbol that appears in the row selector for the
Book Rep Number field indicates that Book Rep Number is the ____ for the table.
a. principal key
b. foreign key
c. main key
d. primary key
The Calendar is the Outlook folder that contains your personal schedule of ____.
a. appointments
b. events
c. agendas
d. meetings
Changes you have to make to a PowerPoint presentation may include ____.
a. adding effects to photos
b. altering the colors of photos
c. altering the colors of illustrations
d. updating visual elements displayed on a slide
The Internet is a service of the we
b.
a. True
b. False
Which of the following warns that the computer is infected and needs immediate
attention?
a. spyware
b. virus hoax
c. FBI consumer alert
d. web filter
You have a new e-book reader and you are expecting to be away on a long hike with it.
How many hours of reading can you get from it before needing to recharge it?
a. 75
b. 100
c. 125
d. 150
In Word, you can create electronic image files through the ____ tab in the Backstage
view.
a. PDF
b. XPS
c. Print
d. Convert
If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to
open the Backstage view and then tap or click the Account tab to display the Account
gallery, and tap or click the Sign out link.
a. ACCESS
b. TOOLS
c. EXIT
d. FILE
To change the name of a field, press and hold or right-click the column heading for the
field, tap or click ____ on the shortcut menu, and then type the desired field name.
a. Change Column
b. Rename Column
c. Change Field
d. Rename Field
Which of the following terms is used to describe a scam in which a website includes a
button, image or link that contains a malicious program?
a. war driving
b. spitting
c. clickjacking
d. spimming
You can save your Outlook calendar by backing up your entire Outlook personal folder
files (.pst) or an individual calendar (.ics).
a. True
b. False
The ____ button lists error-checking options following the assignment of an invalid
formula to a cell.
a. Find Error
b. Explain Error
c. Fix Error
d. Trace Error
Which comparison operator means "not equal to"?
a. <=
b. >
c. <
d. <>
Kind of software that creates and analyzes the user's tax forms to search for potential
errors and deduction opportunities
A(n) ____________________ device authenticates a person's identity by translating a
personal characteristic into a digital code that then is compared with a digital code
stored in the computer verifying a physical or behavioral characteristic.
Describe four general guidelines you should follow when scheduling a meeting.
Discuss what it means to develop a project. Include explanations of editing and
formatting in your answer.
Unsolicited email messages are known as ____________________ or junk mail.
Open the Font dialog box
Changes the intensity of colors
One of the reasons Excel is such a valuable tool is that you can assign a(n)
____________________ to a cell, and Excel will calculate the result.
____________________ is a background feature that allows you to move the
background from the slide borders in varying distances by percentages.
Type of application that assists professional and designers in creating engineering,
architectural, and scientific designs and models
One way to increase font size is to press CTRL+ _________________________.
When the ____________________ is clicked, Word displays a menu that allows a
correction to be undone or changes how Word handles future automatic corrections of
this type.
Allows you to make the same change to all records.
A website that encourages members to share their interests, ideas, stories, photos,
music, and videos with other users
Any hardware component that allows you to enter data and instructions into a computer
or mobile device
Employers and schools often specify standards for the ethical use of technology in an IT
____________________ and then distribute these standards to employees and students.
The ____________________ is the bottom triangle at the 0" mark on the horizontal
ruler shown in the accompanying figure.
To prevent unauthorized access and use, at a minimum a company should have a
written ____________________ that outlines the activities for which a computer or
network may and may not be used.
A(n) ____________________ is any element in Outlook the contains information.
Kind of mobile app with which you can use the digital camera on your mobile device to
take quality photos and/or videos and then instantly share them on social media sites
