Using Formula Assistance in the Web App
Excel has a very handy formula assistance tool that walks you step-by-step through the process of inserting formulas. Most of us are capable of building simple calculations through clicking the appropriate cells and selecting the ranges that we want to include. Some formulas involve several different elements (also called arguments), and they can be a bit more challenging.
As you might expect, Excel Web App users wanted the same formula assistance they are accustomed to using in the Excel app, and they let Microsoft know about it. Voila! In the most recent update, formula assistance was added to the Web App.
Simply click the Function button on the Insert tab to open the Insert Function dialog box (see Figure 2). Either scroll down through the list of functions, or click the Category drop-down arrow and select a category. Click a function to display a brief description and a helpful list of the items involved in the calculation.
Figure 2 The Insert Function dialog box has descriptions and a list of elements for each built-in formula.