USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It will automatically create a sparkline in the next cell
|
|
|
It will allow you to format your spreadsheet quicker
|
|
|
If the cell is changed, your formula will automatically update
|
|
|
There is no advantage
|
Detailed explanation-1: -The true advantage of cell references is that they allow you to update data in your worksheet without having to rewrite formulas. In the example below, we’ve modified the value of cell B1 from $1, 200 to $1, 800. The formula in B3 will automatically recalculate and display the new value in cell B3.
Detailed explanation-2: -Instead of hard typing all the values used in your spreadsheet it is possible to use cell references as well. This means that your spreadsheet becomes more dynamic and will change accordingly when the values in the cells change.
Detailed explanation-3: -What is an advantage, if any, to using cell references instead of just typing in values? If the cell is changed, your formula will automatically update.
Detailed explanation-4: -Using cell references allows you to easily change the values in the computation. If you use the actual number values instead, then if the values change you have to dig through the formula(s) to find and change the values.
Detailed explanation-5: -Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.