When You Insert Rows in a List of Values That

question 140

Essay

When you insert rows in a list of values that are being calculated, such as with a total, Excel most often includes the newly inserted values and recalculates the formulas affected. Depending on what values are in the list and how they are formatted, however, this might not always work as anticipated.
If you think additional rows will be needed, describe two ways to avoid potential problems.

---

Definitions:

Tangible Products

Physical items that can be seen, touched, and used, as opposed to services or digital goods.

Securities

Financial instruments that represent an ownership position in a publicly-traded corporation, a creditor relationship with a governmental body or corporation, or rights to ownership as represented by an option.

Trade Balance

The difference in value between a country's imports and exports over a given period, a component of a country's balance of payments.

Merchandise Exports

Goods produced within a country and sold to customers in another country, contributing to the country's gross domestic product.