F

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]

F2 key ( putting cell in edit mode)
FACT( ) function
FACTDOUBLE( ) function
factorials
FALSE( ) function
fancy fills [See Fill Effects dialog box]
File Locations tab
File menu
        Close command 2nd
        Do Not Distribute command
        Exit command 2nd
        New command
        Open command
        Page Setup command
        Print Area submenu
        Print command
        Print Preview command
        Properties command
        Restrict Permission As command
        Save As command
        Save As Web Page command
        Save command
        Save Workspace command
        Web Page Preview command
File Search command
Fill (cell appearance formatting)
Fill Color button
Fill Effects dialog box 2nd
        Gradient tab
        Pattern tab
        Picture tab
        Texture tab
Fill menu
Filter submenu
filtering
        pivot tables
                page filtering versus group filtering
financial concepts
        calculating investments or loans
        compound interest
        cumulative interest
       depreciation
                declining balance
                double declining balance
                straight-line
                sum-of- years -digits
        discount rate
        interest rates
        internal rate of return
        net present value
        nper
        number of payment periods
        present value
        principal
financial functions
Find All feature 2nd
Find and Replace dialog box 2nd
        tips
Find feature 2nd 3rd [See also searching]
        cells that contain numeric or date information
Find Format dialog box
        specifying format settings
Find Next 2nd 3rd
Find tool
        launching
FIND( ) function
finding and replacing values
FIX (Status bar indicator)
fixed decimal places
fixed width text
FIXED( ) function
FLOOR( ) function
Flowchart (shape category)
Font tab
fonts
        attributes
        color 2nd
        default
                changing
        proportional
        size
        special characters
footers
FORECAST( ) function
Format Axis dialog box
        Category (X) axis crosses at maximum value
        changing font, alignment, or number style
        Display units
        Logarithmic scale
        specialized options
        Values in reverse order
Format Axis title
Format Cells dialog box 2nd 3rd
        Alignment tab
                ’Wrap text “ checkbox
        Border tab
        Numbers tab
        Patterns tab
Format Chart Title
Format Comment dialog box
Format Data Point dialog box 2nd
Format Data Series
Format Data Series dialog box
        Gap width setting
        Overlap setting
Format Gridlines dialog box
Format menu
        AutoFormat command
        Cells command
        Column command
        Conditional Formatting command
        Row command
        Sheet command
        Style command
Format Painter
Format Picture dialog box
        options
Format Plot Area
format strings
        codes
        date and time
        displaying positive and negative values
        empty
        numbers
        text
Format Trendline dialog box
FormatHeader macro
FormatRow macro
formatting
        smart ways to apply
               AutoFormat [See AutoFormat command]
               conditional formatting [See Conditional Formatting]
                Format Painter
               Formatting toolbar [See Formatting toolbar]
                styles
Formatting toolbar 2nd 3rd
        Borders toolbar
        formatting individual characters
        shrinking
Formula Auditing submenu
Formula bar 2nd
formula errors, solving
        error checking
        step-by-step evaluation
        tracing precedents and dependents
formulas [See also functions]
        advanced
        array
        AutoSum
        building
        calculating values before entering in worksheet
       cell references [See cell references]
        conditional
       conditions in [See conditional formulas]
        controlling recalculation
        copying
                absolute cell references
                creating exact copies
                partially fixed references
        data validation and
        defined
        entering in cells
        errors
        how changing cell location affects
        ingredients of
        linked
        naming
        naming existing
        operations, order of
        printing
        referencing in other worksheets/workbooks
        rules
        shortcuts
                Analysis ToolPak
                Insert Function button
                point-and-click formula creation
                point-and-click formula editing
        showing
        spaces in
        under the hood
       variable data table [See variable data table]
Fraction format
Freeze Panes command 2nd 3rd
freezing columns or rows
FREQUENCY( ) function 2nd
Full Screen command
Full Screen mode
FUNCRES.XLA
function keys
        F2 (putting cell in edit mode)
functions 2nd 3rd [See also formulas]
        ABS( )
        ACCRINT( )
        ACCRINTM( )
        ACOS( )
        ACOSH( )
        ADDRESS( )
       Analysis ToolPak
                EDATE( )
                EOMONTH( )
                NETWORKDAYS( )
                WEEKNUM( )
                WORKDAY( )
                YEARFRAC( )
        AND( )
        AREAS( )
        ASIN( )
        ATAN( )
        ATAN2( )
        ATANH( )
        AVEDEV( )
        AVERAGE( ) 2nd
        AVERAGEA( )
        CEILING( ) 2nd
        CELL( )
        CHAR( )
        CHOOSE( )
        CLEAN( )
        CODE( )
        COLUMN( )
        COLUMNS( )
        COMBIN( ) 2nd
        CONCATENATE( )
        CORREL( )
        COS( )
        COSH( )
        COUNT( ) 2nd
        COUNTA( ) 2nd
        COUNTBLANK( )
        COUNTIF( )
        COUPDAYBS( )
        COUPDAYS( )
        COUPDAYSNC( )
        COUPNCD( )
        COUPNUM( )
        COUPPCD( )
        COVAR( )
        CUMIPMT( )
        CUMPRINC( )
        custom
        database
        DATE( )
        DATEDIF( )
        DATEVALUE( )
        DAVERAGE( )
        DAY( )
        DAYS360( )
        DB( )
        DCOUNT( )
        DCOUNTA( )
        DDB( )
        DEGREES( )
        DGET( )
        DISC( )
        DMAX( )
        DMIN( )
        DOLLAR( )
        DPRODUCT( )
        DSTDEV( )
        DSUM( )
        DURATION( )
        DVAR( )
        DVARP( )
        EFFECT( )
        ERROR.TYPE( )
        EVEN( )
        EXACT( )
        EXP( )
        FACT( )
        FACTDOUBLE( )
        FALSE( )
        financial
        FIND( )
        FIXED( )
        FLOOR( )
        FORECAST( )
        FREQUENCY( ) 2nd
       FV( ) function) [See FV( ]
        FVSCHEDULE( )
        GCD( )
       HLOOKUP( ) function) [See HLOOKUP( ]
        HOUR( )
        HYPERLINK( )
        IF( )
        INDEX( )
        INDIRECT( )
        INFO ( )
        information 2nd
        INT( )
        INTRATE( )
        IPMT( )
        IRR( )
        ISBLANK( )
        ISERR( )
        ISERROR( )
        ISEVEN( )
        ISLOGICAL( )
        ISNA( )
        ISNONTEXT( )
        ISNUMBER( )
        ISODD( )
        ISREF( )
        ISTEXT( )
        LARGE( )
        LCM( )
        learning new
        LEFT( ) 2nd
        LEN( )
        LINEST( )
        LN( )
        LOG( )
        LOG10( )
        lookup 2nd
       LOOKUP( ) function) [See LOOKUP( ]
        LOWER( )
        MATCH( )
        mathematical
        MAX( ) 2nd
        MDETERM( )
        MDURATION( )
        MEDIAN( )
        MID( ) 2nd
        MIN( ) 2nd
        MINUTE( )
        MINVERSE( )
        MIRR( )
        MMULT( )
        MOD( )
        MODE( )
        MONTH( )
        MROUND( )
        MULTINOMIAL( )
        N( )
        NOMINAL( )
        NORMDIST( )
        NORMINV( )
        NOT( )
        NOW( )
       NPER( ) function) [See NPER( ]
        NPV( )
                subtle problems with
        ODD( )
        ODDFPRICE( )
        ODDFYIELD( )
        ODDLPRICE( )
        ODDLYIELD( )
       OFFSET function) [See OFFSET( ]
        optional arguments
        OR( )
        PERCENTILE( )
        PERCENTRANK( ) 2nd
        PERMUT( )
        PI( )
       PMT( ) function) [See PMT( ]
        POWER( )
        PPMT( )
        PRICE( )
        PRICEDISC( )
        PRICEMAT( )
        PRODUCT( ) 2nd
        PROPER( ) 2nd
       PV( ) function) [See PV( ]
        quickly finding and using
        QUOTIENT( )
        RADIANS( )
        RAND( )
        RANDBETWEEN( )
        RANK( )
        RATE( )
        RECEIVED( )
        reference 2nd
        REPT( )
        RIGHT( ) 2nd
        ROMAN( )
        ROUND( ) 2nd
        ROUNDDOWN( )
        rounding
        ROUNDUP( )
        ROW( )
        ROWS( )
        SEARCH( )
        SECOND( )
        SERIESSUM( )
        SIGN( )
        SIN( )
        SINH( )
        SLN( )
        SLOPE( )
        SMALL( )
        SQRT( )
        SQRTPI( )
        statistical
        STDEV( ) 2nd
        STDEVA( )
        STDEVP( )
        SUBSTITUTE( )
        SUBTOTAL( ) 2nd
        SUM( ) 2nd
        SUMIF( ) 2nd
       SUMPRODUCT( ) function [See SUMPRODUCT( ]
        SYD( )
        T( )
        TAHNH( )
        TAN( )
        TBILLEQ( )
        TBILLPRICE( )
        TBILLYIELD( )
        text
        TEXT( )
        that return arrays
        TIME( )
        TIMEVALUE( )
        TODAY( ) 2nd 3rd
        TRANSPOSE( ) 2nd
        TREND( ) 2nd
        trigonometry
        TRIM( )
        TRUE( )
        TRUNC( ) 2nd
        TYPE( )
        understanding
        UPPER( )
        VALUE( )
        VAR( ) 2nd
        VARA( )
        VARP( )
        VDB( )
       VLOOKUP( ) function) [See VLOOKUP( ]
        volatile
        WEEKDAY( )
        with no arguments
        XIRR( )
        XNPV( )
        YEAR( )
        YIELD( )
        YIELDDISC( )
        YIELDMAT( )
future value 2nd [See also FV( function)]
FV( ) function
        break down
        caveat
        difficult problems to solve
FVSCHEDULE( ) function