Question: You re about halfway through an important job interview and things

You're about halfway through an important job interview, and things seem to be going well. The interviewer has sat back in her chair, and seems increasingly comfortable talking with you. Then she slides her laptop over to you. Excel is running, and there is a table showing annual growth in profit for their company for the past 5 years:
a.) The interviewer then says, "And we also give a short Excel proficiency test during interviews like this. I'm going to go grab some coffee. May I get you a cup? Just go ahead and calculate the 1-, 3-, and 5-year average annual growth rates on those figures and I'll be back in a few minutes." Required: Calculate the average annual growth rates in 3 minutes or less.
b.) Assume you calculate the growth rates correctly. The interviewer looks over your work and says, "Great – believe it or not, many job applicants can't do that. One more thing – looking at those growth rates you calculated, how would you describe the trend in the company's growth?" Required: Give her a concise, accurate answer.

Sale on SolutionInn
  • CreatedAugust 07, 2015
  • Files Included
Post your question