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]
Which of the following is an example of subtraction formula?
A
=A-B
B
=B9/B6
C
=£14.00-£5.00=£9.00
D
=C10-B9
Explanation: 

Detailed explanation-1: -Subtract numbers in a cell To do simple subtraction, use the-(minus sign) arithmetic operator. For example, if you enter the formula =10-5 into a cell, the cell will display 5 as the result.

Detailed explanation-2: -Formulas calculate values in a specific order. A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.

There is 1 question to complete.