hwawestern.blogg.se - Mac excel quick analysis

This time we will be using the Totals option.

When you click on it, you will see that there are a number of different options.

In the lower right corner of your selection, you will see the Quick Analysis tool (see Figure 3.4).

Skip down below Figure 3.5 to continue.)īe sure to press Ctrl ~ to return your spreadsheet to the normal view (the formula results should display, not the formulas themselves). We have alternate steps for Mac Users below. Mac Users: the Quick Analysis Tool is not available with Excel for Mac. In this exercise we will use it to insert the Total Points for each student in Column O. The Quick Analysis Tool allows you to create standard calculations, formatting, and charts very quickly. Figure 3.3 Relative References – Displayed as calculations.

Pressing Ctrl ~ a second time will display your calculations in the default view – as values. Want to see all the calculations you have just created? Press Ctrl ~ (See Figure 3.3.) Ctrl ~ displays your calculations (formulas). You wouldn’t want column N to display an answer that uses the values in column L. These cell references are relative references.īy default, the calculations that Excel copies change their cell references relative to the row or column you copy them to. The calculation in column B reads: =MAX(B5:B24). Note that as you copy the calculation from one column to the next, the cell references change. Now, use the Fill Handle to copy the calculation from Column B through Column N.Select the range of numbers above row 25.You can either keep typing (or double click MAX from the list). Start typing =MAX (See Figure 3.2) Note the explanation you see on the offered list of functions.Open the data file CH3 Data and save the file to your computer as CH3 Gradebook and Parks.

\)īefore we move on to the more interesting calculations we will be discussing in this chapter, we need to determine how many points it is possible for each student to earn for each of the assignments.