|
|
Excel Basics:
|
|
|
|
||
|
There are many choices for you to consider when setting up Excel to work in a way that is convenient for you. Options for the way Excel behaves are found on the menu | and in | . The Regional Settings for Windows 95/98 and the Regional and Language Option for WinXP control the measurement system, default currency, and format for dates and time. Cell contents can be edited on the Formula bar, or, if you double-click the cell, in the cell itself. Column Width and Row Height have default sizes but can be AutoFit to the cell contents or sized by dragging or with a dialog. AutoFill can copy cell contents or extend a pattern, even for formulas. AutoSum is a help in creating totals, but you may need to tell Excel which cells you really want to add. The Sort dialog lets you do a three level sort and even use a Custom List for the first level. The Chart Wizard lets you modify the choices as you go. Excel will print the whole sheet or just a selection or certain pages, using choices on the Print dialog. By setting a Print Area you can keep part of the sheet from printing at all. You manage the look of the printed page with the choices on the Margins and Sheet tabs of the Page Setup dialog. |
Project 2: Excel Basics
Search Glossary Appendix |
What You Printed for Project 2: Excel Basics | ||||
|
File and sheet |
What is it? |
# of pages |
||
|
1. |
myheader.xls |
just the page header |
1 page |
|
|
2. |
trips8.xls- Sheet1 |
totals finished |
1 page |
|
|
3. |
trips9.xls- Pie Chart |
chart |
1 page |
|
|
4. |
trips9.xls- Sheet1 |
with gridlines, row and column headings, centered horizontally and vertically. |
1 page |
|
|
5. |
trips9.xls- Sheet1 |
with added page break and printing titles |
2 pages |
|
|
6. |
trips9.xls- Sheet1- Selection |
selection of Tahiti trips only, no gridlines, no headings, not centered, including titles |
1 page |
|
Important Terms
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ |