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]

Web data

       worksheets

               importing to   2nd  

Web pages

       dynamic

               worksheet conversion  

       static

               worksheet conversion  

       worksheets

               converting to   2nd   3rd  

Web servers

       publication of worksheets

               selection criteria   2nd  

       Web pages

               uploading to   2nd  

Web sites

       Microsoft Templates Home Page   2nd   3rd  

Window menu commands

       Freeze Panes  

windows

       maximizing (Maximize button)   2nd  

       minimizing (Minimize button)   2nd  

       resizing   2nd  

       restoring (Restore button)   2nd  

Windows 2000

       Excel 2003

               shortcuts, creating   2nd  

Windows XP

       Excel 2003

               shortcuts, creating   2nd  

WordArt  

       objects

               inserting in worksheets   2nd   3rd  

               moving in worksheets  

       toolbar

               Edit Text tool  

               Format WordArt tool  

               Insert WordArt tool  

               WordArt Alignment tool  

               WordArt Character Spacing tool  

               WordArt Gallery tool  

               WordArt Same Letter Heights tool  

               WordArt Shape tool  

               WordArt Vertical Text tool  

WordArt Alignment tool (WordArt toolbar)  

WordArt Character Spacing tool (WordArt toolbar)  

WordArt Gallery tool (WordArt toolbar)  

WordArt Same Letter Heights tool (WordArt toolbar)  

WordArt Shape tool (WordArt toolbar)  

WordArt Veritical Text tool (WordArt toolbar)  

workbook window

       appearance of  

        components

               row headings   2nd  

               scrollbars   2nd  

               selector   2nd  

               split bars   2nd  

               tab scrolling buttons   2nd  

               tabs   2nd  

workbook windows

       splitting  

workbooks

       archiving .mht files  

       blank

               creating   2nd  

       naming   2nd   3rd   4th  

       overview   2nd  

       recently opened

               opening  

       saved

               opening   2nd   3rd  

       saving   2nd   3rd   4th  

       scrollbars

               navigation actions   2nd  

       templates

               downloading   2nd   3rd  

               features  

               opening   2nd   3rd   4th  

               properties   2nd  

               saving as   2nd   3rd  

       unauthorized changes

               prevention of   2nd   3rd  

       worksheets

               copying to   2nd  

               deleting from  

               inserting in   2nd  

               moving to   2nd  

       XML data

               importing  

       XML files

               saving as   2nd   3rd   4th  

Worksheet command (Insert menu)  

worksheets

       actions

               redoing  

               undoing  

        auditors

               Trace Dependents  

               Trace Error  

               Trace Precedents  

       black-and-white

               printing  

       borders

               appearance of  

        cell errors

               printing  

        cells

               adding text outside of  

               addresses   2nd  

               applying existing format styles   2nd  

               AutoComplete  

               borders, adding   2nd   3rd  

               column width adjustments   2nd  

               comment insertion  

               conditional formatting, applying   2nd  

               data entries   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

               data entry   2nd  

               deleting   2nd  

               formatting (AutoFormat)   2nd  

               function of   2nd  

               inserting   2nd  

               merging   2nd  

               navigating (keystrokes)   2nd  

               number of  

               quick data entry (Auto Fill)   2nd   3rd  

               ranges  

               ranges, naming   2nd  

               ranges, selecting   2nd   3rd  

               realigning data entries   2nd  

               resizing  

               row height adjustments   2nd  

               shading, adding   2nd  

               smart tags  

               text wrapping   2nd  

        charts  

               3-D   2nd  

               creating (Chart Wizard)  

               moving   2nd  

               resizing   2nd  

               types   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  

       clip art

               inserting   2nd   3rd  

        columns

               deleting  

               hiding   2nd  

               inserting   2nd  

               number of  

               resizing  

       comments

               printing  

       components   2nd  

       converting to Web pages   2nd   3rd  

       copying to workbooks   2nd  

       data

               copying   2nd  

               erasing   2nd  

               moving   2nd  

       data entries

               editing   2nd  

               modifying appearance   2nd   3rd   4th   5th  

               text-to-speech feature, activating   2nd  

       data/text entries

               dictating via speech recognition   2nd   3rd  

       deleting from workbooks  

       draft quality

               printing  

       e-mail

               sending via   2nd  

       entries

               types   2nd  

       fonts

               changing  

       footers

               adding   2nd   3rd  

       formatting styles

               comma  

               currency  

               normal  

               percent  

               specifications  

       formulas

               arithmetic operators  

               cell entry   2nd  

               order of operations  

               overview  

               versus functions   2nd  

       function of   2nd   3rd   4th  

       functions

               inserting  

               overview   2nd  

               versus formulas   2nd  

       headers

               adding   2nd   3rd  

       headings

               locking  

               locking (freeze panes)   2nd  

       images

               inserting   2nd   3rd  

       inserting in workbooks   2nd  

       links

               inserting   2nd  

               removing  

       margins

               changing (Print Preview area)  

               modifying   2nd  

       moving to workbooks   2nd  

        numbers

               formatting   2nd   3rd   4th  

       overview   2nd   3rd   4th  

       page breaks

               inserting   2nd   3rd  

               previewing   2nd  

               removing  

       page setup

               modifying   2nd  

       password-protection   2nd   3rd  

       pivot tables

               creating (PivotTable Wizard)   2nd  

               creating from multiple data ranges (PivotTable Wizard)  

               creating from single data range (PivotTable Wizard)   2nd   3rd   4th  

               data rearrangement  

               example of   2nd  

       print orientation

               landscape  

               portrait  

       print previews   2nd   3rd   4th  

       printing

               preferences, setting   2nd  

       publishing to Web

               Network Places folder configuration   2nd   3rd   4th  

               uploading files to FTP servers   2nd  

               Web server selection criteria   2nd  

       rows

               deleting  

               hiding   2nd  

               inserting   2nd  

               number of  

               resizing  

       scaling percentages  

       scenarios  

               naming   2nd   3rd  

               saving   2nd  

               summary report creation   2nd  

               viewing results  

       selecting

                methods   2nd  

       shading

               appearance of  

       split bars  

       tabs

               colorizing   2nd  

               renaming  

               viewing  

       unprintable regions  

       Web data

               importing to   2nd  

       WordArt objects

               inserting   2nd   3rd  

               moving  

       workbooks

               storage of   2nd  

wrapping

       text

               in cells   2nd  

Writing Pad

        handwritten entries

               penning   2nd  

Категории