Mastering Microsoft Office 97

Microsoft Excel 2000

I. What is Microsoft Excel 2000? [E 1.6]

Microsoft Excel is____________________________________________________________________________________________

___________________________________________________________________________________________________________

Major parts of Excel:

Worksheets allow____________________________________________________________________________________________

Charts pictorially represent__________________________________. Excel can ________________________________________

__________________________________________________________________________________________________________

Databases manage______________________. For example, _______________________________________________________

_______________. Excel can ______________________________________________________________________________

__________________________________________________________________________________________________________

Web support allows___________________________________________________________________________________________

__________________________________________________________________________________________________________

III. The Excel worksheet [E 1.9]

A workbook is ______________________________________________________________________________________________

Worksheets are______________________________________________________________________________________________

A sheet tab displays__________________________________________________________________________________________

A. The worksheet [E 1.9]

A worksheet is organized into _________________________________________________________________________________.

The column heading is________________________________________________________________________________________

The row heading is___________________________________________________________________________________________

A cell is ____________________________________________________________________________________________________

Each worksheet has _____________ columns and _______________________ rows, or ____________________ cells.

A cell reference is____________________________________________________________________________________________

To identify a cell, specify______________________________________________________________________________________

The active cell is_____________________________________________________________________________________________

Ways to identify the active cell:

v ____________________________________________________________________________________________________

Gridlines are________________________________________________________________________________________________

The mouse pointer displays as:

v a block plus sign whenever______________________________________________________________________________

v the block arrow whenever_______________________________________________________________________________

IV. [E 1.11]A worksheet window is______________________________________________________________________________

Scroll bars, scroll arrows, and scroll boxes can be used to_____________________________________________________________

The tab split box is___________________________________________________________________________________________

A. Menu bar [E 1.12]
The worksheet menu bar displays_______________________________________________________________________________
Each menu name represents___________________________________________________________________________________
To display a menu___________________________________________________________________________________________

v A short menu displays _________________________________________________________________________________

v A full menu lists _____________________________________________________________________________________

Techniques used to display a full menu:

1. ________________________________________________________________________________________________________

2. ________________________________________________________________________________________________________

3. ________________________________________________________________________________________________________

4 ________________________________________________________________________________________________________

On a full menu:

v A hidden command displays____________________________________________________________________________

v A dimmed command displays___________________________________________________________________________

B. Standard toolbar and Formatting toolbar [E 1.12]

The Standard toolbar and Formatting toolbar contain________________________________________________________________

___________________________________________________________________________________________________________

A ScreenTip displays_________________________________________________________________________________________

To display the entire Standard or Formatting toolbar________________________________________________________________

The More Buttons button can be used to__________________________________________________________________________

C. Resetting menus and toolbars [E 1.14]

To reset my usage data and toolbar buttons [MO C.1]

1. _______________________________________________________________________________________________________

2. _______________________________________________________________________________________________________
_________________________________________________________________________________________________________

3. _______________________________________________________________________________________________________
_________________________________________________________________________________________________________

4. _______________________________________________________________________________________________________
_________________________________________________________________________________________________________

5. _______________________________________________________________________________________________________

D. Formula bar [E 1.14]

The formula bar displays_____________________________________________________________________________________

The Name box displays______________________________________________________________________________________

E. [E 1.14]The status bar displays_______________________________________________________________________________

_________________________________________________________________________________________________________

Mode indicators display______________________________________________________________________________________

v Ready mean________________________________________________________________________________________

v Enter means________________________________________________________________________________________

The AutoCalculate area can be used____________________________________________________________________________
Keyboard indicators show____________________________________________________________________________________

V. Selecting a cell [E 1.15]

To enter data into a cell, you first must select it.

To select a cell, either

v Use the mouse to____________________________________________________________________________________

v Use the arrow keys that_______________________________________________________________________________

VI. Entering text [E 1.15]

In Excel, text is____________________________________________________________________________________________

A. Entering the worksheet title [E 1.16]

The insertion point is ______________________________________________________________________________________

Clicking the Enter box or pressing the enter key_________________________________________________________________
Clicking the Cancel box_____________________________________________________________________________________
Text is left-aligned, meaning _________________________________________________________________________________

B. Correcting a mistake while typing [E 1.17]

Use the backspace key to____________________________________________________________________________________

Use the esc key to__________________________________________________________________________________________

C. AutoCorrect [E 1.18]

The AutoCorrect feature corrects______________________________________________________________________________

AutoCorrect makes three types of corrections:

1. _______________________________________________________________________________________________________

2. _______________________________________________________________________________________________________

3. _______________________________________________________________________________________________________

D. Entering column titles [E 1.19]

If the next entry is in an adjacent cell, use________________________________________________________________________

If the next entry is in a non-adjacent cell, click____________________________________________________________________

VII. Entering numbers [E 1.20]

Numbers can contain_________________________________________________________________________________________

Numbers are right-aligned, which means__________________________________________________________________________

VIII. Calculating a sum [E 1.22]

Excel’s SUM function provides_________________________________________________________________________________

The AutoSum button on the Standard toolbar is used to______________________________________________________________

A range is__________________________________________________________________________________________________

IX. Using the fill handle to copy a cell to adjacent cells [E 1.24]

A function can be copied from one cell to another cell or to a range of cells.

v The copy area is______________________________________________________________________________________

v The paste area is______________________________________________________________________________________

When you copy cell references, Excel adjusts them for each new position.
A relative reference is_________________________________________________________________________________________
The fill handle is_____________________________________________________________________________________________

See-through view is ___________________________________________________________________________________________

A. Determining row totals [E 1.25]

To determine multiple totals at the same time

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

3. _________________________________________________________________________________________________________

4. _________________________________________________________________________________________________________

X. Formatting the worksheet [E 1.27]

You format a worksheet to_____________________________________________________________________________________

A. Fonts, font size, and font style [E 1.28]

The font type defines_________________________________________________________________________________________

The font size specifies________________________________________________________________________________________
Font size is gauged in points. A single point » ____________________________________________________________________
Point size is________________________________________________________________________________________________

Font style indicates__________________________________________________________________________________________

B. Displaying the Formatting toolbar in its entirety [E 1.28]

To display the Formatting toolbar in its entirety ____________________________________________________________________ _________________________________________________________________________________________________________

E. Using AutoFormat to format the body of a worksheet [E 1.31]

The AutoFormat command on the Format menu can be __________________________________________________________.

AutoFormat dialog box buttons:

v The Close button allows you to__________________________________________________________________________

v The Cancel button is used to____________________________________________________________________________

v The OK button allows you to____________________________________________________________________________

v The Question Mark button obtains________________________________________________________________________

v The Options button allows you to_________________________________________________________________________

XI. Using the Name box to select a cell [E 1.34]

The Name box is____________________________________________________________________________________________

To use the Name box to select a cell

1. ________________________________________________________________________________________________________

2. ________________________________________________________________________________________________________

XII. Adding a 3-D Column chart to the worksheet [E 1.36]

An embedded chart is________________________________________________________________________________________

Click the Chart Wizard button to_______________________________________________________________________________

The chart location is_________________________________________________________________________________________

The y-axis or value axis (vertical axis) scale is derived_______________________________________________________________
The x-axis or category axis (horizontal axis) titles are_______________________________________________________________
The legend identifies _________________________________________________________________________________________
The default chart type is _______________________________________________________________________________________

XIII. [E 1.41]If power is turned off or lost, a workbook in the computer’s memory is ____________. Any workbook that will be used later must be ___________________________________________________________________________.

A file or workbook is_________________________________________________________________________________________

The .xls extension is__________________________________________________________________________________________

Clicking the Tools button displays_______________________________________________________________________________

The General Options command allows you to______________________________________________________________________
__________________________________________________________________________________________________________

A backup workbook means____________________________________________________________________________________

A password is assigned so_____________________________________________________________________________________
A password is case sensitive, meaning___________________________________________________________________________

Clicking the History button displays_____________________________________________________________________________

XIV. Printing the worksheet [E 1.45]

A hard copy or printout is_____________________________________________________________________________________

XVII. AutoCalculate [E 1.49]

The AutoCalculate area can be used to___________________________________________________________________________

To use the AutoCalculate area to determine an average

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

3. _________________________________________________________________________________________________________

XVIII. Correcting errors [E 1.51]

The method you choose to correct errors will depend on______________________________________________________________

___________________________________________________________________________________________________________

A. Correcting errors while you are typing data into a cell [E 1.51]

If you notice an error while typing data into a cell___________________________________________________________________

___________________________________________________________________________________________________________

B. In-cell editing [E 1.51]

If you notice an error after entering data into a cell

1. If the entry is short________________________________________________________________________________________

___________________________________________________________________________________________________________

2. If the entry is long and errors are minor, use Edit mode.

(a) In-cell editing is__________________________________________________________________________________________
_______________________________________________________________________________________________________

(b) Make your changes.

(1) To insert characters____________________________________________________________________________________
____________________________________________________________________________________________________

(2) To delete characters___________________________________________________________________________________
___________________________________________________________________________________________________
___________________________________________________________________________________________________
Click the Cut button to_________________________________________________________________________________

(3) When you are finished_________________________________________________________________________________

The insert key toggles the keyboard between Insert mode and Overtype mode.

v In Insert mode_______________________________________________________________________________________

v In Overtype mode____________________________________________________________________________________

C. Undoing the last entry [E 1.52]

The Undo command on the ___________________ menu and the Undo button on the _____________________ toolbar can be used to _________________________________________________________________________________________

The Redo button allows you to__________________________________________________________________________________

D. Clearing a cell or range of cells [E 1.53]

Never press the spacebar to____________________________________________________________________________________

To clear cell contents using the fill handle

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

___________________________________________________________________________________________________________

To clear cell contents using the shortcut menu

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

3. _________________________________________________________________________________________________________

To clear cell contents using the delete key

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

To clear cell contents using the Clear command

___________________________________________________________________________________________________________

The Cut button or Cut command allow you to______________________________________________________________________

E. Clearing the entire worksheet [E 1.54]

To clear the entire worksheet

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

The Select All button selects____________________________________________________________________________________

Click the Close button or Close on the File menu to_________________________________________________________________

Click the New button or New on the File menu to___________________________________________________________________

To delete an embedded chart

1. _________________________________________________________________________________________________________

2. _________________________________________________________________________________________________________

XIX. [E 1.54]The Excel Help system can be used to_______________________________________________________________

The Office Assistant answers___________________________________________________________________________________

IntelliSense™ technology is____________________________________________________________________________________