You use the paste options button labeled if you want the pasted chart not to be linked to the source document and you want the pasted chart to keep the formatting from the source document.

a) use destination theme & embed workbook
b) use destination theme & link workbook
c) keep source formatting & embed workbook
d) keep source formatting & link data

Keep Source Formatting & Embed Workbook

Explanation:

Source formatting is used to apply the formatting from source document while copying and pasting.

Source is the place where the data is already placed and we want to move it make a copy of it on some other document. So if we don't want to change the formatting of source document, we choose source formatting from the options while pasting.

Embed is used to whenever we don't want to link the formatting with source document.

So,

You use the Paste Options button labeled Keep Source Formatting & Embed Workbook if you want the pasted chart not to be linked to the source document and you want the pasted chart to keep the formatting from the source document.

yes we can change both the color of the value of a cell as well as background color of a cell at the same time .

as we know that excel sheet consists of columns and rows.

and intersection of column and row is called cell.

we can change color of the cell and background of the cell at the same time.

hence the statement that

can a person change color of the cell and background of the cell at the same time is true.