MS Excel Tutorial Project 2 Page 1 of 32

Short Description
MS Excel Tutorial - Project 2. Page 5 of 32. Enter the Total Row Titles ….. checker is finished, it displays the Microsoft Excel dialog box / Microsoft …

Website: www.helpdesk.au.edu | Filesize: 4055kb

Content
MS Excel Tutorial - Project 2
Page 1 of 32MS Excel Tutorial - Project 2
Page 2 of 32
Table of Contents
Project Two - BetNet Stock Club……………………………………………………….. 3
Entering the Titles and Numbers into the Worksheet …………………………… 3
Enter the Worksheet Title ………………………………………………………………. 3
Enter the Column Titles………………………………………………………………….. 4
Enter the Stock Data ……………………………………………………………………… 4
Enter the Total Row Titles ………………………………………………………………. 5
Entering Formulas ………………………………………………………………………… 5
Enter a Formula Using the Keyboard ………………………………………………… 5
Order of Operations ………………………………………………………………………. 7
Entering Formulas Using Point Mode ………………………………………………… 7
Enter Formulas Using Point Mode…………………………………………………….. 7
Copy Formulas Using the Fill Handle…………………………………………………. 9
Determine Totals Using the AutoSum Button ……………………………………..10
Determine the Total Percentage Gain/Loss ……………………………………….10
Determine the Average of a Range Using Keyboard/Mouse…………………..11
Determine the Highest Number in a Number Range …………………………….12
Determine the Lowest Number in a Range Using Min …………………………..13
Copy a Range of Cells across Columns to an Adjacent Range…………………14
Verify a Formula Using Range Finder………………………………………………..15
Verify a Formula Using the Auditing Commands …………………………………16
Change the Font and Center the Worksheet Title ………………………………..17
Change the Title Background, Font Colors and Apply an Outline Border…..18
Bold, Center, and Underline the Column Titles ……………………………………19
Center Data in…