Question

 If you select ________ then any values modified in the source range are automatically updated in the target range. *

10 point

a. Link to source data

b. Link to sheet data

c. Link to original data

d. Link to source range​

Answer 1

Answer:

a. Link to source data

Explanation:

If you link the data, any values modified in the source range are automatically updated in the target range. rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed.

Answer 2

If you select (a)link to source data then any values modified in the range are automatically updated in the target range.

Definition of link to source data;

A link to source data is a method for connecting one location to another representing digital information.

Definition of Target Range;

Target Range- allows to visualize  the values for a better performance.

Features of link to source data;

• Link to source data allows to gather digital information while making a hyperlink that opens a document and stored in server or internet.
• It allows to manage the accuracy and retains its meaning of data collected.
• The advantages to link the data in worksheet can automatically changes the values in the word document.
• The changes are easily done in texts, numbers, formatting or formulas.

Hence, link to source data can modified the source and the values of the particular data. These data are updated in form of target range that allows to visualize the values for a better performance or services.