Create a reference that displays linking between cell C3 of Sheet1 and Cell C3 in Sheet 4 of Sheets to get average.
Answers
Answered by
1
=AVERAGE(Sheet1:Sheet4!C3:C3) is the correct answer to the given question .
Explanation:
- The cell reference relates to the single cell or the set of cells on some of the sheet that can be used in a process to help Excel and locate the variables or information we choose to measure for the certain calculation.
- As mention in the question we have to find the average so we used the average function along with the range and the sheet cell range .It will display the average of the linking cell.
Learn More :
- brainly.in/question/5321973
Similar questions