In cell B$22,$ you entered: $=$AVERAGE$($B$15$:B$20).$ If cell B$22$ is copied and pasted into cell D$30,$ which of the following is true for cell D$30?$

The function will remain $=$ AVERAGE$($B$15$:B$20)$

The function will be modified to $=$AVERAGE$($D$30-$D$35)$

The function will be nodiffed to $=$ANERAGE$($B$15$:DB$9)$

The function will be modiffed to $=$AVRRAGE$($D$23$D$28)$

Functions camot be copied and pasted into other cell locations on a norksheet.