Unit 7 - Formatting Cells and Ranges

Which of the following statements describes how to increase or decrease a column’s width?

• Right-click anywhere in the column and select Format Cells.

• Use the Page Setup dialog box.

• Drag the boundary next to the column heading.

• Select a Width setting in the Scale to Fit group on the Page Layout tab.

Which of the following dialog boxes is used to transpose rows and columns?

• Page Setup

• Paste Special

• Column Width

• Row Height

In which of the following locations are check boxes that you can select to view or print gridlines?

• In Print Preview

• On the Home tab, in the Cells group

• On the Page Layout tab, in the Sheet Options group

• On the Page Layout tab, in the Page Setup group

Which of the following statements describes how to unhide a hidden row or column?

• Select a range of cells in the row or column, right-click, and select Unhide.

• Use the Page Setup dialog box.

• Remove all page breaks.

• Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

The __________ is the line between rows or columns.

A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.

__________ is the top-to-bottom measurement of a row, measured in points.

The identifying letter at the top of a column is called the __________.

__________ refers to shrinking or stretching printed output to a percentage of its actual size.

A(n) __________ is a predefi­ned set of colors, fonts, and effects that can be applied to an entire workbook.