To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.?

If you change the value in a cell that is referenced in a formula, the formula will re-calculate automatically.

a. true b. false

Having common fields is important when you begin to build ________ between the tables

Fill in the blank(s) with correct word