Excel for Accounting Ch.2

A cell entry can only be indented if it is left-aligned True or False

False

A hidden row will appear when the worksheet is printed. True or False

False

All vertical alignment options are accessed directly on the Ribbon. True or False

False

By default, text entries are right-aligned and number entries are left-aligned. True or False

False

Neither row A nor column 1 can be hidden. True or False

False

The Merge & Center command can be used to merge individual rows of data simultaneously. True or False

False

When you delete cells, you must indicate how surrounding cells should shift. True or False

False

The deletion of a worksheet cannot be reversed with Undo. True or False

True

The most recently selected border option is displayed on the Border button on the Ribbon. True or False

True

When a rotation option is applied, row height automatically adjusts to fit the rotated cell entry. True or False

True

When a merge command is applied, the new merged cell takes on the name of which former cell? A. The cell formerly located in the top left of the merged area. B. The cell formerly located in the top right of the merged area. C. The cell formerly located in the bottom left of the merged area. D. The cell formerly located in the bottom right of the merged area.

A

Which of these is NOT a horizontal alignment option? A. Middle B. Left C. Right D. Center

A

When right-clicking to insert cells, which option does NOT appear? A. Entire Column B. Shift Cells Up C. Shift Cells Right D. Entire Row

B

When the Increase Indent command is applied, the cell entry: A. is always indented from the right edge of the cell. B. is indented from the right or left edge of the cell, depending on the type of entry. C. is always indented from the left edge of the cell. D. None of these; the user chooses how to indent.

B

Which element of a worksheet tab CANNOT be changed? A. Name B. Height C. Location D. Color

B

Which of these options does NOT appear on the Fill Color menu? A. Theme Colors B. Gradient Colors C. Standard Colors D. More Colors

B

Which of these options is NOT available on the Merge & Center menu on the Ribbon? A. Merge & Center B. Center C. Merge Across D. Unmerge Cells

B

How is a line break applied? A. Ctrl + Enter B. Ctrl + Shift C. Alt + Enter D. Alt + Shift

C

The Increase Indent button is displayed within which group on the Home tab? A. Clipboard B Font C. Alignment D. Number

C

What does a single bottom border withing a financial statement indicates? A. The move figures is the final figure within the statement. B. The above figure should be examined closely by management. C. A calculation is being performed on the figures above the border. D. The below figure is the final figure within the statement.

C