DATABASE FUNDAMENTALS
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: -What’ll you need to do is subtract today’s date from the project start date. Excel has a TODAY function built in, which will save you from typing in the date in the correct format and continually updating as the days change. So, the formula is: =TODAY() – B2.
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.