Excel Basics:
Exercise Excel 2-4

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



Exercise Excel 2-4: On Your Own


You can get creative now and design your own spreadsheet. Perhaps you could do a personal budget or one for a club or team you are a member of. You could use data you recorded from an experiment or a survey. Be sure everything is neat and easy to read.

Be sure to include in your spreadsheet at least:

  1. a title
  2. a subtitle
  3. column labels
  4. row labels
  5. at least 10 rows of data.
  6. AutoSum either a column or a row
  7. Calculate with a formula besides AutoSum. (Suggestion: use AVERAGE, MAX, or MIN)
  8. Size columns wide enough to view all data and text
  9. a header with your name and date on the left, the file and sheet names in the middle, and  Exercise Excel 2-4  on the right.
  10. a Chart on a separate sheet
     

Print Print all sheets




Where you are:
JegsWorks > Lessons > Numbers

Before you start...

Project 1: Excel IntroTo subtopics

Project 2: Excel Basics  
   
Getting StartedTo subtopics      
    ArrangeTo subtopics  
    AutoFillTo subtopics
    FinishTo subtopics
    Summary
    Quiz
    Exercises arrow to open subtopics
      Exercise" Ex. 1 Theater tickets
      Exercise" Ex. 2 Soccer budget
      Exercise" Ex. 3 Pings
      Exercise" Ex. 4 On Your Own

Project 3: Format & ArrangeTo subtopics

Project 4: Groups & FormulasTo subtopics

Project 5: DesignTo subtopics


Search
Glossary
Appendix