List of Tables

Chapter 2: Exploring Excel Fundamentals

Table 2-1: The Excel Default Extensions

Chapter 3: Custom-Tailoring the Excel Workspace

Table 3-1: Command Modifiers

Chapter 6: How to Work a Worksheet

Table 6-1: Keyboard Modes

Table 6-2: Keyboard Shortcuts for Navigation

Table 6-3: Keyboard Shortcuts for Data Entry

Table 6-4: Examples of Numeric and Text Values

Table 6-5: Text-Alignment Prefix Characters

Chapter 8: Worksheet Editing Techniques

Table 8-1: Essential Keyboard Shortcuts

Chapter 9: Worksheet Formatting Techniques

Table 9-1: Custom Format Symbols

Table 9-2: Built-in Custom Format Codes

Chapter 12: Building Formulas

Table 12-1: Placement of Parentheses

Table 12-2: Error Values

Table 12-3: Examples of Numeric Precision

Table 12-4: Logical Operators

Chapter 14: Everyday Functions

Table 14-1: LOOKUP Function Arguments

Table 14-2: MATCH Function Arguments

Chapter 15: Formatting and Calculating Date and Time

Table 15-1: Codes for Creating Custom Date and Time Formats

Table 15-2: Return Type Codes

Table 15-3: Basis Codes

Chapter 16: Functions for Financial Analysis

Table 16-1: Investment Function Arguments

Table 16-2: Depreciation Function Arguments

Table 16-3: Security-Analysis Function Arguments

Chapter 17: Functions for Analyzing Statistics

Table 17-1: The Quart Argument

Table 17-2: Descriptive Statistics Formulas

Chapter 21: Managing Information in Tables

Table 21-1: Some Additional Structured-Reference Tags

Table 21-2: Some Formulas That Combine Structured-Reference Tags

Table 21-3: describes the table style elements. Table 21-3 The Elements of a Table Style

Chapter 22: Analyzing Data with PivotTable Reports

Table 22-1: Custom Calculation Options