Track Changes

MS 2000

SO 5.1

Highlight modifications

+

+

Accept refuse/modifications

+

+

Modification log

+

+

Sort modifications by author

—

+

Sort modifications by date

—

+

Accept more than one modification at a time

+

+

Merge documents

+

+

Compare documents

—

+

Comments

+

+

Check comments continuously

—

+

Versioning

MS 2000

SO 5.1

Create new version

+

+

Create new version automatically

+

+

Switch between versions

+

+

Delete versions

+

+

Insert note

+

+

Compare versions

+

+

Filter Functions

MS 2000

SO 5.1

AutoFilter

+

+

Top Ten filter

+

+

Standard filter

+

+

Special filter

+

+

Continuous filter

—

+

Maintain format after update

—

+

Insert/delete rows after update

—

+

Auditing Features

MS 2000

SO 5.1

Circular reference (single occurrence)

+

+

Circular reference (multiple occurrence)

+

+

Display preceding cell dependency graphically

+

+

Display succeeding cell dependency graphically

+

+

Update detective traces

—

+

Automatic update of detective traces

—

+

Find invalid values

—

+

Select cells containing only text, value or formula

+

+

Find cells containing file links or DDE links

+

+

Number of different error type cells

7

7

What-If Analysis

MS 2000

SO 5.1

Number of entries for data table

+

+

Frequency distribution

+

+

Goal seeking

+

+

Drag & drop fields for viewing

+

+

Security Features

MS 2000

SO 5.1

Password-protect spreadsheet from display

+

+

Password-protect spreadsheet against changes

+

+

Password-protect range of cells from display

+

+

Password-protect range of cells against changes

+

+

Consolidation Features

MS 2000

SO 5.1

Consolidate sheets-number of functions

11

11

Consolidate dissimilar sheets

+

+

Consolidate across rows or columns

+

+

Consolidate with links to source files

+

+

Report Generation

MS 2000

SO 5.1

Save named report format

+

+

Scale worksheet at print time

+

+

Print fit-to-page

+

+

Specify number of pages to fit to

+

+

Print a spreadsheet chart only

+

+

Select page range

+

+

Print grid lines

+

+

Center print range on the page

+

+

Control direction of printing

+

+

Print/don't print graphic objects

+

+

Multi-Sheet Capability

MS 2000

SO 5.1

User-selected 3D range for commands

+

+

User-selected 3D range for functions

+

+

User-selected non-contiguous 3D ranges

+

+

Enter data simultaneously in multiple sheets

+

+

Group worksheet for identical settings

+

+

Change order of spreadsheets by dragging

+

+

Link to active or inactive file

+

+

Link to range names

+

+

Cell moves update references in dependent sheets

+

+

DDE links

+

+

OLE support

+

+

Charting Options

MS 2000

SO 5.1

Maximum data sets per graph

256

65K

Chart templates

+

+

Place/resize chart

+

+

Graph a range of data in one step

+

+

In-place chart editing

+

+

Graph by row or column

+

+

Name charts

+

+

Incorporate free form drawing/symbols

+

+

Chart preview

+

+

Chart as shown

+

+

Chart Types

MS 2000

SO 5.1

3-D charts with OpenGL support

—

+

Area graphs

+

+

Doughnut graphs

+

+

Grouped (clustered or comparative) bars

+

+

High/low/close bars

+

+

Horizontal bars

+

+

Line graphs

+

+

Pie charts

+

+

Radar graphs

+

+

Scatter plots

+

+

Surface graphs

+

+

Titles, Legends and Axis

MS 2000

SO 5.1

Move chart title or legend position

+

+

Shadow boxes around any title

+

+

Skip factor

+

+

Angle axis labels

+

+

User-specified formatting of axis numbers

+

+

Scales can be logarithmic

+

+

User can set division factor for scaling

+

+

Major/minor grid options

+

+