Question 1

________ is the operator for performing division.
A) |
B) /
C) \
D) ^

Accepted Answer

The / symbol is used to represent division in most programming languages.

Question 2

A(n) ________ cell is formed by combining several cells into a single new cell.
A) merged
B) joined
C) conjoined
D) united

Accepted Answer

The correct term used in spreadsheet and document editing software for combining several cells into a single new cell is "merged."

Question 3

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

Accepted Answer

The Cell Margins command is used to adjust the amount of white space inside a cell as well as the space between cells. Table Margins refers to the space outside of the table itself, while Table and Cell Alignment deal with positioning the entire table or individual cells within a document.

Question 4

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

Accepted Answer

In Word's order of operations, performing addition is typically the last step after evaluating parenthetical information, performing exponentiation, and performing division or multiplication.

Question 5

When drawing a table, the pointer looks like a ________.
A) pen
B) pencil
C) paint brush
D) vertical bar

Accepted Answer

The answer of When drawing a table, the pointer looks...

Question 6

A(n) ________ is a grid of columns and rows that is used to organize data.
A) matrix
B) array
C) list
D) table

Accepted Answer

A table is specifically designed for organizing data in a grid of columns and rows, making it the best choice for this definition. Matrices and arrays are similar to tables but may have different uses and formats. A list is typically used to organize data in a unstructured or non-grid format.

Question 7

A(n) ________ is used to perform calculations that add, subtract, divide, or multiply cell contents.
A) argument
B) variable
C) function
D) formula

Accepted Answer

Formulas are used in spreadsheets to perform calculations using cell contents. They can include arithmetic operations such as addition (+), subtraction (-), multiplication (*), and division (/), as well as other functions and operators.  Arguments and variables are not specific to spreadsheet calculations, and while functions can be used in calculations, they are not the primary tool for performing mathematical operations in a spreadsheet.

Question 8

Which of the following operators is used for performing exponentiation?
A) *
B) /
C) #
D) ^

Accepted Answer

The caret symbol (^) is used for performing exponentiation in many programming languages and mathematical notations.

Question 9

Which of the following number formats suppress leading zeros?
A) #
B) 0
C) &
D) ^

Accepted Answer

The "#" format in various programming and spreadsheet environments is used to suppress leading zeros, displaying numbers without any leading zeros that might otherwise precede the first significant digit.

Question 10

A ________ is formed by the intersection of a column and a row.
A) cubical
B) cell
C) chamber
D) compartment

Accepted Answer

A cell is a small unit or compartment that is formed by the intersection of a row and a column in a table or spreadsheet. Options A, C, and D do not accurately describe the intersection of a row and a column.

Question 11

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

Accepted Answer

According to the order of operations, multiplication is performed before addition. Therefore, the operation D3 * 2 is calculated first (4 * 2 = 8), and then C5 (which is 10) is added to the result. So, 10 + 8 = 18.

Question 12

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

Accepted Answer

A table style is a named set of color, font, and border designs that can be applied to a table. A table style includes formatting such as background color, font size, and border style.

Question 13

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

Accepted Answer

A data source is a list of variable information, such as names and addresses, that is used to populate a document using mail merge. The other options are not specific to a data source in this context.

Question 14

When using Word's order of operations, which of the following operations is performed first?
A) ^
B) *
C) /
D) #

Accepted Answer

In Word's order of operations, exponents (^) are performed first, followed by multiplication (*), division (/), and finally addition (+) and subtraction (-). The symbol "#" is not a valid operation in Word.

Question 15

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

Accepted Answer

An insert control is a symbol that displays between rows or columns in a table to indicate where a new row or column can be added. It typically looks like a plus symbol or an arrow pointing up and to the right.

Question 16

________ is the process of taking a single cell and dividing into multiple cells.
A) Splitting
B) Fragmenting
C) Parting
D) Parceling

Accepted Answer

The process of taking a single cell and dividing it into multiple cells is typically called cell division or cell splitting. Options B, C, and D do not accurately describe this process.

Question 17

Table ________ refers to the horizontal position of a table between the left and right document margins.
A) indentation
B) spacing
C) orientation
D) alignment

Accepted Answer

Table alignment refers to the horizontal position of a table between the left and right document margins. Indentation refers to the space between the table content and the table border, spacing refers to the distance between cells in a table, and orientation refers to the direction the table is facing (e.g. landscape or portrait).

Question 18

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

Accepted Answer

According to the order of operations in Word (and in most mathematical contexts), we evaluate expressions within parentheses before performing any other operations.

Question 19

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

Accepted Answer

The mail merge process allows for content from a main document and a data source to be combined, giving the option to create a new document. The Mail Wizard, Form Letter, and Mailings are all related features within Microsoft Word that can be used in conjunction with the mail merge process but do not fully encompass its functionality.

Question 20

COUNT is an example of a(n) ________.
A) argument
B) parameter
C) function
D) formula

Accepted Answer

COUNT is a function in Excel that counts the number of cells in a range that contain numbers.

Quiz 3: Document Productivity

________ is the operator for performing division.

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

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

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

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

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

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

Which of the following operators is used for performing exponentiation?

Which of the following number formats suppress leading zeros?

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

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

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

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

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

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

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

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

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

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

COUNT is an example of a(n) ________.