USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
|
=B4+C4
|
|
=B4*C4
|
|
=B4/C4
|
|
=B4-C4
|
Explanation:
Detailed explanation-1: -Calculate the difference between two numbers by inputting a formula in a new, blank cell. If A1 and B1 are both numeric values, you can use the “=A1-B1” formula. Your cells don’t have to be in the same order as your formula. For example, you can also use the “=B1-A1” formula to calculate a different value.
Detailed explanation-2: -Follow these steps to subtract numbers in different ways: Select all of the rows in the table below, then press CTRL-C on your keyboard. In the worksheet, select cell A1, and then press CTRL+V.
There is 1 question to complete.