Question: What does cells(1,2) refer to in VBA? A2 B2 A1 B1 This formula in Excel determines if any conditions in a test are TRUE. IF

What does cells(1,2) refer to in VBA?

A2

B2

A1

B1

What does cells(1,2) refer to in VBA? A2 B2 A1 B1 This

This formula in Excel determines if any conditions in a test are TRUE.

IF

AND

OR

None of the above

formula in Excel determines if any conditions in a test are TRUE.

If I want to increment dates by three months, what formula would I use? Assume that date is a date reference in your spreadsheet.

=date(date,3)

=edate(date,3)

=date+3

=edate(date,+3)

=edate(date,1)

What is the value of cell A4? A B C 8 -4 1 6 2 =MAX(A1:01) 3 =MIN(A1:01) 4 =A2*A3 0-12 0 -32 36 30 O 12 Assume the following cash flows: Year 0 1 2 3 4 5 Project A $150,000 8,000 30,000 45,000 55,000 85,000 Project B -$150,000 80,000 40,000 35,000 25,000 20,000 What is the NPV for Project A assuming the WACC is 10%? $6,219.33 $11,574.90 $5,653.94 $10,522.64 What is the value of cell A4? A B C 8 -4 1 6 2 =MAX(A1:01) 3 =MIN(A1:01) 4 =A2*A3 0-12 0 -32 36 30 O 12 Assume the following cash flows: Year 0 1 2 3 4 5 Project A $150,000 8,000 30,000 45,000 55,000 85,000 Project B -$150,000 80,000 40,000 35,000 25,000 20,000 What is the NPV for Project A assuming the WACC is 10%? $6,219.33 $11,574.90 $5,653.94 $10,522.64

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!