Unit 1 Exercises

Why is an Excel file called a workbook?
Answer

What are constant values in an Excel file? Give some examples.
Answer

Bring up a blank workbook in Excel and press the [END] key, then a right arrow key. Where does the cursor move to? Again, press the [END] key, then the down arrow key. Where is the active cell sitting? What is the address of the lower right cell on a workbook page?
Answer

Open up the file FUNDRAS.XLS that you saved and use these same [END] and arrow keys in this file. What happens?

Practice using these movement keys in the file:

[PageUp]
[PageDown]
[End], then [Home]
[Home]
[Ctrl]+[Home] (pressing at the same time)

Using the FUNDRAS.XLS file, click on File on the menu bar, then Save As. Change the filename to PRACTICE.XLS

There are two ways to print a file, by clicking on the "Print" button on the Standard toolbar and by selecting File then Print. What is the difference in using these two options? Try both with your PRACTICE.XLS file.
Answer

Which of these are valid cell addresses?

          G3000     DH30      20AD
          b20       Ab6000    550

Answer

Using the PRACTICE.XLS file, highlight several cells and press the [DELETE] key. Now click on the "Undo" button on the Standard toolbar. What happens?
Answer
Close any spreadsheet files that are open. Click on File, then New to bring up a blank layout. Using the same skills you used earlier in this lesson, create this spreadsheet:
```
     A          B      C        D        E       F
1    Attendance                                  
2    Class      Fall   Winter   Spring   Summer  Totals
3    Plants     40     50       10       30      
4    Insects    100    50       60       35      
5    Money      10     40       60       30      
6    Leaders    35     75       10       40      
7    Totals     
```
Use the "AutoSum" button to calculate the totals. Save this file under the name of CLASSES. Practice printing this file; you can use the Print Preview screen and adjust the margins with the mouse first, if you want.
Check your work.

Here is another application to create:

        A         B     C      D      E
   1    Meeting Registration                           
   2                    Brunch Dinner   Tour
   3    Mary    Jones   1      2        1   
   4    Bill    Ramon   1      1        1   
   5    Sue     Black   2      3        3   
   6    Angie   Rivers  1      1        2   
   7    Harry   Adams   1      1        1   
   8    Totals

Save this under the name of REGISER.

Check your work.

Take the time to go through some of the online lessons found under HELP, then Examples and Demos. Focus for now on the lessons under "Selecting Cells," "Using Toolbars," and "Entering Data."
Use the "online tips" database to read more about various items covered in this lesson. Click on HELP, then "Search for Help on" and type in these phrases.
deleting, cells AutoSum button Print area
When Excel finds the term in the alphabetical listing, click on the "Show Topics" button and then pick out a topic from the lower half of the help screen. Click on the button "Go To" to read the online help. From the Help window, you can click on the "Print" button on the menu bar to have a printed copy, if you want. Close the Help window when you are through.

Learning Excel - Index