WorksheetsBDA Exam Review
Total questions: 97
Worksheet time: 49mins
The default view in Word is ____.
Print Layout view
Headline view
Web Layout view
Outline view
To enter a blank line into a document, press the ____ key without typing any text on the line.
CTRL
ALT
ENTER
ESC
If a flagged word is spelled correctly, right-click it and then click ____ on the shortcut menu to instruct Word not to flag future occurrences of the same word in this document.
Not a Mistake
Correct Spelling
Do Not Correct
Ignore All
To move to the beginning of a line with the keyboard, press the ____ key(s).
LEFT ARROW
CTRL+HOME
HOME
PAGE UP
____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Document
Character
Paragraph
Object
Word includes a variety of document ____ to assist you with coordinating visual elements in a document.
layouts
formats
themes
graphs
The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.
font
font size
point
paragraph formatting
A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.
headline
centered
bulleted
indexed
To select nonadjacent items, select the first item as usual, press and hold down the ____ key, and then while holding down the key, select the additional items.
HOME
F1
CTRL
ALT
The small squares and circles around a selected graphic are called ____ handles.
sizing
shape
base
dimension
If Word finds a potential error in a document, a red, green, or blue wavy underline flags the problem.
True
False
A raised dot (·) shows where the ENTER key was pressed.
True
False
Each time the ENTER key is pressed, Word creates a new paragraph.
True
False
Wordwrap forces you to stop typing words and press the ENTER key at the end of each line.
True
False
A letterhead should contain all of the following EXCEPT ____.
the complete legal name of the individual or company
the telephone number
the mailing address
the company's objective
Files containing ____ are available from a variety of sources.
task panes
search terms
colors
graphics
You can make one color in a graphic ____, that is, removing its color.
opaque
transparent
translucent
transfigured
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.
opaque
transparent
translucent
transfigured
A ____ symbol is another name for a dot symbol.
bullet
logo
cell
target
To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu.
Edit Hyperlink
Select Hyperlink
Convert Hyperlink
Remove Hyperlink
In a business letter, the ____, if present, begins two lines below the last line of the inside address.
salutation
date line
message
complimentary close
In a business letter, type the ____ at least four blank lines below the complimentary close, allowing room for the author to sign his or her name.
inside address
message
signature block
salutation
To advance rightward from one cell to the next in a table, press the ____ key.
TAB
BACKSPACE
HOME
ENTER
You can use your own creative skills to design and compose business documents.
True
False
Word has a variety of predefined shapes, which are a type of drawing object, that you can insert in documents.
True
False
A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
calendar
worksheet
presentation
database
____ help one slide flow gracefully into the next during a slide show.
Videos
Transitions
Variants
Shapes
PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.
events
slides
markers
files
An accompanying ____ gives audience members reference notes and review material for your presentation.
handout
slide
file
database
When you begin creating a new PowerPoint presentation, you need to select a ____.
variant
theme
document
slide
A ____ is a specific design with coordinating colors, fonts, and special effects.
placeholder
slide show
chart
document theme
The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.
placeholder
pane
layout
recorder
____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.
Coloring
Styling
Formatting
Zooming
Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.
size
style
format
font
____ text has a slanted appearance.
Colored
Highlighted
Bolded
Italicized
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
demoting
decreasing
promoting
increasing
You can type comments to yourself in the ____ for a specific slide while working in Normal view.
Slide pane
Notes pane
Theme pane
Navigation pane
A slide ____ is a special effect used to progress from one slide to the next slide in a slide show.
animation
layout
transition
theme
Document ____ are the details about a file.
properties
facts
themes
keywords
A level is a position within a structure, such as an outline, that indicates the magnitude of importance.
True
False
Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.
one-fourth
one-half
one-fifth
one-third
The ____ introduces the presentation to the audience.
placeholder
thumbnail
first word of each paragraph
title slide
____ determines the overall lightness or darkness of an entire image.
Contrast
Color
Style
Brightness
____ is the difference between the darkest and lightest areas of an image.
Contrast
Color
Style
Brightness
One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.
accents
graphical elements
textual elements
hyperlinks
PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.
predefined
enhanced
complex
accented
Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.
Graphics
Shapes
Boxes
Background
To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the ____.
(DRAWING TOOLS FORMAT tab | Size group)
(SHAPE TOOLS FORMAT tab | Size group)
(INSERT tab | Size group)
(HOME tab | Size group)
Adding a ____ to text adds depth and helps the letters display prominently.
sizing handle
shadow
font
shape
To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.
Format Designer
Formatter
Format Shaper
Format Painter
The WordArt ____ is the exterior border surrounding each letter or symbol.
effect
fill
depth
outline
A word with a meaning similar to that of another word is called a ____.
synonym
thesaurus
replacer
duplicate
Researchers have known for decades that documents with visual elements are more effective than those that consist of only text.
True
False
Graphics in documents help clarify and emphasize details so they appeal to audience members with different backgrounds.
True
False
Color ____ changes the intensity of colors.
tone
density
saturation
brightness
The ____ gallery has a wide variety of preset formatting combinations for coloring pictures.
Color
Design
Style
Format
____ changes picture color into black, white, and shades of gray.
Blackscale
Grayscale
Whitescale
Colorscale
Click ____ to move a stacked object toward the top of the stack.
Move Forward
Bring Forward
Send Forward
Slide Forward
Click ____ to move a stacked object to the top of the stack.
Move to Top
Bring to Front
Slide to Top
Move to Front
The ____ command moves the selected object underneath all objects on the slide.
Send Backward
Back Options
Text Options
Send to Back
The presentation ____ determines the formatting characteristics of fonts and colors.
theme
placeholder
slide
layout
____ view allows you to look at several slides at one time.
Slide Sorter
Slide Show
Reading
Review Sorter
The Trim Video feature allows you to trim your clip by time measurements that are accurate to ____ of a second.
one-hundredth
one-tenth
one-thousandth
one-ten thousandth
____ includes special visual and sound effects applied to text or other content.
Animation
Audio control
Playback control
Visual effects
____ effects determine how slide elements first appear on a slide.
Exit
Entrance
Emphasis
Exciting
____ effects determine how slide elements disappear.
Exit
Entrance
Emphasis
Exciting
An Excel ____ allows data to be summarized and charted easily.
worksheet
workflow
document
presentation
The first step in creating an effective worksheet is to make sure you ____.
apply font formatting
understand what is required
insert a chart
enter the data
To enter data in a cell, you must first select the ____.
row
worksheet
column
cell
Clicking the ____ box completes an entry.
Cancel
Formula
Enter
Tab
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
semi-colon (;)
colon (:)
period (.)
none of the above
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
save
format
clear
Combining two or more selected cells into one cell is called ____ cells.
merging
mixing
combining
spanning
What effect does the Accounting Number Format have on the selected cells?
Converts alphabetic characters to numbers
Displays cell contents with two decimal places that align vertically
Performs tax calculations
Copies the numbers of one cell to another
What effect does the Comma Style format have on the selected cells?
Converts decimals to commas within a cell
Converts decimals to commas within merged cells
Displays cell contents with two decimal places and commas as thousands separators
Allows for substitution of selected characters
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
outer
offset
rasterized
A thin red border indicates the active cell.
True
False
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
True
False
Excel can display characters in only three font colors: black, red, and blue.
True
False
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).
True
False
A ____ is a prewritten formula that is built into Excel.
function
feature
task
calculation
All of the following are valid Excel arithmetic operators EXCEPT ____.
^
*
%
>
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
40
26
48
13
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
AutoCorrect Options
Insert Options
Paste Options
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Find Error
Explain Error
Fix Error
Trace Error
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
AutoCorrect
Insert
Auto Fill
Paste
The ____ function displays the highest value in a range.
MIN
SUM
MAX
AVERAGE
The ____ function determines the lowest number in a range.
LOW
BASE
LEAST
MIN
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
scheme
gallery
theme
style
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Comma style format
Accounting number format
Percent style format
Currency style format
A ____ is text and graphics that print at the bottom of every page.
footer
toe
margin
stopper
The equal sign (=) precedes a formula.
True
False
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
True
False
Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.
True
False
The Sum button menu allows you to enter one of five often-used functions easily into a cell.
True
False
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.
True
False
The range automatically selected by Excel is always correct.
True
False
