1. AutoSum:

• AutoSum is a quick way to sum a column or row of numbers.

• Select the cell where you want the sum to appear.

• Click the "AutoSum" button on the Home tab in the Editing group (it looks like the Greek letter sigma, Σ).

• Excel will automatically suggest a range for the sum based on adjacent cells. If it's correct, press Enter to confirm. If not, select the desired range manually.

2. Totaling a Column or Row:

• To manually total a column or row of numbers:

  • Select the cell where you want the total to appear.

  • Use the SUM function. For example, to sum a range of numbers in cells A1 to A10, type =SUM(A1:A10) and press Enter.

3. Averaging Data:

• To find the average of a range of numbers:

  • Select the cell where you want the average to appear.

  • Use the AVERAGE function. For example, to find the average of numbers in cells B1 to B10, type =AVERAGE(B1:B10) and press Enter.

4. Ranking Data:

• To rank data based on values in a column:

  • Suppose your data is in column C, and you want to rank it in ascending order.

  • In an adjacent column (e.g., D), enter the formula =RANK.EQ(C1, $C$1:$C$10, 0) in cell D1. This formula ranks the value in C1 compared to the values in C1 to C10 in descending order. If you want ascending order, change the "0" to "1" in the formula.

  • Drag the fill handle (a small square at the bottom-right corner of the cell) down to apply the formula to all the data in column C.

  • Column D will now display the ranks of the corresponding values in column C.