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