Lessons 6 and 7

3. A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.
7. An Excel view that enables you to see what your document will look like before sending it to the printer.
8. A formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands.
10. A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.
11. Text or a picture that appears in the background of a document; it is similar to a sheet background in Excel.
17. A tool that enables you to control specifically what you want to paste after using the Copy or Cut commands, such as cell content, formulas, values, formatting, and much more.
18. Changes your cell data to change orientation.
20. An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.
21. The top-to-bottom measurement of a row.
22. The empty area of a document in which no content appears.
23. The left-to-right measurement of a column.
24. The lines that display around worksheet cells.
25. The identifying letter of a row.
27. A line of text that appears at the top of each page of a printed worksheet.
28. The line between rows or columns.

1. A set of text properties that affects the typeface, size, and similar aspects of text.
2. Lines of text that appear at the bottom of each page.
3. Shrinking or stretching printed output to a percentage of its actual size.
4. To automatically display data on the next line when it is too long to display within the cell’s width. Wrapping automatically increases a cell’s height.
5. A divider that breaks a worksheet into separate pages for printing.
6. A feature found in most Office applications that allows you to quickly copy formatting attributes that you have already applied and “paint” those attributes onto other text, shapes, pictures, and worksheet cells.
7. An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document.
9. Something that modifies the appearance of an object.
12. Arrange in a line or bring into alignment.
13. A formatting characteristic, such as bold, italic, or underlined text.
14. The identifying letter of a column.
15. Two or more cells combined into a single cell.
16. The position of the content in a worksheet, so that it prints either vertically or horizontally on a page.
19. A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.
26. A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.