Select the range O5:O25 and click the Bold button.Ĭolumn P requires a Percentage calculation.Select the range B5:O25 then click the AutoSum button on the Ribbon (Home tab or Formulas tab).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.
Examine the Quick Analysis Tool to create standard calculations, formatting, and charts very quickly.