Page 23 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


How would you print formulas?

Click the Microsoft Office Button and then click Print.

Click Normal on the View tab at the top of the screen, click the Microsoft Office Button, and then click Print.

Point to Formula Auditing on the Formulas tab, click Show Formulas, click the Microsoft Office Button, and then click Print.

What does # # # # # mean?

The column is not wide enough to display the content.

The cell reference is not valid.

You have misspelled a function name or used a name that Excel doesn't recognize.

In the practice, you learned that if you misspell SUM in this formula =SUME(B4:B7), you'll get an error value of #NAME? To fix the formula, you must delete it and start over again.

True.

False.

What is the keyboard shortcut to display formulas on the worksheet?

CTRL+`

CTRL+:

CTRL+;

Page 23 of 24PREVNEXT