Excel Core Lesson 7 & 8 Test

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

The __________ is the line between rows or columns.

• Border line

• Boundary

• Header

• Move line

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

• Header

• Footer

• Headnote

• Footnote

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

• Row height

• Row size

• Row dimension

• Row margin

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

• Zoom out

• Shrink page

• Make fit

• Scaling

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

• theme

• styles

• template

• design

What option allows you to force rows or columns to be printed on each page of a multi-page worksheet?

• Print rows/columns

• Print area

• Print titles

• Print headings

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.