How cell reference is useful in calculation?
Answers
Answer:
When you create a simple formula or a formula by that uses a function, you can refer to data in worksheet cells by including cell references in the formula arguments. For example, when you enter or select the cell reference A2, the formula uses the value of that cell to calculate the result.
Explanation:
Plz mark as brainliest
Answer:
pls mark me brainleist
Explanation:
Calculating the numbers in Excel sheet, not only help you to give the final 'sum up' of the number but, it also calculates automatically the number replaced by another number or digit. Through Excel sheet, the complex calculations become easy like payroll deduction or averaging the student's result.
In excel, Cell reference is used to calculate the total number. For instance here we had calculated the total number of computer items sold across different region in U.S.A by using formula =Cell (C2,C3,C4,C5) at the end you get the total $ 20, 500, as shown in next
In order to avoid writing the data again and again for calculating purpose, cell reference is used. When you write any formula, for specific function, you need to direct Excel the specific location of that data. This location is referred as, cell reference. So, every time a new value added to the cell, the cell will calculate according to the reference cell formula.