MIS 301 Excel Exam

In Figure EX 2-1 above, the cell that shows wrapped text is __

A21

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

AutoFit

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ___ group, click the arrow next to the Font box to display a gallery of available fonts.

Font

As you format cells, __ shows the results of the different formatting options you can choose.

Live Preview

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.

Merge & Center

You can remove the borders from a selected cell by clicking ___ in the border style menu.

No Border

Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?

On the Home tab, in the Editing group, click the Find & Select button, and then click replace.

To change text orientation, select the cells whose contents you want to rotate. Click the ____ button in the Alignment group on the HOme tab of the Ribbon.

Orientation

Horizontal alignments do NOT include ____.

bottom

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

bottom-right

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

dialog box

You can select a different theme for your workbook. Click the __ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

page layout

You can change the width of several columns at a 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.

right

Excel ____ all numbers.

right-aligns

In Figure Ex 2-1 above, you can see that when you wrap text, the ___ increases automatically to display additional lines until all the text is visible.

row height

Data can be indented (or ____) within cells to help distinguish categories or set data apart.

shifted to the right

A __ is a preset collection of design elements, including fonts, colors, and other effects.

theme

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

upper-left