The SCAN function is best used when you need a running total—a sum that accumulates row by row, with the accumulated value ...

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.