FUNDAMENTALS OF COMPUTER

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?
A
=B4+C4
B
=B4*C4
C
=B4/C4
D
=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.