Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Excel attempts to guess which cells you want to include in the function by looking for
ranges that are adjacent to the selected cell and that contain numeric data.
a. True
b. False
When you sort data in a query, the records in the underlying table are actually
rearranged.
a. True
b. False
Essential business letter elements include the ____.
a. date line and inside address
b. message
c. signature block
d. all of the above
To export data from a query to Excel, select the query in the Navigation Pane, tap or
click ____ on the ribbon, and then tap or click the Excel button.
a. DATABASE TOOLS
b. EXTERNAL DATA
c. OFFICE EXPORT
d. CREATE
Installing software is the process of setting up software to work with a computer,
printer, and other hardware.
a. True
b. False
A ____ paragraph places the first character of a text line near the left border of a
placeholder.
a. left-aligned
b. right-line
c. centered
d. justified
To change the caption for a field in a query, click the field in the design grid, click the
____ button on the Design tab, click the Caption box, and enter the new caption.
a. Caption
b. Property Sheet
c. Field Name
d. Format
Which of the following is a method of entering functions?
a. keyboard, touch gesture, or pointer
b. the Sum menu
c. the Insert Function box in the formula bar
d. the Name box area in the formula bar
Which of the following is a collection of related webpages and associated items, such as
documents and pictures, stored on a web server?
a. website
b. server reader
c. Internet host
d. browser app
You set the appointment status for a calendar item using the ____ button.
a. Show As
b. Set Status
c. Item Status
d. Display
The second image is a digital photograph and a color cast has occurred.How can you
improve the photograph's color?
a. change the color saturation
c.apply recolor effects
b. change the color tone
d.reshoot the picture
To insert a tab character in a cell, you must press ____.
a. CTRL+TAB
b. F2
c. SHIFT+TAB
d. ENTER
Many companies use access controls to minimize the chance that a perpetrator may
intentionally access or an employee may accidentally access confidential information
on a computer, mobile device, or network.
a. True
b. False
The ____ area on the status bar includes six commands as well as the result of the
associated calculation on the right side of the menu.
a. AutoFormat
b. AutoComplete
c. AutoFunction
d. AutoCalculate
On the works cited page, list works by each author's last name, as shown in the
accompanying figure, or, if the author's name is not available, by the _____.
a. title of the source
b. publisher
c. date of the source
d. MLA citation number
Julian is concerned that he is forgetting something in the inside address. He has the
following information: courtesy title, full name, business affiliation, and full
geographical address.
a. Yes, he is forgetting the complimentary close.
b. Yes, he is forgetting the job title.
c.Yes, he is forgetting the date line.
d.No, he is not forgetting anything.
When shading paragraphs, Word shades from the left margin to the right margin of the
current paragraph.
a. True
b. False
Which of the following is the process of initiating contact between two Bluetooth
devices and allowing them to communicate with each other?
a. streamlining
b. discovering
c. docking
d. pairing
By default, the Normal style inserts a vertical space equal to ____ line(s) between each
line of text.
a. 1
b. 1.08
c. 2
d. 2.15
Which of the following high-speed Internet connections use an antenna on a house or
business to communicate with a tower location via radio signals?
a. satellite
b. FTTP
c. fixed wireless
d. DSL
Which of the following category of users works on a computer while away from a main
office, home office, or school?
a. SOHO
b. power
c. mobile
d. key
To use a parameter query, press and hold or right-click the query in the Navigation Pane
and then tap or click ____ on the shortcut menu.
a. Use Parameter
b. Enter Values
c. Open
d. Run
The WordArt ____ is the exterior border surrounding each letter or symbol.
a. effect
b. fill
c. depth
d. outline
Redundancy means storing the same fact in more than one place.
a. True
b. False
Clicking the ____ opens the Insert Function dialog box.
a. Insert Function box in the formula bar
b. Function dialog box launcher (HOME tab | Calculations group)
c. Function button (HOME tab | Function group)
d. Functions & Formulas button on the status bar
Which of the following is a storage device?
a. headphones
b. solid-state drive
c. USB flash drive
d. memory card
The list of messages displayed in the message pane is called the ____.
a. reading list
b. message list
c. subject list
d. subject line
Your data center is looking to conserve space in its server room. Which of the following
are you most likely to choose as a result?
a. tower server
b. blade server
c. indexed server
d. bay server
To copy cell contents, you can select the cell and then press the ____ keys.
a. CTRL+V
b. CTRL+X
c. CTRL+B
d. CTRL+C
One method of displaying the entire contents of a window is to ____ it.
a. extend
b. restore
c. maximize
d. navigate
Excel can display characters in only three font colors: black, red, and blue.
a. True
b. False
