# Excel Intro: Exercise Excel 1-2

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.

Where you are:
JegsWorks > Lessons > Numbers

Project 3: Format & Arrange

Project 4: Groups & Formulas

Project 5: Design

Search
Glossary
Appendix

## Exercise Excel 1-2: AutoSum, Sort, & Format

 What you will do: save a copy of a spreadsheet use AutoSum sort rows format numbers save and print

Use the toolbar buttons for AutoSum and sorting to create totals and arrange the rows.

1. From your resource files in the numbers folder open the file halfyear.xls, or  download the file directly.

2. Select from the File menu. In the Save As dialog, click the New Folder button and create a new folder in the my docs folder:  excel project1

3. Save the workbook as halfyeartotals.xls to the excel project1 folder.

### AutoSum and Sort

1. Row Totals: Use AutoSum to create row totals in Column I. After you get two values in Column I, Excel will try to sum the column instead of the row. Change the range when that happens. Remember to press ENTER to accept the formula.

2. Sort: Sort the category rows, Rows 7 - 19, into alphabetical order.
Your formulas refer only to cells in the same row, so you will not mess up the formulas by sorting. Whew!

3. Column Totals: Use AutoSum to create column totals in Row 21. Again Excel will get confused after you have two values in the row. It will try to sum the row instead of the column. Change the range when that happens.

4. Grand Total: In cell I22 use AutoSum to create a grand total, but change the range to include all the cells with Light Turquoise background, B7:H20. Type Grand Total = in cell G22.

### Format Numbers

1. Format currency: Format the new totals in column I and in Row 21 and in cell I22 as Currency

2. Format decimals: There is one value in the table data with a decimal point. Increase the decimals by one for that value.

3. Format Painter: Use the Format Painter button to copy the format of cell E14 to range G22:I22, the grand total and its label. While that range is selected, make the cells bold. Reset I22 to Currency.

4. Label sheet: Select cell D1 and type your name and press ENTER. Select cell E1 and type the date and press ENTER. Select cell D2 and type Exercise Excel 1-2

5. Prepare to Print: Switch to Print Preview. Check what will print. Make corrections if necessary. This sheet prints on two pages.

6. Save.
How to handle a full disk

7. Print.