Excel 1 and 2
Across
- 5. ____________ indicates the column and row where a cell is located.
- 7. What Excel feature can you use to format a range so that all values greater than $500 automatically appear in red?
- 10. Use this button to combine multiple cells into one cell and center their contents.
- 11. What can you use to copy a cell's formatting to another cell?
- 13. When you double click the right border of a column heading it will __________ (resizes the column to accommodate the widest cell entry).
Down
- 1. Use the ______________ drop list to change the format of numbers, dates, etc..
- 2. If you do not want to delete a column but do not want to see it you can ________ a column.
- 3. Calcuation, Normal, Title, Input, Heading 1, are all examples of ______________.
- 4. If you want to print only part of a worksheet, you can set a _____________.
- 6. The __________ function will determine the number of nonblank cells in a range.
- 8. If you want to repeat the first row of a worksheet on each printed page use this option in the Page Setup dialog box.
- 9. If your worksheet is too wide to fit on one page in portrait orientation, but you want to print it on a single page change the orientation to ____________________.
- 12. Use this button/function for a fast and convenient way to add up a selected cell range.