Design:
Summary

Title: Jan's Illustrated Computer Literacy 101

Documenting your sheet completely helps the user and later helps anyone who needs to modify the sheet. Your documentation can be shown directly on the sheet or in hidden comments. Comments can be formatted with the Drawing bar.

A What If sheet allows the user to see the effects of changing the input values.

Logical tests compare two statements. Logical operators include such things =, <, and >. A logical test must be either TRUE or FALSE. The IF function uses a logical test as the first argument. The second and third arguments are the values when the argument is true and when it is false.

Conditional formatting makes use of a logical test to set some of the formatting for a cell.

Parts of documents can be used in documents for other programs by embedding or linking the source data or by making a picture of the data. The method you use to include other documents will affect the size of the file. The file size of a document can be reduced by saving it under a new name.


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
    ExercisesTo subtopics


Search
Glossary
Appendix

Important Terms

absolute reference

argument

assumed values

AutoCalculate

AutoSum

collapse group

 

comment

comment indicator

concatenation

conditional formatting

convert

edit in place

 

embedded object

expand group

group

icon link

linked object

picture object

 

Print as displayed

Print at end

Sort

Split

Subtotal

Ungroup

What If sheet


LessonsWorking with Numbers Previous Page Next Page


Teachers: Request permission to use this site with your class

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

Icon: CDDownload lessons
Want to help?


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


Last updated: 22 Jan 2008