Page 23 of 24PREVNEXT

Get to know Excel: 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 Print on the File menu.

Click Normal on the View menu, and then click Print.

Point to Formula Auditing on the Tools menu, click Formula Auditing Mode, 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.



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




Page 23 of 24PREVNEXT