Question 1

Banding refers to ________.
A)adding a total row to a table
B)adding a chart to a table
C)taking a format from one table and copying it to another table
D)alternating the background color of rows and/or columns

Accepted Answer

Banding refers to the practice of alternating the background color of rows and/or columns in a table to improve readability.

Question 2

Which of the following statements about cell alignment is FALSE?
A)Cells can be aligned on the horizontal axis.
B)Most text formatting aligns right.
C)Most number, date, and time formats align right.
D)Cells can be aligned on the vertical axis.

Accepted Answer

Most text formatting aligns left by default, not right.

Question 3

A table with odd rows in one color and even rows in another color are said to have ________ rows.
A)constant
B)hard-coded
C)tabular
D)banded

Accepted Answer

Banded rows refer to the alternating color pattern used to distinguish between odd and even rows in a table.

Question 4

The ________ tool could be used to take an existing cell's format and apply it to other cells.
A)Workbook Theme
B)Table Style
C)Format Painter
D)Banding

Accepted Answer

The Format Painter tool can be used to take an existing cell's format and apply it to other cells.

Question 5

There are two methods for creating functions: typing in the function and through the Functions ________ dialog box.

Accepted Answer

The answer of There are two methods for creating functions:...

Question 6

Which of the following is NOT closely associated with tables?
A)charts
B)banding
C)total rows
D)caps

Accepted Answer

The answer of Which of the following is NOT closely...

Question 7

A series of numbers laid out in a spreadsheet is most consistent with a ________ format.
A)oral
B)narrative
C)tabular
D)graphical

Accepted Answer

A series of numbers in a spreadsheet is typically organized in a tabular format, which involves rows and columns.

Question 8

Information organized into rows and columns is said to be in ________ format.
A)oral
B)graphical
C)narrative
D)tabular

Accepted Answer

Information organized into rows and columns is referred to as being in tabular format.

Question 9

If all cell content in a worksheet is lined up along the left side of a cell, it has a left cell ________.
A)justification
B)constant
C)argument
D)alignment

Accepted Answer

Left alignment refers to the positioning of cell content along the left side of the cell.

Question 10

Which of the following statements about banding is FALSE?
A)Banding can be done manually.
B)Banding can be done for rows, but not for columns.
C)Banding can be used in tracking information.
D)If a row or column is deleted from a table, the banding will be automatically updated.

Accepted Answer

Banding can be applied to both rows and columns, not just rows.

Question 11

In the formula =E5, the value contained in E5 is known as a(n)________.
A)parameter
B)variable
C)argument
D)constant

Accepted Answer

The answer of In the formula =E5, the value contained...

Question 12

In the formula =3+5, the 3 and 5 are both examples of ________.
A)arguments
B)constants
C)variables
D)parameters

Accepted Answer

3 and 5 are both constants because they are fixed values that do not change.

Question 13

The PMT function's first argument is the periodic interest ________ of the loan.

Accepted Answer

The answer of The PMT function's first argument is the...

Question 14

The A1:A3 in the formula below is a(n)________.
=SUM(A1:A3)
A)variable
B)argument
C)parameter
D)constant

Accepted Answer

In the formula =SUM(A1:A3), A1:A3 is an argument, as it specifies the range of cells to be summed by the SUM function.

Question 15

Which of the following does the Format Painter NOT copy?
A)cell contents
B)alignment
C)borders
D)font colors

Accepted Answer

The answer of Which of the following does the Format...

Question 16

Both cells and tables can have ________, which provide pre-built, reusable formatting.
A)variables
B)styles
C)constants
D)banding

Accepted Answer

Styles provide pre-built, reusable formatting for both cells and tables.

Question 17

If a state's sales tax is stored in cell B2 and referenced in formulas, this value is known as a(n)________.
A)variable
B)parameter
C)constant
D)argument

Accepted Answer

A parameter is a value that is used in formulas and can be changed to affect the outcome of those formulas, such as a sales tax rate.

Question 18

Information presented in charts is said to be in ________ format.
A)narrative
B)tabular
C)graphical
D)oral

Accepted Answer

Charts present information in a graphical format, using visual elements like bars, lines, or pie slices to represent data.

Question 19

The Statistical Function Category is used when working with ________ calculations.

Accepted Answer

The answer of The Statistical Function Category is used when...

Question 20

A rough draft of a formula or code is also known as ________.

Accepted Answer

The answer of A rough draft of a formula or...

Quiz 5: Excel

Banding refers to ________.

Which of the following statements about cell alignment is FALSE?

A table with odd rows in one color and even rows in another color are said to have ________ rows.

The ________ tool could be used to take an existing cell's format and apply it to other cells.

There are two methods for creating functions: typing in the function and through the Functions ________ dialog box.

Which of the following is NOT closely associated with tables?

A series of numbers laid out in a spreadsheet is most consistent with a ________ format.

Information organized into rows and columns is said to be in ________ format.

If all cell content in a worksheet is lined up along the left side of a cell, it has a left cell ________.

Which of the following statements about banding is FALSE?

In the formula =E5, the value contained in E5 is known as a(n) ________.

In the formula =3+5, the 3 and 5 are both examples of ________.

The PMT function's first argument is the periodic interest ________ of the loan.

The A1:A3 in the formula below is a(n) ________. =SUM(A1:A3)

Which of the following does the Format Painter NOT copy?

Both cells and tables can have ________, which provide pre-built, reusable formatting.

If a state's sales tax is stored in cell B2 and referenced in formulas, this value is known as a(n) ________.

Information presented in charts is said to be in ________ format.

The Statistical Function Category is used when working with ________ calculations.

A rough draft of a formula or code is also known as ________.