If you want to look up a specific value found in a data set in a different worksheet in the same workbook, what is the best to pull the value into your active cell? (while maintaining data integrity)
To pull a specific value from a different sheet in the same workbook, you would use a VLOOKUP statement. This function looks for a specific term in a defined range, and returns the correct value.
Y=2x+10, what is the slope of the line? What is the Y-Intercept? What is the X-Intercept?
Slope=2, Y-Intercept= 10, X-Intercept= -5
While considering multiple investment opportunities, what are the major metrics to consider and compare before choosing an investment? Which metric is the best indicator of a good investment opportunity?
While considering multiple investments you should compare the NPV, IRR, Payback Period, and ROI for each investment. The best metric is the NPV, as it considers the time value of money, and will always show the best investment opportunity.