O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Q&A

Q1:Why did Excel insert a plus sign next to the function name I entered?
A1: If you access the Function Arguments dialog box by typing an equal sign and the function name in a cell and then pressing Shift+F3, typing the name in lowercase validates the function name. If the function name you entered is correct, Excel converts it to uppercase automatically. If the function name is incorrect or invalid, Excel inserts a plus sign and leaves the invalid name in lowercase.
Q2:I got stuck when I was working with a complex function in the Function Arguments dialog box. What should I have done?
A2: If you need help with a particular function while you're in the Formula palette, click the Help button. Excel's Office Assistant walks you through either ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required