Excel has many automatic functions for calculating, such as SUM. Sometimes you will need to perform a mathematical calculation without using one of these functions.
Start Excel. From the folder that contains your project files, Open the Excel file Meeting_Data_Firstname_Lastname that you saved from the previous export activity.
Click in cell B1, and then type Max to change the column heading. Press to complete the entry and move to cell C1. Click in cell C1, and then type Min to change the column heading. Press . Click in cell D1, and then type Difference as a new column heading. Press to complete the last cell entry.
In cell D2, type the formula =B2-C2 Press . Cell D2 displays the calculated value.
In cell D2, click and drag the fill handle at the lower right corner of the cell to cell D6, and then release the mouse button.
Save your file and leave it open for the next activity.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)