To refresh an external data range automatically when the parameter value changes, you must select a single cell to supply ...