# Excel Intro: Exercise Excel 1-1

Did you want Working with Numbers: 2007,2010,2013,2016  or español

You need to use what you just learned, and maybe learn a little more. Complete all parts of the following exercises. Don't forget to backup your Class disk when you have completed the exercises or whenever you stop for the day and saved a document along the way.

These exercises use files from the numbers resource files. The default location for these files is c:\My Documents\complit101\numbers\ You cannot make changes to these files and save them in the same place. Save the changed documents to your Class disk. This keeps the original resource files intact in case you need to start over or another student will be using this same computer.
How to handle a full disk

Where you are:
JegsWorks > Lessons > Numbers

Project 3: Format & Arrange

Project 4: Groups & Formulas

Project 5: Design

Search
Glossary
Appendix

## Exercise Excel 1-1: Select and AutoCalculate

 What you will do: show that you can select cells, rows, columns, ranges use AutoCalculate to add up selected cells

Show you have mastered selecting and navigating in Excel by using the method of your choice to select the cell(s) listed below. Write down the value that AutoCalculate gives on the status bar.

1. From your resource files, open the file budget.xls in the numbers  folder.

2. Set AutoCalculate: Right click on the status bar. Click on so that it will be the function that AutoCalculate will use.

Problem: AutoCalculate area does not appear
You used the link above and budget.xls opened in an Internet Explorer window instead of in a normal Excel window.
Solution: Save the file to your hard drive and open from inside Excel.

3. Select the named cell(s) below and on a separate sheet of paper write the value that AutoCalculate shows.
1. On sheet Budget - range B7:D13  = _____
2. On sheet Budget - cells B25:B27, B30, B33, B37, B39 = _____
3. On sheet Actual - Row 15  = _____
4. On sheet Actual - Rows 36 through 38 = _____
5. On sheet Actual - Column F = _____
6. On sheet Actual - Columns D, K, and L = _____
7. On sheet Actual - ranges B15:D24 and I15:K24 = _____
8. Named cell: TotalGrossSales = _____
9. Named range: AugustInflows = _____
10. Named range: Print_Area = _____