CA Excel 1 and 2

3. a temporary storage area for selections you copy or cut
5. the sheet currently displayed in the workbook window
7. formats numbers as percentages with the % symbol after the number; you can change the number of decimal places that are shown
10. shows how the sheet will look when printed, including headers and footers
13. quickly inserts functions to sum, average, or count values in a range or find the minimum or maximum value in a range
14. a background color that can be added to cells
16. indicates how characters are emphasized (bold, italic, underline)
17. letters in boxes along the top of the workbook window
19. shows the contents of the sheet but not how the sheet will look printed
20. pre-designed combination of font, font size, and font color that you can apply to a cell
21. combine several cells into one cell
23. copies and pastes formatting from one cell or range to another without duplicating any data
25. a named operation that replaces the action of an arithmetic expression

1. a single sheet in a workbook file
2. a line added along the edge of a cell, row, column, or table
4. applies a format to a cell when its value meets a specified condition
6. each intersection of a row and column form a box where you enter and store data
7. rows and/or columns that are included on every page of the printout
8. shows where page breaks will occur in the printed sheets
9. formatting a cell based on its value, which helps draw attention to important or unusual results
11. increases or decreases the magnification of the worksheet content
12. the space between the page content and the edges of the page
15. specifies the size of the text characters measured in units called points
16. an expression that calculates a value
18. numbers in boxes along the left side of the workbook window
22. the appearance and shape of letters, numbers, and special characters
24. the range or ranges in a worksheet that you specify to be printed