Name __________________________________________________ Sect. _______ Score ______/25

Excel, Chapter 17 Review Sheet  

Complete the sentences below to hand in at the start of our next class.

1. p. 341: If you want text to span across several columns or rows, you ______________ cells, which combines several cells into a single cell.
2. p. 341: The __________________________ button on the Formatting toolbar automatically centers the text in merged cells.
3. p. 343: The ______________________ command will let you fill a series of numbers and increase or decrease the cell contents in increments based on the ________________ of the original contents.
4. p. 344: You can use the AutoFill feature to quickly fill in a series of __________________ and dates, or days of the week, etc.
5. p. 344: If you drag the fill handle up or to the left, the series will ______________________.
6. p. 345: AutoFormats instantly format the entire worksheet with ____________________, shading, and ___________________________.
7. p. 345: To apply an AutoFormat, you must first ______________________ the range to be formatted.
8. p. 345: You can _________________________ the formats after they are applied.
9. p. 346: Whenever you open a new worksheet in Excel, you automatically open a workbook with ______________ sheets (or worksheets) in it.
10. p. 346: To switch to a different worksheet, simply click on the worksheet _________________ at the bottom of the screen.
11. p. 346: You can add _________________________ worksheets to a workbook or remove unnecessary ones.
12. p. 347: To sort Excel data, you must indicate the ______________________ you want to base your sort on.
13. p. 347: Ascending order sorts alphabetically from A to Z or numerically from the _______________ ____________________________ number.
14. p. 347: Excel will automatically determine if you have a ________________________ (headings at the top of your columns), and it will not include this row in the sort.
15. p. 348: If you have a worksheet with multiple columns of data, you can base the sort on the data in _____________ different columns.
16. p. 348: When you want to sort by multiple criteria, you must open the Sort dialog box, which is available on the ___________________ menu in Excel.
17. p. 349: The page setup settings apply only to the ___________________ worksheet. They do not apply to all the worksheets in the workbook.
18. p. 352: You can change the orientation of text within a cell so the text sets at an _______________ or shrink the content to fit within the cell by using the Format Cells dialog box, under the Alignment tab.
19. p. 353: You can choose one of the __________________ (pre-made) headers or footers or you can create your own customized headers and footers.
20. p. 353: In Excel, formatting ___________________ are used in headers and footers to represent the items you want to appear. With these you can insert dates, times, filenames and ________________ automatically.
21. p. 356: When you click the Print button on the Standard toolbar, Excel prints the _______________ worksheet with the default print settings.
22. p. 356: To cancel a print job, click the Printer icon that appears on the __________________ at the bottom of your screen when you are printing. Then select the document name from the Print queue and then click Cancel Printing on the Document menu.