Document Productivity Ch3 Test Bank Docx

Exploring MS Office 365, Word 2019 Comprehensive (Poatsy)

Chapter 3 Document Productivity

1) The ________ process combines content from a main document and a data source, with the choice of creating a new document.

A) Mail Wizard

B) Form Letter

C) Mail Merge

D) Mailings

Diff: 2

Objective: W3.05 Create a Mail Merge Document

2) A ________ is a list of variable information such as a name and address that is included in a document.

A) record

B) header row

C) merge field

D) data source

Diff: 2

Objective: W3.05 Create a Mail Merge Document

3) A(n) ________ is a grid of columns and rows that is used to organize data.

A) matrix

B) array

C) list

D) table

Diff: 1

Objective: W3.03 Manage Table Data

4) A ________ is formed by the intersection of a column and a row.

A) cubical

B) cell

C) chamber

D) compartment

Diff: 1

Objective: W3.03 Manage Table Data

5) When drawing a table, the pointer looks like a ________.

A) pen

B) pencil

C) paint brush

D) vertical bar

Diff: 3

Objective: W3.01 Insert a Table

6) A(n) ________ is an indicator that displays between rows or columns in a table and is used to add rows or columns.

A) insert control

B) pencil

C) pen

D) brush

Diff: 2

Objective: W3.01 Insert a Table

7) A(n) ________ cell is formed by combining several cells into a single new cell.

A) merged

B) joined

C) conjoined

D) united

Diff: 1

Objective: W3.01 Insert a Table

8) ________ is the process of taking a single cell and dividing into multiple cells.

A) Splitting

B) Fragmenting

C) Parting

D) Parceling

Diff: 1

Objective: W3.01 Insert a Table

9) A table ________ is named set of color, font, and border designs that can be applied to a table.

A) form

B) theme

C) template

D) style

Diff: 2

Objective: W3.02 Format a Table

10) Table ________ refers to the horizontal position of a table between the left and right document margins.

A) indentation

B) spacing

C) orientation

D) alignment

Diff: 1

Objective: W3.02 Format a Table

11) You would use the ________ command to adjust the amount of white space inside a cell as well as the space between cells.

A) Table Margins

B) Cell Margins

C) Table Alignment

D) Cell Alignment

Diff: 2

Objective: W3.02 Format a Table

12) A(n) ________ is used to perform calculations that add, subtract, divide, or multiply cell contents.

A) argument

B) variable

C) function

D) formula

Diff: 2

Objective: W3.03 Manage Table Data

13) COUNT is an example of a(n) ________.

A) argument

B) parameter

C) function

D) formula

Diff: 2

Objective: W3.03 Manage Table Data

14) Which of the following number formats suppress leading zeros?

A) #

B) 0

C) &

D) ^

Diff: 3

Objective: W3.03 Manage Table Data

15) Which of the following operators is used for performing exponentiation?

A) *

B) /

C) #

D) ^

Diff: 3

Objective: W3.03 Manage Table Data

16) In Word's order of operations, which of the following is the first step in evaluating an expression?

A) Performing multiplication

B) Evaluating parenthetical information

C) Performing division

D) Performing subtraction

Diff: 2

Objective: W3.03 Manage Table Data

17) In Word's order of operations, which of the following is the last step in evaluating an expression?

A) Performing addition

B) Evaluating parenthetical information

C) Performing division

D) Performing exponentiation

Diff: 2

Objective: W3.03 Manage Table Data

18) When using Word's order of operations, which of the following operations is performed first?

A) ^

B) *

C) /

D) #

Diff: 3

Objective: W3.03 Manage Table Data

19) ________ is the operator for performing division.

A) |

B) /

C) \

D) ^

Diff: 2

Objective: W3.03 Manage Table Data

20) Using Word's order of operations, if cell C5 contains 10, and D3 contains 4, then result of =C5+D3 * 2 is ________.

A) 7

B) 28

C) 12

D) 18

Diff: 3

Objective: W3.03 Manage Table Data

21) Using Word's order of operations, if cell K4 contains 6, J5 contains 2, and M2 contains 12, then result of =M2*(K4-J5) is ________.

A) 70

B) 0

C) 48

D) 3

Diff: 3

Objective: W3.03 Manage Table Data

22) A series of adjacent cells is called a ________.

A) record

B) range

C) field

D) table

Diff: 2

Objective: W3.03 Manage Table Data

23) Which of the following is not a Word function?

A) SUM

B) MEAN

C) COUNT

D) MIN

Diff: 3

Objective: W3.03 Manage Table Data

24) When working with a function, the positional information within parentheses is referred to as a(n) ________.

A) argument

B) field

C) parameter

D) formula

Diff: 2

Objective: W3.03 Manage Table Data

25) Which of the following is a positional argument?

A) FIRST

B) NEXT

C) BEFORE

D) BELOW

Diff: 3

Objective: W3.03 Manage Table Data

26) A(n) ________ is a line style applied to individual cells, an entire table, or individual areas within a table.

A) border

B) outline

C) margin

D) frame

Diff: 1

Objective: W3.04 Enhance Table Data

27) Word's ________ tool permits you to easily apply border settings you have identified to one or more table borders.

A) Format Wizard

B) Border Wizard

C) Format Painter

D) Border Painter

Diff: 1

Objective: W3.04 Enhance Table Data

28) You can use ________ to apply color or a pattern to the background of a cell or group of cells.

A) highlighting

B) filling

C) shading

D) shadowing

Diff: 1

Objective: W3.04 Enhance Table Data

29) Which of the following is not true about form letters?

A) It is often mass produced.

B) A small amount of information can be included.

C) They cannot be personalized.

D) They use the Mail Merge feature.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

30) In Word, the term ________ refers to a numbered item of text that identifies a table, figure, or other object.

A) comment

B) caption

C) note

D) annotation

Diff: 2

Objective: W3.04 Enhance Table Data

31) ________ are items that operate as placeholders for the variable data that will be inserted into the main document during a mail merge procedure.

A) Merge fields

B) Records

C) Header rows

D) Functions

Diff: 2

Objective: W3.05 Create a Mail Merge Document

32) A ________ guides you through a process one step at a time, asking questions and using your responses to direct the final result.

A) function

B) pop-up menu

C) dialog box

D) wizard

Diff: 2

Objective: W3.05 Create a Mail Merge Document

33) A ________ is a collection of related fields representing a single entity, such as data for one person.

A) column

B) data source

C) record

D) header row

Diff: 2

Objective: W3.05 Create a Mail Merge Document

34) A ________ is the smallest data element in a table.

A) header row

B) record

C) field

D) data source

Diff: 2

Objective: W3.05 Create a Mail Merge Document

35) The ________ row in a data source identifies the fields in the remaining rows.

A) header

B) leader

C) range

D) record

Diff: 2

Objective: W3.05 Create a Mail Merge Document

36) Limiting the club members in a data source to only those who live in area code 14072 is an example of ________.

A) filtering

B) sorting

C) merging

D) sifting

Diff: 2

Objective: W3.05 Create a Mail Merge Document

37) <<FirstName>> is an example of a(n) ________.

A) address block

B) merge field

C) record

D) insert control

Diff: 2

Objective: W3.06 Complete a Mail Merge

38) To complete a mail merge, you use the Mail Merge ________.

A) Control

B) Template

C) Wizard

D) Theme

Diff: 1

Objective: W3.06 Complete a Mail Merge

39) Merge fields are bracketed by ________.

A) {{ }}

B) [[ ]]

C) << >>

D) (( ))

Diff: 2

Objective: W3.06 Complete a Mail Merge

40) You can use Word's Mail Merge process to combine content from a main document and a data source.

Diff: 1

Objective: W3.05 Create a Mail Merge Document

41) In a table, a cell is formed by the intersection of a column and a row.

Diff: 1

Objective: W3.03 Manage Table Data

42) A table is a grid of columns and rows in which data is organized.

Diff: 1

Objective: W3.01 Insert a Table

43) A 4 x 3 table consists of 4 rows and 3 columns.

Diff: 2

Objective: W3.01 Insert a Table

44) Since a table is an object, it can be selected and manipulated independently of its surrounding text.

Diff: 1

Objective: W3.01 Insert a Table

45) Splitting a cell takes a single cell and divides it into multiple cells.

Diff: 1

Objective: W3.01 Insert a Table

46) Pressing Enter moves from one cell to another.

Diff: 2

Objective: W3.01 Insert a Table

47) Pressing Tab in the last cell in a table inserts a new row.

Diff: 2

Objective: W3.01 Insert a Table

48) To delete the contents of a cell, click anywhere in the cell and press Delete.

Diff: 2

Objective: W3.01 Insert a Table

49) When you insert a table, Word automatically aligns it equally between the left and right margins.

Diff: 3

Objective: W3.02 Format a Table

50) When indicating a cell reference, you must be careful to capitalize the address.

Diff: 1

Objective: W3.03 Manage Table Data

51) AVERAGE is an example of a function.

Diff: 2

Objective: W3.03 Manage Table Data

52) When referencing a cell, the columns are designated with letters and rows with numbers.

Diff: 1

Objective: W3.03 Manage Table Data

53) The & number format suppresses leading zeros.

Diff: 2

Objective: W3.03 Manage Table Data

54) # is the Word operator for multiplication.

Diff: 2

Objective: W3.03 Manage Table Data

55) Using Word's order of operations, if cell F5 contains 1, and C4 contains 3, then result of =F5+C4^2 is 16.

Diff: 3

Objective: W3.03 Manage Table Data

56) When using Word's order of operations, ^ is performed before *.

Diff: 3

Objective: W3.03 Manage Table Data

57) When using Word's order of operations, subtraction is performed before division.

Diff: 1

Objective: W3.03 Manage Table Data

58) Unlike Microsoft Excel, a formula in a table is not automatically updated when you change the contents of cells referenced by the formula.

Diff: 3

Objective: W3.03 Manage Table Data

59) The MINIMUM function displays the smallest number in a series of cells.

Diff: 3

Objective: W3.03 Manage Table Data

60) LEFT is an example of a positional argument.

Diff: 2

Objective: W3.03 Manage Table Data

61) Repeated table heading rows are only seen in Print Layout view.

Diff: 3

Objective: W3.03 Manage Table Data

62) Rows of text, dates, or numbers in a Word table can be sorted alphabetically, chronologically, or numerically.

Diff: 1

Objective: W3.03 Manage Table Data

63) A border is a line style applied to individual cells, an entire table, or individual areas within a table.

Diff: 1

Objective: W3.04 Enhance Table Data

64) You can use Word's Format Painter to easily apply border settings you have identified to one or more table borders.

Diff: 2

Objective: W3.04 Enhance Table Data

65) Shadowing applies color or a pattern to the background of a cell or group of cells.

Diff: 2

Objective: W3.04 Enhance Table Data

66) Merge ranges are items that serve as placeholders for the variable data that will be inserted into the main document during a mail merge procedure.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

67) Arranging the students in a college data source by their GPA is an example of filtering.

Diff: 1

Objective: W3.05 Create a Mail Merge Document

68) Use a table style when you want to create a color-coordinated, professional document

Diff: 1

Objective: W3.02 Format a Table

69) An Outlook contact list can be used as a data source.

Diff: 1

Objective: W3.05 Create a Mail Merge Document

70) Arranging the students in a college data source by their GPA is an example of filtering.

Diff: 1

Objective: W3.05 Create a Mail Merge Document

71) Merge fields are surrounded by {{ }}.

Diff: 2

Objective: W3.06 Complete a Mail Merge

72) A(n) ________ is a document that is frequently mass produced and sent to multiple recipients.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

73) A(n) ________ is a list of variable data to include in the document, effectively personalizing it, such as your name and major.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

74) Column ________ is the horizontal space from the left edge to the right edge of a column.

Diff: 1

Objective: W3.01 Insert a Table

75) You can use Excel's ________ feature to automatically adjust rows and columns to accommodate their contents.

Diff: 2

Objective: W3.01 Insert a Table

76) The ________ control displays when you point to an edge of a row or column.

Diff: 2

Objective: W3.01 Insert a Table

77) Word's table ________ contain borders, shading, font sizes, and other attributes to enhance the readability of a document.

Diff: 2

Objective: W3.02 Format a Table

78) The top row in a data source is called the ________ row and identifies the fields in the succeeding rows.

Diff: 2

Objective: W3.02 Format a Table

79) Arranging the patients in a dental data source by patient's ages is an example of ________.

Diff: 1

Objective: W3.02 Format a Table

80) A(n) ________ is calculation that adds, subtracts, divides, or multiplies cell contents.

Diff: 2

Objective: W3.03 Manage Table Data

81) A(n) ________ is a built-in formula that simplifies the task of carrying out basic calculations.

Diff: 2

Objective: W3.03 Manage Table Data

82) SUM is an example of a(n) ________.

Diff: 2

Objective: W3.03 Manage Table Data

83) The ________ number format indicates that leading zeros are displayed.

Diff: 3

Objective: W3.03 Manage Table Data

84) ________ is the operator for performing multiplication.

Diff: 2

Objective: W3.03 Manage Table Data

85) Using Word's order of operations, if cell A3 contains 8, and C2 contains 6, then result of =A3-C2/2 is ________.

Diff: 3

Objective: W3.03 Manage Table Data

86) "Please Excuse My Dear Aunt Sally" helps you to remember ________ of operations.

Diff: 1

Objective: W3.03 Manage Table Data

87) The ________ function displays the largest number in a series of cells.

Diff: 3

Objective: W3.03 Manage Table Data

88) Word's sorting feature allows you to sort a table by a maximum of ________ categories.

Diff: 3

Objective: W3.03 Manage Table Data

89) You can use Word's ________tool to easily apply border settings you have identified to one or more table borders.

Diff: 2

Objective: W3.04 Enhance Table Data

90) ________ refers to the application of color or a pattern to the background of a cell or group of cells.

Diff: 2

Objective: W3.04 Enhance Table Data

91) Word's ________ process combines content from a main document and a data source.

Diff: 2

Objective: W3.02 Format a Table

92) A(n) ________ field is an item that serves as a placeholder for the variable data that will be inserted into the main document during the mail merge procedure.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

93) A(n) ________ is group of related fields representing one entity, such the data for a sports event.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

94) An item of student information such as the student's academic average is an example of a(n) ________.

Diff: 2

Objective: W3.05 Create a Mail Merge Document

95) <<AddressBlock>> is an example of a(n) ________.

Diff: 2

Objective: W3.06 Complete a Mail Merge

96) Match each of the following terms to their meanings:

I. Table

II. Insert control

III. Cell

IV. AutoFit

V. Record

A. Grid of columns and rows that organizes data

B. The intersection of a column and a row

C. Feature that automatically adjusts the size of rows and columns

D. Group of related fields representing one entity

E. Indicator that is used to add rows or columns to a table

Diff: 3

Objective: Multiple Objectives

97) Match each of the following terms to their meanings:

I. Merged cell

II. Table style

III. Table alignment

IV. Table Move handle

V. Cell Margins command

A. Horizontal position of a table between the left and right document margins

B. Used to reposition a table in a document

C. Formed by combining several cells into a single new cell

D. Adjusts the amount of white space inside a cell as well as the space between cells

E. Contains borders, shading, font sizes, and other attributes to enhance the readability of a document

Diff: 3

Objective: Multiple Objectives

98) Match each of the following terms to their meanings:

I. Caption

II. Formula

III. Range

IV. Argument

V. Field

A. Series of adjacent cells

B. Calculation that adds, subtracts, divides, or multiplies cell contents

C. Numbered item of text that identifies a table, figure, or other object

D. Positional information within parentheses in a function

E. Smallest data element in a table

Diff: 3

Objective: Multiple Objectives

99) Match each of the following terms to their meanings:

I. Shading

II. Border

III. Function

IV. Mail merge

V. Order of operations

A. Built-in formula that simplifies the task of carrying out basic calculations

B. Line style applied to individual cells, to an entire table, or to individual areas within a table

C. Determines the sequence in which mathematical calculations are performed

D. Process that combines content from a main document and a data source

E. Color or a pattern applied to the background of a cell or group of cells

Diff: 3

Objective: Multiple Objectives

100) Match each of the following functions to their actions:

I. SUM

II. AVERAGE

III. COUNT

IV. MAX

V. MIN

A. Determines the number of entries in a series of cells

B. Averages a series of cells

C. Displays the largest number in a series of cells

D. Totals a series of cells

E. Displays the smallest number in a series of cells

Diff: 3

Objective: W3.03 Manage Table Data