C

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]

calculating
        investments or loans
        values before entering in worksheet
calculations, dynamic
Callouts (shape category)
capitalization, changing names in all caps to initial caps
CAPS (Status bar indicator)
case-sensitive search
CEILING( ) function 2nd
cell appearance formatting 2nd
        borders and patterns
        Bottom
        Center 2nd
        Center Across Selection
        Distributed
        Distributed (Indent)
        Fill
        fonts and color
        General
        Justify 2nd
        Left (Indent)
        Right (Indent)
        Top
cell ranges
        colon (:)
        comma (,)
       named [See named ranges]
        spaces as intersection operators
cell references 2nd
        absolute
        cell formatting and
        data validation and
        defined
        in other worksheets/workbooks
        moving to new location
       named [See named ranges]
        partially fixed
        relative
        stored as text
cell value formatting
        numbers
                Accounting format
                Currency format
               custom formats [See custom formats]
                dates and times
                Fraction format
                General format
                Number format
                Percentage format
                Scientific format
                Special format
                Text format
        steps to format
CELL( ) function
cells
       appearance [See cell appearance formatting]
        AutoSelect
        checking values inside
        disappearing
        edge cells
        editing specific by programming
        entering formulas
        entering text in current cell via programming
        fitting more text into cells
       formatting cell references [See cell references]
        formatting in grouped worksheet
        hidden
        hiding
        how changing location affects formulas
        inserting copied or cut
        locked
        maximum number
        merging
        modifying in grouped worksheets
        moving around
        moving from cell to cell
        moving to other via programming
        overlapping
        putting in edit mode
        relationship between formatting and values
        searching formatted
        selecting
        selecting continuous range of
        selecting non-contiguous
        selecting with Go To
        selecting with keyboard
        underlying values
       value formatting [See cell value formatting]
Cells command
Center (cell appearance formatting) 2nd
Center Across Selection (cell appearance formatting)
change tracking 2nd
        accepting/rejecting changes
       change log
                clearing changes from
                examining
                understanding
        creating change report
        difference between what is tracked and what is highlighted
        features that don't work with
        highlighting changes
                choices
        merging multiple revisions into one workbook
        turning on
        using
        what is ignored
CHAR( ) function
chart elements
        axis
        data point
       data points
                formatting
        data series
                adding labels
                formatting
        deleting
        formatting
        gridlines
        legend
                adding
        list of
        moving
        plot area
        resizing
        selecting
        titles
                adding
Chart Location dialog box
Chart menu
        3-D View command
        Add Data command
        Add Trendline command
        Chart Location command
        Chart Options command
        Chart Type command
        Source Data command
Chart Object submenu, Convert option
Chart Options
        Data Labels tab
        Legend tab
chart scale
        changing for value axis
        controlling
        settings
Chart toolbar
        drop-down list
        Format button
        Plot Area
Chart Type dialog box 2nd
chart types
        area
        bar
        bubble
        column
        cone 2nd
        custom
        cylinder 2nd
        donut
        line
        pie
        pyramid 2nd
        radar
        scatter
        stock
        surface
        XY scatter
Chart Wizard 2nd
        chart types
        charting non-contiguous data
charts
       bar [See bar charts]
        category axis
        changing how Excel plots blank values
                Interpolated option
                Not plotted option
                Zero option
        changing options
        Chart Options option
        Chart Type option
        Chart Window option
        coloring background
       column [See column charts]
        combination
        controlling data on X-axis
        creating
       data lists [See data lists]
        data table
        data that uses date or time scale
        difference between column and line
        dragging into Word
        drawing graphic objects in
       elements [See chart elements]
       embedded [See embedded charts]
        exporting
       fancy fills [See Fill Effects dialog box]
        graphical goal seeking
        how Excel anchors
       line [See line charts]
        Location option
        modifying chart data
        moving
       multiple series
                data in different scales
        multiple series of numbers
        non-contiguous ranges
        organizational
        overview
       pivot [See pivot charts]
        printing
                embedded
                standalone
        refining
        resizing
        saving custom settings
        scientific data, adding error bars to
        Source Data option
        standalone
        trendlines
                extending
                Linear trend
                Polynomial trend
                Power and Exponential trends
Check for Updates command
Choose Data Source dialog box 2nd
CHOOSE( ) function
circular references
CLEAN( ) function
Clear command
Clear Outline command
Clear Print Area command
clip art 2nd
        adding to collection
        graphic file types
        inserting
        "Search in" list
        searching by description
Clip Art task
Clip Organizer
Clipboard
        one-object rule
Clipboard task 2nd 3rd
Clippy
Close command 2nd
clustered column charts
CODE( ) function
collaboration
       change tracking [See change tracking]
       comments [See comments]
       review chain [See review chain]
        user identity
colon (:) in cell ranges
color formatting
color, fonts
column charts 2nd 3rd 4th
        100% stacked
        3-D effect
        clustered
        gaps, widths, and overlays
        stacked
        true 3-D column
        with two series
Column command
COLUMN( ) function
columns
        changing into rows
        deleting
        formatting in grouped worksheet
        freezing
        grouping
        hiding
        identification
        inserting
        maximum number
       titles
                adding
        types of data
       width
                standard
        width, adjusting 2nd 3rd [See also AutoFill]
Columns command
COLUMNS( ) function
COM (Component Object Model)
COMBIN( ) function 2nd
combination charts
combinations
comma (,) in cell ranges
Comma [0] style
Comma style
commands
        adding new to toolbar or menu
        special
Comment command
comments
        deleting
        fine-tuning
        formatting text in comment box
        hiding/showing
        inserting
        navigating
        printing
        resizing comment box
        using
Comments command
Compare and Merge Workbooks command
’Compare Side by Side with “ command
compound documents
        super- sized
compound interest 2nd
compressing pictures
CONCATENATE( ) function
concatenation symbol (&)
Conditional Formatting
        dialog box
conditional formulas 2nd
        AND( ) function
        COUNTIF( ) function
        FALSE( ) function
        IF( ) function
        NOT( ) function
        OR( ) function
        SUMIF( ) function
       SUMPRODUCT( ) function function) [See SUMPRODUCT( ]
        TRUE( ) function
conditional logic
conditional validation rules
cone charts 2nd
Connectors (shape category)
Consolidate dialog box 2nd
consolidating data
constants
        naming
Contact Us command
continuous range of cells, selecting
Copy command
copy-and-paste
        drag-and-drop
        grouped worksheets
        part of a cell
        Paste Special feature
CORREL( ) function
COS( ) function
COSH( ) function
Count (Status bar shortcut)
Count Nums
COUNT( ) function
        SUBTOTAL ( ) function codes and
COUNTA( ) function
        SUBTOTAL ( ) function codes and
COUNTBLANK( ) function
COUNTIF( ) function 2nd
COUPDAYBS( ) function
COUPDAYS( ) function
COUPDAYSNC( ) function
COUPNCD( ) function
COUPNUM( ) function
COUPPCD( ) function
COVAR( ) function
crashes, recovering data
Create List command 2nd
        dialog box
Create Names tool
Ctrl key and arrow keys
CUMIPMT( ) function
CUMPRINC( ) function
cumulative interest
Currency [0] style
Currency format
Currency style
custom chart types
custom charts
        saving settings
Custom data type
        data validation
custom formats
        codes that apply currency symbols, percent symbols, and colors
        creating
       format strings [See format strings]
        using
custom functions
Custom Lists tab
custom views
        naming
Custom Views dialog box 2nd
custom workspaces
        quirks
Customer Feedback Options command
customization mode
Customize dialog box 2nd 3rd
        Categories list
        Commands tab
        Toolbars tab
customizing Excel 2nd [See also Customize dialog box]
Cut command
cut-and-paste
        drag-and-drop
        grouped worksheets
        part of a cell
        Paste Special feature
cylinder charts 2nd