Part 3/6:
Now, hold down the Control key on your keyboard. As you do this, click on each cell you wish to include in your calculations (for instance, C6, E6, and G6). Once you’ve selected all desired cells, simply hit Enter to achieve the correct total instantly.
Calculating Averages with the Control Key
The method used for summing cells can also be applied to average calculations. If you want to compute the average of the selected cookies, initiate the following steps in cell I6:
=AVERAGE(
Then, again while holding the Control key, click on the cells you wish to average. Conclude by pressing Enter, and Excel will provide you with the average of those numbers efficiently.