Lesson 7: Formatting Worksheets

What can Abigail, Rohan, and Aria do with rows and columns in Excel worksheets?

• Insert or delete rows and columns

• Adjust row height and column width

• Apply formatting to entire rows and columns

• All of the above

What is a document theme in Excel?

• A predefined set of colors, fonts, and effects

• A way to format an entire workbook

• Can be shared across other Office applications

• All of the above

Where can Avery find check boxes 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

How do 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

What is the boundary in Excel?

• The line between rows or columns

• The line between cells

• The line between worksheets

• The line between headers and footers

What is a header in Excel?

• A line of text that appears at the top of each page of a printed worksheet

• A line of text that appears at the bottom of each page of a printed worksheet

• A line of text that appears at the top of each column

• A line of text that appears at the bottom of each row

What is the height of a row in Excel?

• The left-to-right measurement of a row

• The top-to-bottom measurement of a row

• The height of the row header

• The height of the footer

What is a column header in Excel?

• The identifying number of a column

• The identifying letter of a column

• The identifying number of a row

• The identifying letter of a row

What does scaling refer to in Excel?

• Shrinking or stretching printed output to a percentage of its actual size

• Changing the font size of the worksheet

• Changing the size of the page margins

• Changing the orientation of the worksheet

What is a theme in Excel?

• A predefined set of colors, fonts, and effects that can be applied to an entire workbook

• A way to insert headers and footers

• A way to hide or unhide rows and columns

• A way to transpose rows and columns