MS Excel Tutorial Project 1 Page 1 of 28

Short Description
MS Excel Tutorial - Project 1. Page 3 of 28. Microsoft Excel Interface. Menu Bar. The menu bar is a special toolbar which displays a menu, such as the file …

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

Content
MS Excel Tutorial - Project 1
Page 1 of 28MS Excel Tutorial - Project 1
Page 2 of 28
Table of Contents
Microsoft Excel Interface……………………………………………………. 3
Menu Bar ………………………………………………………………………… 3
Standard Toolbar and Formatting Toolbar……………………………… 3
Formula Bar …………………………………………………………………….. 4
Status Bar……………………………………………………………………….. 4
Selecting a Cell ………………………………………………………………… 5
Entering Text …………………………………………………………………… 5
To Enter the Worksheet Title…………………………………………….. 6
AutoCorrect …………………………………………………………………….. 7
Entering Column Titles ………………………………………………………. 7
To Enter Row Titles …………………………………………………………… 9
To Enter Numeric Data …………………………………………………….. 10
Calculating a Sum …………………………………………………………… 11
To Sum a Column of Numbers …………………………………………. 11
To Copy a Cell to Adjacent Cells in a Row…………………………….. 13
To Determine Multiple Row Totals at the Same Time …………… 14
Formatting the Worksheet………………………………………………… 15
To Bold a Cell……………………………………………………………….. 15
To Increase the Font Size of a Cell Entry …………………………… 16
Using AutoFormat to Format the Body of a Worksheet …………… 17
To Use AutoFormat to Format the Body of a Worksheet ……….. 17
Centering the Worksheet Title Across Columns …………………….. 19
Using the Name Box to Select a Cell……………………………………. 20
To Use the Name Box to Select a Cell ……………………………….. 20
To Add a 3D
Column Chart to the Worksheet…………………….. 21
To Save a Workbook ……………………………………………………… 24
AutoCalculate…………………………………………………………………. 26
To Use the AutoCalculate Area to Determine…