Design:
Exercise Excel 5-6

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 uses files from Project 4. Save the changed documents to your Class disk in the excel project5 folder. This keeps the original files intact in case you need to start over.
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 & FormulasTo subtopics

Project 5: Design
    Analysis To subtopics
    What If...To subtopics
    Logical TestsTo subtopics
    Sharing DataTo subtopics
    Summary
    Quiz
    Exercises To subtopics
    Exercise Ex. 1 Theater Tickets
    Exercise Ex. 2 Soccer - IF
    Exercise Ex. 3 Soccer - What If
    Exercise Ex. 4 Computers Today
    Exercise Ex. 5 Ticket subtotals
    Exercise Ex. 6 On Your Own

Search 
Glossary  
Appendix

Exercise Excel 5-6:

On Your Own

What you will do: design a sheet yourself

Create a What-If sheet of your own that is a tool to help you look at the effects of various possibilities.

You may base your What-If sheet on a sheet you created for one of the other projects or you may start something new. You might create a grade calculator for one of your classes using the actual grading scheme your teacher uses.  Or you could design a budget planner for yourself or for a club you are in.

Follow all of the Planning Checklist steps. 

Design a sheet that looks great when printed rather than being very concerned about how it looks on screen. It should print on 1 page, in either portrait or landscape orientation.

You must include:

  1. assumed (fixed) values
  2. input or changeable values
  3. calculated values
  4. comment(s) that contain the documentation
  5. formatting that shows clearly which values are fixed, which are input, which are calculated, which are final results