Mastering Excel Made Easy: Versions 2007 Through 97 |
Contents
About Excel | 5 |
The Mini Toolbar | 61 |
Keyboard Shortcuts | 127 |
1213 | 4 |
Creating Basic Spreadsheets Exercises | 19 |
CHAPTER 3 Using Ranges | 31 |
Writing Formulas | 37 |
Using AutoSum | 85 |
Creating Formulas Exercises | 16 |
Common terms and phrases
active cell Arguments array AutoFilter calculation cell range cell reference changes chart type checkbox click and drag click OK Click the Microsoft click the OK column or row columns and rows command complex number Conditional Formatting contextual tab copy create criteria range CTRL custom data table day count basis delete Description dialog box display drop-down menu drop-down to select Edit enter error field footer Formula Bar function returns Goal Seek Insert integer keyboard known_x's logical value macro Menu Bar menu that appears Microsoft Access Microsoft Excel Microsoft Office button Microsoft Outlook Microsoft PowerPoint mouse pointer move multiple named range NASD open workbooks option button password payment PivotChart PivotTable range of cells Ribbon right end security's Select cell Select Data Select the cell shared workbook sheet SHIFT sort specified spreadsheet Standard Toolbar Syntax text box Unhide wildcard characters window worksheet workspace