 |
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.
|
 |
 Where you are: JegsWorks >
Lessons >
Numbers
Before
you start...
Project 1: Excel Intro
Interface
Select & Navigate
Common
Tasks
Summary Quiz Exercises
Ex. 1: AutoCalculate
Ex. 2: AutoSum,
Sort, Format
Ex. 3: Chart
Project 2: Excel Basics
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
|
Start with:
budget.xls
from resource files
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.
- From your resource files, open the file budget.xls in the numbers
folder.
- 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.
- Select the named cell(s) below and on a separate sheet of paper write the
value that AutoCalculate shows.
- On sheet Budget - range B7:D13 = _____
- On sheet Budget - cells B25:B27, B30, B33,
B37, B39 = _____
- On sheet Actual - Row 15 = _____
- On sheet Actual - Rows 36 through 38 = _____
- On sheet Actual - Column F = _____
- On sheet Actual - Columns D, K, and L = _____
- On sheet Actual - ranges B15:D24 and I15:K24
= _____
- Named cell: TotalGrossSales = _____
- Named range: AugustInflows = _____
- Named range: Print_Area = _____
Check your answers
Hide the answers
1 |
Budget - range B7:D13 |
2,041,500.00 |
2 |
Budget - cells B25:B27, B30, B33, B37, B39 |
8,100.00 |
3 |
Actual - Row 15 |
807,840.00 |
4 |
Actual - Rows 36 through 38 |
599,624.80 |
5 |
Actual - Column F |
3,631,660.00 |
6 |
Actual - Columns D, K, L |
7,693,950.80 |
7 |
Actual - ranges B15:D24 and I15:K24 |
659,493.58 |
8 |
TotalGrossSales |
7,200,000.00 |
9 |
AugustInflows |
680,500.00 |
10 |
Print_Area |
32,187,080.00 |
Total |
|
55,509,749.18 |
|