What is the use of copy value and use one as many function?

Question

Accepted Answer

Copy value function copies a value from one cell to another while use one as many function copies a formula from one cell to multiple cells.

Copy value function is useful when you want to duplicate a value in another cell without having to manually type it again.
Use one as many function is useful when you want to apply a formula to multiple cells without having to manually enter it in each cell.
Copy value function can be accessed by right-clicking on a cell and selecting 'Copy' and then right-clicking on another cell and selecting 'Paste'.
Use one as many function can be accessed by selecting the cell with the formula, clicking on the bottom right corner of the cell and dragging it down to the desired number of cells.
Copy value function is also useful when you want to copy a formula as a value.
Use one as many function is also useful when you want to apply a formula to a column or row of data.

Top EY Global Delivery Services ( EY GDS) Staff Assistant interview questions & answers