Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

BDA Exam Review

Total questions: 97

Worksheet time: 49mins

Name
Class
Date
1.

The default view in Word is ____.

a)

Print Layout view

b)

Headline view

c)

Web Layout view

d)

Outline view

2.

To enter a blank line into a document, press the ____ key without typing any text on the line.

a)

CTRL

b)

ALT

c)

ENTER

d)

ESC

3.

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.

a)

Not a Mistake

b)

Correct Spelling

c)

Do Not Correct

d)

Ignore All

4.

To move to the beginning of a line with the keyboard, press the ____ key(s).

a)

LEFT ARROW

b)

CTRL+HOME

c)

HOME

d)

PAGE UP

5.

____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.

a)

Document

b)

Character

c)

Paragraph

d)

Object

6.

Word includes a variety of document ____ to assist you with coordinating visual elements in a document.

a)

layouts

b)

formats

c)

themes

d)

graphs

7.

The ____, or typeface, defines the appearance and shape of letters, numbers, and special characters.

a)

font

b)

font size

c)

point

d)

paragraph formatting

8.

A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.

a)

headline

b)

centered

c)

bulleted

d)

indexed

9.

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.

a)

HOME

b)

F1

c)

CTRL

d)

ALT

10.

The small squares and circles around a selected graphic are called ____ handles.

a)

sizing

b)

shape

c)

base

d)

dimension

11.

If Word finds a potential error in a document, a red, green, or blue wavy underline flags the problem.

a)

True

b)

False

12.

A raised dot (·) shows where the ENTER key was pressed.

a)

True

b)

False

13.

Each time the ENTER key is pressed, Word creates a new paragraph.

a)

True

b)

False

14.

Wordwrap forces you to stop typing words and press the ENTER key at the end of each line.

a)

True

b)

False

15.

A letterhead should contain all of the following EXCEPT ____.

a)

the complete legal name of the individual or company

b)

the telephone number

c)

the mailing address

d)

the company's objective

16.

Files containing ____ are available from a variety of sources.

a)

task panes

b)

search terms

c)

colors

d)

graphics

17.

You can make one color in a graphic ____, that is, removing its color.

a)

opaque

b)

transparent

c)

translucent

d)

transfigured

18.

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

19.

A ____ symbol is another name for a dot symbol.

a)

bullet

b)

logo

c)

cell

d)

target

20.

To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu.

a)

Edit Hyperlink

b)

Select Hyperlink

c)

Convert Hyperlink

d)

Remove Hyperlink

21.

In a business letter, the ____, if present, begins two lines below the last line of the inside address.

a)

salutation

b)

date line

c)

message

d)

complimentary close

22.

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.

a)

inside address

b)

message

c)

signature block

d)

salutation

23.

To advance rightward from one cell to the next in a table, press the ____ key.

a)

TAB

b)

BACKSPACE

c)

HOME

d)

ENTER

24.

You can use your own creative skills to design and compose business documents.

a)

True

b)

False

25.

Word has a variety of predefined shapes, which are a type of drawing object, that you can insert in documents.

a)

True

b)

False

26.

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.

a)

calendar

b)

worksheet

c)

presentation

d)

database

27.

____ help one slide flow gracefully into the next during a slide show.

a)

Videos

b)

Transitions

c)

Variants

d)

Shapes

28.

PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.

a)

events

b)

slides

c)

markers

d)

files

29.

An accompanying ____ gives audience members reference notes and review material for your presentation.

a)

handout

b)

slide

c)

file

d)

database

30.

When you begin creating a new PowerPoint presentation, you need to select a ____.

a)

variant

b)

theme

c)

document

d)

slide

31.

A ____ is a specific design with coordinating colors, fonts, and special effects.

a)

placeholder

b)

slide show

c)

chart

d)

document theme

32.

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.

a)

placeholder

b)

pane

c)

layout

d)

recorder

33.

____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.

a)

Coloring

b)

Styling

c)

Formatting

d)

Zooming

34.

Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.

a)

size

b)

style

c)

format

d)

font

35.

____ text has a slanted appearance.

a)

Colored

b)

Highlighted

c)

Bolded

d)

Italicized

36.

In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.

a)

demoting

b)

decreasing

c)

promoting

d)

increasing

37.

You can type comments to yourself in the ____ for a specific slide while working in Normal view.

a)

Slide pane

b)

Notes pane

c)

Theme pane

d)

Navigation pane

38.

A slide ____ is a special effect used to progress from one slide to the next slide in a slide show.

a)

animation

b)

layout

c)

transition

d)

theme

39.

Document ____ are the details about a file.

a)

properties

b)

facts

c)

themes

d)

keywords

40.

A level is a position within a structure, such as an outline, that indicates the magnitude of importance.

a)

True

b)

False

41.

Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.

a)

one-fourth

b)

one-half

c)

one-fifth

d)

one-third

42.

The ____ introduces the presentation to the audience.

a)

placeholder

b)

thumbnail

c)

first word of each paragraph

d)

title slide

43.

____ determines the overall lightness or darkness of an entire image.

a)

Contrast

b)

Color

c)

Style

d)

Brightness

44.

____ is the difference between the darkest and lightest areas of an image.

a)

Contrast

b)

Color

c)

Style

d)

Brightness

45.

One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.

a)

accents

b)

graphical elements

c)

textual elements

d)

hyperlinks

46.

PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.

a)

predefined

b)

enhanced

c)

complex

d)

accented

47.

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.

a)

Graphics

b)

Shapes

c)

Boxes

d)

Background

48.

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 ____.

a)

(DRAWING TOOLS FORMAT tab | Size group)

b)

(SHAPE TOOLS FORMAT tab | Size group)

c)

(INSERT tab | Size group)

d)

(HOME tab | Size group)

49.

Adding a ____ to text adds depth and helps the letters display prominently.

a)

sizing handle

b)

shadow

c)

font

d)

shape

50.

To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.

a)

Format Designer

b)

Formatter

c)

Format Shaper

d)

Format Painter

51.

The WordArt ____ is the exterior border surrounding each letter or symbol.

a)

effect

b)

fill

c)

depth

d)

outline

52.

A word with a meaning similar to that of another word is called a ____.

a)

synonym

b)

thesaurus

c)

replacer

d)

duplicate

53.

Researchers have known for decades that documents with visual elements are more effective than those that consist of only text.

a)

True

b)

False

54.

Graphics in documents help clarify and emphasize details so they appeal to audience members with different backgrounds.

a)

True

b)

False

55.

Color ____ changes the intensity of colors.

a)

tone

b)

density

c)

saturation

d)

brightness

56.

The ____ gallery has a wide variety of preset formatting combinations for coloring pictures.

a)

Color

b)

Design

c)

Style

d)

Format

57.

____ changes picture color into black, white, and shades of gray.

a)

Blackscale

b)

Grayscale

c)

Whitescale

d)

Colorscale

58.

Click ____ to move a stacked object toward the top of the stack.

a)

Move Forward

b)

Bring Forward

c)

Send Forward

d)

Slide Forward

59.

Click ____ to move a stacked object to the top of the stack.

a)

Move to Top

b)

Bring to Front

c)

Slide to Top

d)

Move to Front

60.

The ____ command moves the selected object underneath all objects on the slide.

a)

Send Backward

b)

Back Options

c)

Text Options

d)

Send to Back

61.

The presentation ____ determines the formatting characteristics of fonts and colors.

a)

theme

b)

placeholder

c)

slide

d)

layout

62.

____ view allows you to look at several slides at one time.

a)

Slide Sorter

b)

Slide Show

c)

Reading

d)

Review Sorter

63.

The Trim Video feature allows you to trim your clip by time measurements that are accurate to ____ of a second.

a)

one-hundredth

b)

one-tenth

c)

one-thousandth

d)

one-ten thousandth

64.

____ includes special visual and sound effects applied to text or other content.

a)

Animation

b)

Audio control

c)

Playback control

d)

Visual effects

65.

____ effects determine how slide elements first appear on a slide.

a)

Exit

b)

Entrance

c)

Emphasis

d)

Exciting

66.

____ effects determine how slide elements disappear.

a)

Exit

b)

Entrance

c)

Emphasis

d)

Exciting

67.

An Excel ____ allows data to be summarized and charted easily.

a)

worksheet

b)

workflow

c)

document

d)

presentation

68.

The first step in creating an effective worksheet is to make sure you ____.

a)

apply font formatting

b)

understand what is required

c)

insert a chart

d)

enter the data

69.

To enter data in a cell, you must first select the ____.

a)

row

b)

worksheet

c)

column

d)

cell

70.

Clicking the ____ box completes an entry.

a)

Cancel

b)

Formula

c)

Enter

d)

Tab

71.

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

a)

semi-colon (;)

b)

colon (:)

c)

period (.)

d)

none of the above

72.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

a)

save

b)

print

c)

format

d)

clear

73.

Combining two or more selected cells into one cell is called ____ cells.

a)

merging

b)

mixing

c)

combining

d)

spanning

74.

What effect does the Accounting Number Format have on the selected cells?

a)

Converts alphabetic characters to numbers

b)

Displays cell contents with two decimal places that align vertically

c)

Performs tax calculations

d)

Copies the numbers of one cell to another

75.

What effect does the Comma Style format have on the selected cells?

a)

Converts decimals to commas within a cell

b)

Converts decimals to commas within merged cells

c)

Displays cell contents with two decimal places and commas as thousands separators

d)

Allows for substitution of selected characters

76.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

a)

exploded

b)

outer

c)

offset

d)

rasterized

77.

A thin red border indicates the active cell.

a)

True

b)

False

78.

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.

a)

True

b)

False

79.

Excel can display characters in only three font colors: black, red, and blue.

a)

True

b)

False

80.

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).

a)

True

b)

False

81.

A ____ is a prewritten formula that is built into Excel.

a)

function

b)

feature

c)

task

d)

calculation

82.

All of the following are valid Excel arithmetic operators EXCEPT ____.

a)

^

b)

*

c)

%

d)

>

83.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

a)

40

b)

26

c)

48

d)

13

84.

Which of the following Option buttons gives options for filling cells following a fill operation?

a)

Auto Fill Options

b)

AutoCorrect Options

c)

Insert Options

d)

Paste Options

85.

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

86.

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

a)

AutoCorrect

b)

Insert

c)

Auto Fill

d)

Paste

87.

The ____ function displays the highest value in a range.

a)

MIN

b)

SUM

c)

MAX

d)

AVERAGE

88.

The ____ function determines the lowest number in a range.

a)

LOW

b)

BASE

c)

LEAST

d)

MIN

89.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

a)

scheme

b)

gallery

c)

theme

d)

style

90.

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.

a)

Comma style format

b)

Accounting number format

c)

Percent style format

d)

Currency style format

91.

A ____ is text and graphics that print at the bottom of every page.

a)

footer

b)

toe

c)

margin

d)

stopper

92.

The equal sign (=) precedes a formula.

a)

True

b)

False

93.

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

a)

True

b)

False

94.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

a)

True

b)

False

95.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

a)

True

b)

False

96.

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

97.

The range automatically selected by Excel is always correct.

a)

True

b)

False