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 |

This formula in Excel determines if any conditions in a test are TRUE.
| IF | ||
| AND | ||
| OR | ||
| None of the above |

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
Get step-by-step solutions from verified subject matter experts
