S

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

Save As command 2nd
Save As dialog box
Save as Web Page command
Save command 2nd
Save tab
Save Workspace command
saving files
scale (chart)
        changing for value axis
        controlling
        setting
Scale tab
scatter charts
        formatting
        with no data markers
        with smooth lines
        with straight lines
Scenario Manager dialog box 2nd 3rd
Scenario Summary dialog box
Scenario Values dialog box
scenarios
        changing cell references
        creating multiple
        creating new
        creating summary report
        deleting
        managing
        merging
        naming
        storing results in
        using
scientific data, adding error bars to
Scientific format
SCRL (Status bar indicator)
scroll bars and split worksheets
Search pop-up menu
Search Results task 2nd
Search task
SEARCH( ) function
searching [See also find feature]
        across multiple worksheets
        advanced searches
        By Columns
        By Rows
        formatted cells
        numbers
        ’Match case “ option
        ’Match entire cell contents “
        with wildcards
searching for files
        advanced search feature
SECOND( ) function
security
        macros and
security, password protection
’Select Changes to Accept or Reject “ dialog box
Send To feature
Send To submenu
SERIESSUM( ) function
server-side databases
Service Options dialog box
Set Print Area command 2nd
Share Workbook dialog box 2nd
Shared Workspace task 2nd 3rd
SharePoint Server and Windows 2003
Sheet command
shortcuts [See keyboard shortcuts]
Show Detail command 2nd
Show Formula Auditing Toolbar
Show Outline Symbols 2nd
’Show Text To Speech Toolbar “ command
Show the Office Assistant command 2nd
SIGN( ) function
SIN( ) function
SINH( ) function
SLN( ) function
SLOPE( ) function
SMALL( ) function
smart documents
social security numbers
Solver 2nd
        advanced solutions
        configuring
        creating special reports
        defining problems in
        model
                Add Constraint dialog box
                advanced examples
                changing cells
                constraints
                decision variables
                saving
                target cells
                unchanging cells
        Options dialog box
        Parameters dialog box 2nd
       settings
                Convergence
                Iterations
                Max Time
                Precision
                resetting to default
                Restore Original Values
                Show Iteration Results
                Tolerance
        storing results in scenarios
        types of optimization
        web site
SOLVER.XLA
Sort dialog box
sort keys, multiple
Source Data dialog box
spaces
        as intersection operators
        in formulas
Special format
speech, text-to-speech feature
spell checker 2nd
        Add to Dictionary
        options
                Ignore Internet and file addresses
                Ignore words in UPPERCASE
                Ignore words with numbers
                Suggest from main dictionary only
Split command 2nd
splitting worksheets
spreadsheet modification
        AutoSelect
        deleting columns and rows
        inserting columns
        inserting copied or cut cells
        inserting rows
        making selections with keyboard
        moving cells around
        non-contiguous cell selection
        selecting cells
        selecting cells with Go To
        selecting continuous range of cells
Spreadsheet Solutions templates
spreadsheets [See also workbooks; worksheets]
        common types
        linking to XML
        opening
        opening multiple
       programming [See VBA, programming spreadsheets with]
        saving in other formats
        saving with a password
SQL tutorial
SQRT( ) function
SQRTPI( ) function
squares, method of least
stacked column charts
stacked line charts
standalone charts
        printing
Standard toolbar
Stars and Banners (shape category)
statistical functions
Status bar
status bar
Status bar
       indicators
                CAPS
                END
                EXT
                FIX
                NUM
                OVR
                SCRL
Status bar calculations
STDEV( ) function
        SUBTOTAL ( ) function codes and
STDEVA( ) function
STDEVP( ) function
        SUBTOTAL ( ) function codes and
stock charts
        High-Low-Close
        Open -High-Low-Close
        Volume-High-Low-Close
        Volume-Open-High-Low-Close
Stop Recording toolbar
        disappearing
straight-line depreciation
string literals
Style dialog box 2nd
styles
        applying
        Comma
        Comma [0]
        creating
        Currency
        default
        Normal
        outline
        Percent
        transferring
        urrency [0]
sub-expressions
submenus, creating
SUBSTITUTE( ) function
Subtotal tool
SUBTOTAL( ) function
        calculation code
        function codes for
        visible only cells
subtotaling, automatic
Subtotals dialog box 2nd
subtraction
Sum (Status bar shortcut)
SUM( ) function
        SUBTOTAL ( ) function codes and
sum-of- years -digits depreciation
SUMIF( ) function 2nd 3rd
SUMIF.XLA
summary tables
SUMPRODUCT( ) function 2nd
        evaluating more than one condition
        underlying principles
        using as counting tool
        using to create reports
surface charts
SYD( ) function
Symbol dialog box 2nd 3rd