CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Basics

  1.1     Starting Calc

  1.2     The Calc Window
    1.2.1      The Title Bar
    1.2.2      The Menu Bar

  1.3     Getting Help

  1.4     Using a Dialog Box

  1.5     Quitting Calc

  2      Creating a Calc Worksheet

  2.1     The Worksheet

  2.2     Selecting Cells
    2.2.1      Extending and Reducing Selections
    2.2.2      Multiple Selection

  2.3     Entering Data
    2.3.1      Changing Data
    2.3.2      Text Labels
    2.3.3      Numbers
    2.3.4      Date and Time

  2.4     Formatting a Worksheet
    2.4.1      Data Type...
      2.4.1.1      Data Types List
      2.4.1.2      Edit String Field
      2.4.1.3      Add and Remove Buttons
    2.4.2      Alignment...
    2.4.3      Display...
    2.4.4      Cell Borders...
    2.4.5      Changing Column Width
    2.4.6      Hiding Data
    2.4.7      Clearing Formats

  2.5     Building Formulas
    2.5.1      Controlling Calculation
    2.5.2      Operators
    2.5.3      References
      2.5.3.1      Relative References
      2.5.3.2      Absolute References
      2.5.3.3      Mixed References
      2.5.3.4      Recursive References
    2.5.4      Functions
    2.5.5      Names
      2.5.5.1      Naming a Range
      2.5.5.2      Naming a Constant
      2.5.5.3      Defining Selected Names
      2.5.5.4      Clearing a Name

  2.6     Saving a Worksheet
    2.6.1      Canceling Changes After Saving

  2.7     Printing a Worksheet

  3      Editing a Calc Worksheet

  3.1     Opening an Existing File

  3.2     Moving Around the Worksheet

  3.3     Changing Information in the Worksheet

  3.4     Canceling an Editing Operation

  3.5     Moving Data Around the Worksheet
    3.5.1      Cut and Paste
    3.5.2      Copy and Paste
    3.5.3      Move
    3.5.4      Differences Between Copy and Move
    3.5.5      Results of Pasting

  3.6     Moving Data with the Pop-up Menu

  3.7     Clearing a Cell Range

  3.8     Locks
    3.8.1      Locking a Range
    3.8.2      Resetting Locks

  3.9     Inserting and Deleting Rows and Columns

  3.10    Inserting and Deleting Sections of the Worksheet
    3.10.1     Inserting Cells
    3.10.2     Deleting Cells
    3.10.3     Deleting the Worksheet

  3.11    Filling Sections of the Worksheet

  3.12    Looking at Part of the Worksheet
    3.12.1     Creating a View
    3.12.2     Choosing a View
    3.12.3     Deleting a View

  4      Managing Data in Calc

  4.1     Sorting Data
    4.1.1      Sorting by Row
    4.1.2      Sorting by Column
    4.1.3      Sort Keys
    4.1.4      Sorting and Cell References

  4.2     What-if Table
    4.2.1      Replacing One Value
    4.2.2      Replacing Two Values

  4.3     Consolidating Worksheets
    4.3.1      Creating a Consolidation Form
    4.3.2      Modifying a Consolidation Form
    4.3.3      Consolidation Errors

  4.4     Creating a Report

  5      Recording Calc Worksheet Sessions

  5.1     Recording a Worksheet Session

  5.2     Saving a Macro

  5.3     Playing Back a Recorded Session

  5.4     Editing a Macro

  5.5     The Command Region

  6      Importing and Exporting Worksheets

  6.1     Importing Worksheets
    6.1.1      Import Formats

  6.2     Exporting Worksheets
    6.2.1      Export Formats

  6.3     Options

  6.4     Error Messages

  7      Charting Data

  7.1     Draw Chart...  Menu Item

  7.2     Charting Functions

  8      Calc Functions

  8.1     Boolean Functions
    8.1.1      AND(value list)
    8.1.2      IF(if-expression, then-expression [,else-expression])
    8.1.3      ISBLANK(expression)
    8.1.4      ISDATE(expression)
    8.1.5      ISERR(expression)
    8.1.6      ISLABEL(expression)
    8.1.7      ISNA(expression)
    8.1.8      ISNC(expression)
    8.1.9      ISNM(expression)
    8.1.10     ISNUMBER(expression)
    8.1.11     NOT(value)
    8.1.12     OR(value list)

  8.2     Chart Functions
    8.2.1      AREA(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [cate
    8.2.2      BAR(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [categ
    8.2.3      CHART(data range, [orientation], [style file], [category range], [legend range], [title], [subtitle], [data seril
    8.2.4      COLUMN(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [cl
    8.2.5      COMBO(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [cal
    8.2.6      HILO(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [cate
    8.2.7      HISTO(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [cat
    8.2.8      LINE(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [cate
    8.2.9      PIE(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], [categ
    8.2.10     SCATTER,(data range, [orientation], [category range], [legend range], [title], [subtitle], [data series label], l

  8.3     Constant Functions
    8.3.1      ERR( )
    8.3.2      NA( )
    8.3.3      NC( )
    8.3.4      NM( )
    8.3.5      PI( )

  8.4     Date and Time Functions
    8.4.1      DATE(string)
    8.4.2      TODAY( )
    8.4.3      NOW( )
    8.4.4      DAYS(start date, integer)
    8.4.5      WEEKS(start date, integer)
    8.4.6      MONTHS(start date, integer)
    8.4.7      YEARS(start date, integer)
    8.4.8      HOURS(start date, integer)
    8.4.9      MINUTES(start date, integer)
    8.4.10     SECONDS(start date, integer)
    8.4.11     DUR(start date, end date, [unit])

  8.5     Financial Functions
    8.5.1      APP(amount, rate, [offset], [start period], [end period], output section)
    8.5.2      DEPR_DB(initial value, number of periods, [percentage decline], [salvage], [start period], [end period], output s
    8.5.3      DEPR_DBC(initial value, number of periods, [percentage decline], [salvage], [start period], [end period], output
    8.5.4      DEPR_LINE(initial value, number of periods, [percentage decline], [salvage], [start period], [end period], output
    8.5.5      DEPR_SOD(initial value, number of periods, [percentage decline], [salvage], [start period], [end period], output
    8.5.6      DIS(amount, rate, [offset], [start period], [end period], output section)
    8.5.7      FV(cash-flows, interest rate, [offset])
    8.5.8      FVA(payment-per-period, rate, periods)
    8.5.9      INTEREST(amount, rate, period, [start period], [end period],output section)
    8.5.10     IRR(cash-flows, [,guess])
    8.5.11     PAYBACK(investment, cash-flows,rate)
    8.5.12     PAYMENT(principal, rate, payments)
    8.5.13     PRIN(amount, rate, period, [start period], [end period], output section)
    8.5.14     PV(cash-flows, interest rate, [offset])
    8.5.15     PVA(payment, rate, periods)

  8.6     Mathematical Functions
    8.6.1      ABS(expression)
    8.6.2      ALOG(value)
    8.6.3      EXP(value)
    8.6.4      INT(expression)
    8.6.5      LN(value)
    8.6.6      LOG(value)
    8.6.7      MOD(value1, value2)
    8.6.8      ROUND(value, number of digits)
    8.6.9      SQRT(value)
    8.6.10     SUM(list)
    8.6.11     TRUNC(value, number of digits)

  8.7     Special Functions
    8.7.1      CELL(column,row)
    8.7.2      CHOOSE(index,value1,value2...value n)
    8.7.3      COL(cell name)
    8.7.4      COLS(list of ranges)
    8.7.5      CURR_VAL( )
    8.7.6      HLOOKUP(value, range, [offset])
    8.7.7      INIT_VAL( )
    8.7.8      ITC( )
    8.7.9      ITERATE(evaluated expression, number of iterations, exit expression)
    8.7.10     LAST_VAL( )
    8.7.11     LINK(cell,worksheet)
    8.7.12     ROW(cell name)
    8.7.13     ROWS(list of ranges)
    8.7.14     SCALE(value,low,high)
    8.7.15     VLOOKUP(value, range, [offset])
    8.7.16     TABLE(lookup value, search range, return range)

  8.8     Statistical Functions
    8.8.1      AVE(list)
    8.8.2      COUNT(list)
    8.8.3      LS(return value, x array, y array)
    8.8.4      MAX(list)
    8.8.5      MIN(list)
    8.8.6      STDEV(list of values)
    8.8.7      VAR(list of values)

  8.9     Text Functions
    8.9.1      LEFT(string, number of characters)
    8.9.2      MID(string, starting position, number of characters)
    8.9.3      RIGHT(string, number of characters)
    8.9.4      UPPER(string)

  8.10    Trigonometric Functions
    8.10.1     ACOS(radians)
    8.10.2     ASIN(radians)
    8.10.3     ATAN(radians)
    8.10.4     COS(radians)
    8.10.5     SIN(radians)
    8.10.6     TAN(radians)

  9      Creating a Live Link with DECwrite

  9.1     Linking a Calc Worksheet with a DECwrite Document

  9.2     Opening a DECwrite Document with Live Links

  9.3     Quitting a Calc Session Started from DECwrite

  10     Customizing Calc

  10.1    Changing Default Settings
    10.1.1     Labels
    10.1.2     Values
    10.1.3     Label Options
    10.1.4     Value Options
    10.1.5     Column Width
    10.1.6     Edit String
    10.1.7     Recursion
    10.1.8     Index Window

  A   Edit String Characters

  B   Consolidation Data Type Precedence

  Glossary

  FIGURES

  1-1        The Calc Window

  2-1        The Calc Worksheet

  TABLES

  2-1        Sample Edit String Characters

  A-1        Calc Edit String Characters

  B-1        Calc Consolidation Operations