Question 1

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 2

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.
A) top
B) left
C) right
D) bottom

Accepted Answer

To adjust the width of several columns at the same time, you need to select them first. Once selected, you can use the mouse pointer to click and drag the right edge of one of the selected column headings.

Question 3

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 4

If you want to specify a precise column width, use the Column Width ____.
A) wizard
B) task pane
C) status bar
D) dialog box

Accepted Answer

The dialog box allows for precise input of column width in either characters or pixels. The other options listed do not provide this level of specificity.

Question 5

The Cell Styles library includes many predefined styles.

Accepted Answer

The answer of The Cell Styles library includes many predefined...

Question 6

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

Accepted Answer

This is true. You can remove formatting from cells by selecting the cells and then clicking the "Clear Formats" button in the "Home" tab of the Excel ribbon, or by pressing the keyboard shortcut "Ctrl+Shift+N".

Question 7

A format is the design of text.

Accepted Answer

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

Question 8

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 the formatting, it does not copy the contents of the cell.

Question 9

Press the Ctrl+B keys to apply bold.

Accepted Answer

Yes, pressing the Ctrl+B keys on a keyboard applies bold formatting to the selected text.

Question 10

Horizontal alignments do NOT include ____.
A) left
B) centered
C) right
D) bottom

Accepted Answer

Horizontal alignments only refer to left, centered, and right positioning of text or objects along the horizontal axis. Bottom positioning pertains to vertical alignment.

Question 11

____ determines the best width for a column or the best height for a row, based on its contents.
A) MaxFit
B) FitAuto
C) FitNow
D) AutoFit

Accepted Answer

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

Question 12

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.
A) bottom-right
B) upper-right
C) bottom-left
D) upper-left

Accepted Answer

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

Question 13

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

The steps outlined for resizing a column are correct.

Question 14

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 15

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 into the next cell if it is empty. This is called "spilling" and is a feature of Excel's dynamic arrays.

Question 16

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 does include a Protection tab which allows for locking and hiding cells in a protected workbook.

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

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

Accepted Answer

This format is known as the underline and double underline format and is commonly used in accounting and financial statements.

Question 19

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

Accepted Answer

The answer of Numbers that do not fit in the...

Question 20

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.

Quiz 24: Changing the Appearance of a Worksheet