Microsoft Excel 2007, things you should KNOW

Download
Share  Add to  Flag Embed
Views:
 
Category: Education
     
 
License:   All Rights Reserved

Presentation Description

No description available.

Comments

Presentation Transcript

Things you should KNOW : 

Things you should KNOW Microsoft Excel 2007

Slide 2: 

Excel Growth Excel Growth

Slide 4: 

Things you should know General Worksheet Working

Slide 5: 

Worksheet Size 1,048,576 Rows16,384 Columns Total over 17 Billion Cells More than worlds population

Slide 6: 

Max Column width 255 characters

Slide 7: 

Characters in aHeader or Footer Max 255 characters

Slide 8: 

Panes in a Window 4 Windows Max When you split the window

Slide 9: 

Max Zoom Range 10 percent to 400 percent

Slide 10: 

Undo Levels 100 Levels

Slide 11: 

Filter drop-down Lists 10,000 Rows Data & List Management

Slide 12: 

32 Fields Data & List Management Fields ina Data Form

Slide 13: 

Selected Ranges 2,048 Cells Max

Slide 14: 

Maximum Number Precision 15 1.12345678901234

Slide 15: 

Nested Levelsof Functions 64 Levels

Slide 16: 

Smallest AllowedNegative Number -2.2251E-308 Smallest AllowedPositive Number 2.2251E-308

Slide 17: 

Number of Available Functions in Worksheet 341 Functions

Slide 18: 

Largest AllowedPositive Number 9.99999999999999E+307 Largest Allowed Negative Number -9.99999999999999E+307

Slide 19: 

Largest Allowed Positive Number Via Formula 1.7976931348623158e+308 Largest Allowed Negative Number Via Formula -1.7976931348623158e+308

Slide 20: 

Cross-Worksheet Dependency 64,000 worksheets that can refer toother sheets Worksheet

Slide 21: 

Dependency ona Single Cell 4 billion formulasthat can depend ona single cell

Slide 22: 

Linked Cell Content Length from Closed Workbooks 32,767 Cells

Slide 23: 

Earliest Date Allowedfor Calculation January 1, 1900 (January 1, 1904, if 1904 date system is used) Latest Date Allowed for Calculation December 31, 9999

Slide 24: 

Largest Amount of Time that can be Entered 9999:59:59

Slide 25: 

Worksheets Referredto by a Chart 255

Slide 26: 

Data Series Allowed inOne Chart 255

Slide 27: 

Length of Formula Contents 8,192 characters

Slide 28: 

Arguments in a Function 255

Slide 29: 

Users Who can Open and Share a Shared Workbookat the Same Time 256

Slide 30: 

Things you should knowExcel Version visit www.exceladvise.com for more Photo courtesy: http://www.freedigitalphotos.net