Excel Lessons 7 & 8

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 you 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 boundary is the line between rows or columns.

• True
• False

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

• True
• False

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

• True
• False

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

• True
• False

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

• True
• False

A(n) theme is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.

• True
• False