Groups & Formulas:
Exercise Excel 4-4

Title: Jan's Illustrated Computer Literacy 101
Did you want Working with Numbers: 2007,2010,2013,2016  or españolIcon: Change web

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.

 

This exercise can be an extension of the one you started in Project 2 or it can be entirely new.
Full floppy disk How to handle a full disk

 

 


Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel BasicsTo subtopics    

Project 3: Format & ArrangeTo subtopics   

Project 4: Groups & Formulas
    SubtotalsTo subtopics
    Images & DrawingsTo subtopics
    Changes & FormulasTo subtopics
    Summary
    Quiz
    Exercises To subtopics
    Exercise Ex. 1 Amazon Pings
    Exercise Ex. 2 Theater Tickets
    Exercise Ex. 3 Computers Today
    Exercise Ex 4 On Your Own

Project 5: DesignTo subtopics

Search 
Glossary  
Appendix

Exercise Excel 4-4:

On Your Own
Use the spreadsheet you created for Exercise Excel 3-4  or create a new sheet. You should make the following changes or additions to a copy of the original sheet:
  • Sort
  • Create subtotals
  • Format data groups and/or subtotals
  • Insert image or AutoShapes for decoration or to point out special values
  • Insert or move columns or rows in a way that breaks formulas
  • Repair formulas

Print Print the original and revised versions with formulas displayed.

Print Print the revised version normally.

Full floppy disk How to handle a full disk

LessonsWorking with Numbers Previous Page Next Page

Teachers: Request permission to use this site with your class

Copyright © 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~

Last updated: 02 May 2012