Design:
Summary

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



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


What You Printed for Project 5: Design

 

File and sheet

What is it?

# of pages

1.

trips31.xls -
   sheet Specials

Analysis of the sheet (printed page 2 of sheet only) 1 page

2.

trips33.xls -
   sheet Specials
sheet with analysis in a blue comment 1 page

3.

trips32.xls -
   sheet Specials
comments at end only 1 page

4.

sketch of layout Your ideas for the Bonus calculator sheet 1 page

5.

trips35.xls -
   sheet Bonus
Bonus calculator for Gardner and comments 2 pages

6.

trips37.xls -
   sheet Bonus
Bonus sheet with formulas for Gardner (no comments) 1 page

7.

trips37.xls -
   sheet Bonus
Bonus sheet for Heinz (no comments) 1 page

8.

sharedata.doc Chart of Number of tickets sold - inserted with 4 methods 1 page

9.

sharedata.doc with chart of file sizes 1 page

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