You can print this view, which helps with both spreadsheet auditing (as you can see exactly which formulas reference which cells) and will aid students turning in assignments (as many classes require formulas to be visible). A new Formula List feature displays every formula in your project, and shows you the cells used in each formula. This change makes entering formulas much faster than it was in Numbers ’08. When you click or type, the placeholder is replaced by a cell reference or your new content. (If you forget the function of a placeholder, hover your mouse over it to view an explanatory floating tooltip.) To enter a value, click on a placeholder, then click in the table or type in a value. In Numbers ’09, the placeholders are clickable buttons. In Numbers ’08, these placeholders were text, which had to be removed when inserting values. As before, an Insert Function button places the formula on your table, complete with placeholders for the variables. Variable definitions, usage notes, examples, and links to related content can all be found here.Īdding functions to a table has gotten easier. The new Function Browser not only makes it a snap to find any function, but there’s extensive help available.
#ADD STANDARD DEVIATION BARS IN NUMBERS FOR MAC MANUAL#
If that’s not enough help, there’s an extensive, detailed manual just for formulas and functions that you can access through the Help menu. Where Numbers ’08 provided one line of text for a given function, Numbers ’09 not only offers longer explanations, but also adds sections that describe each variable in the function, usage notes, examples, and links to related topics. A new Function Browser offers greatly expanded help on every function. But the most notable changes are in the Statistical category, with over 30 new functions, including AVERAGEIF, CHITEST, and many more.
0 kommentar(er)
