Microsoft Excel 2000

II. Project Two

A. Starting Excel and resetting the toolbars [E 2.6]

To start Excel and reset the toolbars

1. ___________________________________________________________________________________

2. ___________________________________________________________________________________

3. ______________________________________________________________________________________________________

4. ______________________________________________________________________________________________________

5. ______________________________________________________________________________________________________

______________________________________________________________________________________________________

6. ______________________________________________________________________________________________________

______________________________________________________________________________________________________

III. Entering titles and numbers into the worksheet [E 2.7]

One of the reasons Excel is a valuable tool is that you can ________________________________________________________

________________________________________________________________________________________________________

To enter a formula using the keyboard

1. _____________________________________________________________________________________________________

2. _____________________________________________________________________________________________________

The equal sign (=) is an important part of the formula because ______________________________________________________
_______________________________________________________________________________________________________
Valid arithmetic operators include:

- ___________________________________ % __________________________________________

^ ___________________________________ * __________________________________________

/ ___________________________________ + __________________________________________

- ___________________________________

A. Order of operations [E 2.10]

Moving from left to right in a formula, the order of operations is _____________________________________________________

_______________________________________________________________________________________________________

You can use parentheses to ________________________________________________________________________________

B. [E 2.11]Point mode allows you to _________________________________________________________________________

C. [E 2.14]Relative references are ____________________________________________________________________________

A blank cell has a numerical value of __________________________________________________________________________

V.Using the AVERAGE, MAX, and MIN functions [E 2.16]

Functions are ____________________________________________________________________________________________

Arguments are ___________________________________________________________________________________________

You can enter functions using one of three methods:

1. ____________________________________________________________________________________________________

2. ____________________________________________________________________________________________________

3. ____________________________________________________________________________________________________

VI. Verifying formulas [E 2.23]

One of the most common mistakes is to include _____________________________________________________________.

o Auditing commands allow ________________________________________________________________________________

o The Trace Precedents command highlights __________________________________________________________________
______________________________________________________________________________________________________

o The Trace Dependents command highlights _________________________________________________________________
______________________________________________________________________________________________________

o The Remove All Arrows command removes _________________________________________________________________

o Range Finder can be used to _____________________________________________________________________________
_______________________________________________________________________________________________________

A. Verifying a formula using Range Finder [E 2.24]

To verify a formula using Range Finder

1. _____________________________________________________________________________________________________

2. _____________________________________________________________________________________________________

[E 2.24]To change the active cell to the one at the other end of the blue line___________________________________________

________________________________________________________________________________________________________

[E 2.32]Remove borders by _________________________________________________________________________________
Remove a background color by ______________________________________________________________________________
Change font color back to black by ____________________________________________________________________________

[E2.345] The Cells command on the ___________ menu or the Format Cells command on the ______________ menu is used to _______________________________________________________________________________________________________

· The Currency style format displays _________________________________________________________________________
_______________________________________________________________________________________________________

· The Currency style button assigns _________________________________________________________________________

o A fixed dollar sign displays ______________________________________________________________________________

o A floating dollar sign displays ____________________________________________________________________________

· The Comma style format inserts __________________________________________________________________________
_______________________________________________________________________________________________________

E. Formatting numbers using the Formatting toolbar [E 2.36]

The Increase Decimal button displays _________________________________________________________________________

The Decrease Decimal button removes ________________________________________________________________________

G. Formatting numbers using the Percent Style button and Increase Decimal button [E 2.39]

The Percent Style button displays ____________________________________________________________________________
_______________________________________________________________________________________________________
The Conditional Formatting command is used to _________________________________________________________________
_______________________________________________________________________________________________________

H. Conditional formatting [E 2.40]

Conditional formatting is ____________________________________________________________________________________

A condition is ____________________________________________________________________________________________

In the Conditional Formatting dialog box:

· The Preview window shows ______________________________________________________________________________

· The Add button allows ___________________________________________________________________________________

· The Delete button allows _________________________________________________________________________________

I. Changing the widths of columns and heights of rows [E 2.43]

Excel’s default column width is 8.43 characters, or 64 pixels.

· A character is_________________________________________________________________________________________

· A pixel is_____________________________________________________________________________________________

Excel’s default row height is 12.75 points, or 17 pixels.

· A point is_____________________________________________________________________________________________

J. Changing the width of columns [E 2.43]

Best fit means ____________________________________________________________________________________________

Excel allows column widths to be changed _________________________.

Hiding is ________________________________________________________________________________________________
To hide a column ________________________________________________________________________________________________________
To display a hidden column _________________________________________________________________________________

VIII. Excel’s spell checker looks for errors by comparing ___________________________________________________________

_________________________________________________________________________________________________ [E 2.48]

In the Spelling dialog box:

· The Change to box displays ______________________________________________________________________________

· The Suggestions list displays ____________________________________________________________________________

· Click the Change button to ______________________________________________________________________________

· Click the Change All button to ____________________________________________________________________________

· Click the Ignore button to ________________________________________________________________________________

· Click the Ignore All button to ______________________________________________________________________________

· Click the Add button to _________________________________________________________________________________

· Click the AutoCorrect button to ___________________________________________________________________________

A. [E 2.54] In the Print what area of the Print dialog box:

· The Selection option button instructs _______________________________________________________________________

· The Active sheet(s) option button instructs __________________________________________________________________

· The Entire workbook option button instructs __________________________________________________________________

XI. Displaying and printing the formulas version of the worksheet [E 2.55]

· The values version shows ________________________________________________________________________________

· The formulas version displays ____________________________________________________________________________
The formulas version of a worksheet is useful for debugging. Debugging is ____________________________________________
_______________________________________________________________________________________________________

To toggle between values version and formulas version, press _____________________________________________________
The Fit to option can be used to ______________________________________________________________________________