Analytical Tools for Managers

123456789101112131415
Across
  1. 2. calculates the sum of multiplication between two series of values
  2. 7. the most recent version of lookup formula
  3. 8. makes the dataset customizable with any field as rows, columns or values.
  4. 10. deletes all leading, trailing and in-between spaces except for a single space character between words
  5. 12. extracts the specified number of characters starting from right hand side of the text.
  6. 13. calculates the number of periods/payments by providing rate of return, present value, future value and payments amount.
  7. 14. Free alternate platform to Microsoft Excel
  8. 15. corrects the case-wise formatting of text. The resultant cells have all words with first letter capitalized.
Down
  1. 1. creates a list of counts by giving number of rows, starting place etc.
  2. 3. referencing which changes when the formula is dragged vertically or horizontally
  3. 4. counts the number of numerical values in the selected array.
  4. 5. finds things in a table or a range with the top row as a header.
  5. 6. returns the position of a value in a given table
  6. 9. calculates the internal rate of return by giving various cashflows
  7. 11. allows you to make logical comparisons between a value and allows you display different values subject to fulfillment of the condition