Microsoft Excel 2000 Key Terms

1 Getting Started with Ms Excel 2 Creating a new work Book 3 Entering Text 4 Enter numbers 5 Formatting the text 5.1. Increase Font size 5.2. Changing the Font type 5.3. Change the Font Format 5.4. Setting Alignment of text 5.5. Selecting Multiple Cells 6 Writing Simple Formula 7 Inserting a columns 8 Writing Complex Formula 8.1.1. (Sum, IF, Max, Min,) 9 Copy Formulae in rest of the Cells 10 How to Edit Formula 11 Applying Formatting features to numbers 12 Formatting 12.1. Cells 12.2. Rows / Columns 12.3. Sheet 12.4. Auto Format 12.5. Conditional Formatting 13 Changing the columns width and Row Height Using Mouse 14 Insert And Delete Row 15 Insert and deleting Columns 16 Delete Sheet 17 Copying and Moving Sheet. 18 Clear Command 19 Moving and Copying Cell Contents. 19.1. Copy Using Mouse 19.2. Copy and Moving using right mouse button. 20 Zoom 21 Full Screen 22 Hyperlinks 23 Custom Views 24 View 24.1. Normal 24.2. Page Break Preview 25 Transferring Data between Worksheets 26 Transferring Data between Workbooks 27 Paste Special 28 Auto Complete Suggestion 29 Drop down List Auto Complete 30 Fill Numbers and Date using Edit Menu 31 Fill Numbers and Date Using Mouse. 32 Format Cells (Format > Cells) 33 Previewing the Layout 34 Page Breaks ( Insert > Page Break) 35 Changing Page and Sheet Settings 35.1. Set Print Area 35.2. Set Margin 35.3. Rows to repeat at tip 35.4. Columns to repeat at left 35.5. Page Setting 35.6. Row and Columns headings 35.7. Vertically and Horizontal Align. 36 Header/Footer ( View > Header and Footer) 37 Print Settings 38 Merge Cells/Un Merge Cells 39 Save /Save As 40 Checking Spelling Mistakes (Tool > Spelling) 41 Selecting Multiple Cells 41.1. Using Mouse 41.2. Using Keyboard 42 Popup Menu. 43 Name a range 44 Use names as references 44.1. Name Box 44.2. Name Define 44.3. (Insert > Name > Define) 44.4. Creating Names from a row or columns (Insert > Name > Create Name) 45 Label (Tool > Options > Calculation > Accepts Labels Create Names 46 Relative References 47 Create absolute cell references 48 Create mixed cell references 49 Absolute row references 50 Absolute column references 51 Use common statistical functions. Sum (), PMT (), FV () 52 Goal Seek Status (Tool > Goal Seeks) 53 Move and Copy Sheets 54 Sort (Data > Sort) 55 Filter (Data Filter) 56 Create different charts like Pie chart, Line chart, Column bar, Specialty chart. 57 Use the Chart Wizard 58 Edit a chart like move, size and print a chart. 59 Add data series 60 Delete data series 61 Format charts 62 Insert and format titles in a chart 63 Save as Web Page 64 Web page Preview 65 Save Workspace (File > save workspace) 66 Get External Data (Data > Get External Data) 67 Form 68 Subtotals 69 Validation 70 Protection (Tool > Protect) 70.1. Protect Sheet 70.2. Protect Workbook 70.3. Protect and share workbook. 71 Style (Format > Style) 72 Table (Data > Table) 73 Text To Column (Data > Text To Column) 74 Groups And Outline (Data > Groups and Outline) 75 Consolidation (Data > Consolidation) 76 Pivot Table and Pivot Chart (Data > Pivot Table and Pivot Chart) 77 Freeze Pane (Window > Freeze Pane) 78 Split Windows (Window > Split Windows)