USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The formula is more professional looking.
|
|
|
The formula will be more accurate.
|
|
|
The formula result will automatically update when cell values change.
|
|
|
None of the above
|
Detailed explanation-1: -If you want to add the values that are in cells C1 and C2 (93 and 14), why would you use cell reference in the formula (=C1+C2) instead of just writing the formula like this: =93+14? The formula is more professional looking. The formula will be more accurate.
Detailed explanation-2: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-4: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.