Rather than dealing with pivot tables and VLOOKUP, I was answering questions about the name for the intersection of a row and column, plus far too many simple questions about using AutoSum.
Can you imagine 300 million potential job applicants who will swear they use Excel who have never even clicked the AutoSum button?
Hover over that icon, and it confirms that this icon is generally found on Home tab | Editing | AutoSum Average.
In Figure 3, someone has already used the AutoSum in rows 4, 7, and 12.
The Secret Life of the AutoSum Icon: Ad Hoc Totals of Filtered Records
Regular Excel users are familiar with the AutoSum button, the Greek letter Sigma icon in the toolbar.
When you click the AutoSum icon, you won't get SUM formulas.
Excel: To easily add noncontiguous numbers, place your cursor in the cell you want the sum to appear, click on AutoSum
([SIGMA]), and while you're holding down the Ctrl key click on each of the cells you want to include.
Mouse: Place your cursor on B13 (one cell below the column you are adding) and click on the AutoSum icon: [[summation of]], producing this screen (notice the shortcut actually generates the same full formula):
While you're at the AutoSum icon, click on the adjacent arrow and take note of the other quick functions you can perform (see screenshot at right).
I know I can add a column of numbers by writing a formula such as =sum(A1+A12, or by clicking on AutoSum
] automatically enters the sum of any column or row of values.