All categories

2 years ago

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

Business

1 answer:

morpeh [17]2 years ago

5 0

Answer: =MONTH(F5)

Explanation:

The MONTH function in Excel returns the month, a number from 1 (January) to 12 (December).

It’s syntax is;

“=MONTH(serial_number)”

Where serial number refers to the date in question, which could either be a date itself or a cell reference.

The MONTH function is used to extract the month number from a date.

If cell F5 contains “July 8, 2016”, the formula “=MONTH(F5)” inputed in another cell will give the value “7”.

This is because the month July is the 7th month of the year.

You might be interested in

Which of the following marketing variables is concerned with design, quality,

Daniel [21]

Answer:

A. Product APEX

Explanation:

This is the correct answer.

3 0

3 years ago

Connor Corp. has large amount of data that they are trying to analyze from the last 15 years. They have an arithmetic sales grow

MrRa [10]

Answer:

11.14%

Explanation:

Blume's formula is used to combine both arithmetic and geometric returns. This is because using arithmetic growth rate exclusively would be overly optimistic for longer time horizons and on the other hand, using geometric growth rates exclusively would be overly pessimistic for short time horizons.

Using the attached formula, plug in the given numbers;

R(T) would be the sale growth rate we need to calculate.

R(T) = $\frac{5-1}{15-1} *0.09 + \frac{15-5}{15-1} *0.12$

R(T) =0.0257 + 0.0857

R(T) = 0.1114 as a decimal

Therefore, the forecast sales growth would be 11.14%

7 0

2 years ago

Mary wants to create a brochure for her new canoe rental business. What type of application software should she use?

xeze [42]

C publishing software

7 0

3 years ago

Read 2 more answers

Watters Umbrella Corp. issued 15-year binds two years ago at a coupon rate of 6.2 percent. The bonds make semiannual payments. I

Sholpan [36]

Answer:

YTM = 6.42%

Explanation:

current market value = $1,000 x 98% = $980

n = (15 - 2) x 2 = 26

coupon = $1,000 x 6.2% x 1/2 = $31

face value = $1,000

YTM = [coupon + [(face value - market value)/n]} / [(face value + market value)/2]

YTM = [31 + [(1,000 - 980)/26]} / [(1,000 + 980)/2]

YTM = (31 + 0.77) / 990 = 31.77 / 990 = 0.03209 x 2 (annual yield) = 0.641818 = 6.42%

5 0

2 years ago

Ohlson Co. is preparing an Excel spreadsheet for its 20-year, 4.5%, $500,000 bonds payable. The bonds were issued on January 1 t

uranmaximum [27]

Answer:

=E7*C2/2

Explanation:

The interest expense will be the carrying value of the bond times the effective interest rate.

On cell C8 we have the interest expense

On E7 we have the carrying value which is the outstanding balance.

Then, on C2 we got the effective rate

As this is an annual formula, we must divide by two to convert to semiannual rate.

A file is attached for how the excel sheet looks like

6 0

2 years ago