In Excel cell function and references are helpful to better understand Excel spreadsheets. Use Excel cell reference functions as well.
- Open our practice workbook.
- Select cell D6 and type hlee.
- Clear the contents in row 14.
- Delete column G.
- Using either cut and paste or drag and drop, move the contents of row 18 to row 14.
- Use the fill handle to put an X in cells F9:F17.
- When you're finished, your workbook should look like this: