If the Sales figure for Week 2 is increased to 1500, the profit for Week 2 will remain the same. This is incorrect so that the formula in C4 will need to be changed to =1500-800 and then the profit will be correct.
Should be used in the formula to calculate the profit. Therefore cell C4 should contain the formula =C2-C3. Then whenever a Sales or Costs figure is changed, the profit calculation is automatically updated.
Cells occurring in a rectangular shape, defined by the cell address of the cell in the upper-left corner and the cell address of the cell in the lower-right corner separated by a colon
Position the mouse pointer over the first cell, press and hold the left mouse button as you drag the mouse over the remaining cells, release the mouse button
Selecting an adjacent cell range with the keyboard
Select the first cell, press the Extend Selection key F8, use the arrow keys to extend the selection, press the F8 key again to switch off the extend mode
A group of cells that are dotted around the worksheet and could contain a number of smaller sub-groups of adjacent cells, written with commas to separate the individual cells or smaller sub-groups