USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The Excel formula to calculate:76 times 180 minus the difference between 345 and 126
|
|
=76+180-345-126
|
|
|
=180*76-(345-126)
|
|
|
=76 x 180-(345-126)
|
|
|
None of the above
|
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: -The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument. For example, =EDATE("9/15/19", -5) returns 4/15/19. For this example, you can enter your starting dates in column A.
There is 1 question to complete.