Question 1

The Cell Styles library includes many predefined styles.

Accepted Answer

False

Question 2

____ determines the best width for a column or the best height for a row, based on its contents.

Accepted Answer

AutoFit determines the best width for a column or the best height for a row, based on its contents.

Question 3

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

Accepted Answer

This statement is true. The Format Cells dialog box includes a Protection tab that allows for locking and hiding cells in a protected workbook.

Question 4

Horizontal alignments do NOT include ____.

Accepted Answer

Horizontal alignments refer to the alignment of text or objects along the horizontal axis, which includes left, centered, and right. Bottom aligns content along the vertical axis, so it is not a horizontal alignment.

Question 5

Standard accounting format uses a single border below a column of numbers and a double border below the total .

Accepted Answer

This is the standard accounting format commonly known as the single-entry bookkeeping system.

Question 6

If you want to specify a precise column width, use the Column Width ____.

Accepted Answer

The dialog box allows you to enter a specific numerical value for the column width, making it the best choice for specifying a precise column width. The other options mentioned do not allow for as much precision in setting column widths.

Question 7

The default number format is General, which displays numbers the way you type them.

Accepted Answer

The default number format is indeed General, which displays numbers the way you type them.

Question 8

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

Accepted Answer

To change the background color of a cell, you should use the "Fill Color" button, not the "Background Color" button. The "Fill Color" button is located in the "Font" group on the "Home" tab of the Ribbon.

Question 9

A format is the design of text.

Accepted Answer

The answer of A format is the design of text....

Question 10

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

Accepted Answer

This statement is true. To remove formatting from a cell or range of cells, you can use the Clear Formats option in Excel.

Question 11

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

Accepted Answer

When text is too long to fit within a cell, it will spill over to the next cell if it is empty. This is known as "text wrapping."

Question 12

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

Accepted Answer

To change the width of several columns, you need to select the columns you want to resize and then click and drag the right edge of one of the selected column headings. This will change the width of all the selected columns equally. Choosing A, B, or D would not resize the columns.

Question 13

Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

Accepted Answer

Format Painter only copies formatting, not the cell contents.

Question 14

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

Accepted Answer

The Format Painter in Excel can be used to copy formatting to any cells or ranges, not just adjacent ones, by selecting the cell with the desired formatting, clicking the Format Painter, and then selecting any other cell or range to apply the formatting.

Question 15

Press the Ctrl+B keys to apply bold.

Accepted Answer

Pressing Ctrl+B will apply the bold formatting to the selected text.

Question 16

Numbers that do not fit in the cell are shown as a series of question marks (??????).

Accepted Answer

In spreadsheet software like Excel, numbers that do not fit in the cell are typically shown as a series of pound signs (#####), not question marks.

Question 17

Number fills change the way data looks in a cell.

Accepted Answer

Number formats change the appearance of numbers without altering the actual data stored in the cell.

Question 18

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

Accepted Answer

To remove a style from a selected cell, you should select the cell(s) and then choose the "Normal" style from the Cell Styles gallery, not "Good". The "Normal" style resets the cell to the default formatting.

Question 19

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

Accepted Answer

The answer of Unless you specify otherwise, numbers you enter...

Question 20

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

Accepted Answer

This is the correct method to resize a column in Microsoft Excel.

Quiz 8: Excel Lesson 2: Changing the Appearance of a Worksheet