|The following is a learning
activity on how to create a chart and format cells and text within Microsoft
Excel. A spelling template utilizing the ascending and descending buttons
will be created at the same time and the Autosum feature will be used.
Document Window Title Bar - displays the name of the file. Dragging the title bar, moves the window and double clicking it maximizes the size of the window.
Document Window Control Menu Box - appears when window is maximized and when clicked, has a drop-down menu with commands to control the window.
Exit, Maximize & Minimize Buttons - These buttons allow you to shrink the window to an icon on the taskbar, enlarge and reduce window and exit the program.
Menu Bar - Pull-down listings of the commands that are available for use.
Toolbar - The tools that are available as short cut keys in Excel.
Formula Bar - Displays the contents of the cell that is highlighted.
Cell Reference - Indicates the column letter and row number of the current cell that is highlighted.
Row Headings- Horizontal lines of information identified with numbers. A single worksheet can have up to 16,384 rows of information.
Column Headings- Vertical lines of information identified with letters. A single worksheet can have up to 256 columns of information.
Cell- The location of where individual data is stored in your worksheet that is the insertion point between a row and a column.
Select All Button - By clicking this button you are selecting all of the cells in the worksheet.
Scrolling Buttons - Allows you to move to areas of your worksheet that are currently visible on your screen.
Activity One: Learning the Basics!
"Spell to Excel"
I. Getting Started
Setting Default Font
Enter data using keyboard. Use tab, arrow keys, mouse or enter to travel between cells. Tab moves you to the right. Enter moves you down. Remember: The active cell is highlighted showing a double box.
In A1 type: Spelling Word
Press Enter to go to row 2.
In A2 type: girl
To Replace or Edit Data
II. Formatting Your Chart - The Basics
III. Formatting Columns and Rows
Changing the Column Width
Change Column C with the Mouse
Changing Row Height
Lets change all the remaining rows to a different height.
IV. Formatting Cells
Changing Font Color
Formatting Cells With Color and Patterns
V. Inserting, Deleting and Clearing Rows and Columns
Rows (Insert and Clear)
VI. Moving Data
Dragging with the Mouse
Using Cut and Paste to Move Data
VII. Spellchecker and Ascending and Descending
Ascending and Descending
VIII. Page Setup
Header and Footers
Next and Previous
X. Save and Print
|©1999, Kathy D. Adkins|