Absolute Beginners Guide to Microsoft Office Excel 2003

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

Cancel button (Save As dialog box)  

cells

       (worksheets)  

       addresses

               overview   2nd  

       borders

               adding   2nd   3rd  

               drawing (Borders toolbar)  

               erasing (Borders toolbar)  

        columns

               width adjustments   2nd  

       comments

               inserting  

       conditional formatting

               applying   2nd  

       data

               entering   2nd  

       data entries

               copying   2nd  

               copying (Auto Fill)   2nd  

               copying (AutoFill)  

               dates   2nd   3rd  

               editing   2nd  

               erasing   2nd  

               formulas  

               functions  

               labels (text)   2nd   3rd  

               modifying appearance   2nd   3rd   4th   5th  

               moving   2nd  

               realigning   2nd  

               text-to-speech, activating   2nd  

               times   2nd   3rd  

               values ( numbers )   2nd   3rd  

       entries

               types   2nd  

       existing format styles

               applying   2nd  

       format styles

               copying from other workbooks   2nd  

               creating   2nd  

               editing  

               saving in template  

       formatting (AutoFormat)   2nd  

       formatting styles

               copying (Format Painter)  

       formulas

               arithmetic operators  

               Auto Calculate feature, activating  

               AutoSum tool, activating   2nd  

               copying   2nd  

               creating (manual method)  

               creating (point-and-click method)   2nd  

               displaying (formula-display mode)   2nd  

               editing  

               entry of   2nd  

               functions   2nd  

               functions, inserting   2nd   3rd  

               marking as absolute references   2nd  

               order of arithmetic operators  

               pasting   2nd  

               recalculation setting   2nd  

       function of   2nd  

       merging   2nd  

       navigating (keystrokes)   2nd  

       number of  

       numbers

               formatting   2nd   3rd   4th  

       ranges  

               marquee  

               naming   2nd  

               selecting   2nd   3rd  

       resizing  

       rows

               height adjustments   2nd  

       shading

               adding   2nd  

       smart tags

               link functions  

       text

               adding outside of  

               wrapping   2nd  

       worksheets

               deleting   2nd  

               inserting   2nd  

Cells command (Format menu)   2nd   3rd   4th   5th   6th   7th   8th  

Cells command (Insert menu)  

Center button

       Formatting toolbar  

Chart menu commands

       3-D View  

       Chart Options   2nd  

Chart Objects tool (Chart toolbar)  

Chart Options command (Chart menu)   2nd  

Chart toolbar

       Angle Counterclockwise tool  

        buttons

               adding/remobing  

       By Column tool  

       By Row tool  

       Chart Objects tool  

       Chart Type tool  

       Data Table tool  

       Format tool  

       Legend tool  

Chart Type tool (Chart toolbar)  

Chart Wizard

        charts

               creating   2nd   3rd   4th  

charts  

       3D

               rotating   2nd  

       axes

               formatting  

               tick marks  

       axis  

       borders

               adding   2nd  

       creating (Chart Wizard)   2nd   3rd   4th  

       data series  

       formatting (Chart menu)   2nd  

       formatting (Chart toolbar)   2nd   3rd  

       legends  

       moving via handles   2nd  

       organization

               creating   2nd   3rd  

               Style Gallery  

       organization charts

               both hanging layout  

               left hanging layout  

               right hanging layout  

               standard layout  

               worker roles  

       print previews  

       resizing via handles   2nd  

       shading

               adding   2nd  

       text

               formatting   2nd   3rd  

       types

               3-D   2nd  

               area  

               bar  

               bubble  

               column  

               cone  

               cylinder  

               doughnut  

               line  

               pie  

               pyramid  

               radar  

               stock  

               surface  

               XY (scatter)  

ChartWizard button

       Standard toolbar  

Clear command (Edit menu)  

clip art  

       inserting   2nd   3rd  

       Microsoft Clip Organizer

               image insertion  

               viewing  

       searching   2nd  

Clip Art task pane  

       clip art galleries

               search tools   2nd  

       Organize Clips link  

Clipboard task pane  

Clippit

       (Office Assistant)   2nd  

       activating   2nd  

       context-sensitive help

               obtaining   2nd  

close-talk microphones

       speech recognition

               minimum requirements  

Color tool (Picture toolbar)  

colors

       worksheet tabs

               chaning   2nd  

column charts  

Column command (Format menu)  

Column Hide command (Format menu)  

column labels

       databases

               entry of   2nd  

columns

       (worksheets)  

        cell address format   2nd  

       number of  

       resizing  

       worksheets

               deleting  

               hiding   2nd  

               inserting   2nd  

               repeating across printed pages  

Columns command (Insert menu)  

comma style

       worksheet format  

Comma Style button

       Formatting toolbar  

commands

       Chart menu

               3-D View  

               Chart Options   2nd  

       Data menu

               Filter  

               Form  

               Refresh External Data  

               Sort  

       Draw menu

               Ungroup  

       Edit menu

               Clear  

               Cut  

               Delete   2nd  

               Go To  

               Move or Copy Sheet  

               Paste  

               Redo  

               Undo  

               Undo Sort  

       executing via speech recognition   2nd   3rd  

       File menu

               Exit  

               Open  

               Page Setup  

               Print Preview  

               Save As  

               Save as Web Page  

       Format menu

               AutoFormat  

               Cells   2nd   3rd   4th   5th   6th   7th   8th  

               Column  

               Column Hide  

               Conditional Formatting  

               Row  

               Row Hide  

               Style   2nd   3rd  

       Help menu

               Microsoft Excel Help  

       Insert menu

               Cells  

               Columns  

               Diagram  

               Function  

               Picture   2nd  

               Rows  

               Worksheet  

        menus

               context-sensitive  

               dialog boxes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  

               light gray appearance  

               selecting   2nd   3rd  

               shortcut keystrokes  

               Smart Menus  

       New menu

               Blank Workbook  

       Start menu

               Help and Support  

               My Recent Documents  

       Tools menu

               Formula Auditing  

               Protection  

               Scenarios  

               Speech Recognition  

       View menu

               Header and Footer  

               Task Pane  

                Toolbars  

       Window menu

               Freeze Panes  

comments

       cells

               inserting  

               printing  

comparison operators

       <= (less than or equal)  

Compress Picture tool (Picture toolbar)  

conditional formatting

       cells

               applying   2nd  

Conditional Formatting command (Format menu)  

Conditional Formatting dialog box  

cone charts  

configuring

       Network Places folders

               Web pulishing materials   2nd   3rd   4th  

context-sensitive help

       obtaining (Office Assistant)   2nd  

context-sensitive menus  

converting

       worksheets

               to Web pages   2nd   3rd  

Copy button

       Standard toolbar  

copying

       data entries

               cells (Auto Fill)   2nd   3rd  

               worksheets   2nd  

       formatting styles

               from cells (Format Painter)  

               from other workbooks   2nd  

       formulas   2nd  

       worksheets

               in workbooks   2nd  

Count function

       AutoSum tool  

Create New Folder button (Save As dialog box)  

creating

       blank workbooks   2nd  

       charts

               Chart Wizard   2nd   3rd  

       databases   2nd   3rd   4th   5th   6th   7th   8th   9th  

       formatting styles

               cells   2nd  

       formulas

               manual method  

               point-and-click method   2nd  

       organization charts   2nd   3rd  

       workbooks

               from scratch   2nd  

       worksheet scenarios

               summary reports   2nd  

Crop tool (Picture toolbar)  

currency style

       worksheet format  

Currency Style button

       Formatting toolbar  

custom format (numbers)  

customizing

       toolbars   2nd  

Cut button

       Standard toolbar  

Cut command (Edit menu)  

cuurency format (numbers)  

cylinder charts  

Категории