This time, I decided to put a Crossword on Excel Functions. This crossword is interactive and you can use browser to play with this. Click in the Grid to start.

Click on Check Puzzle just above Questions to check your score.

If you want to print the Crossword on a paper to play with, download from here Excel Functions Crossword 1

The answer key can be downloaded from here Excel Functions Crossword 1 Answers

If the below Crossword is not properly visible because of WordPress plugin limitation, you can play it properly here Excel Functions Crossword 1

This interactive crossword puzzle requires JavaScript and any recent web browser, including Windows Internet Explorer, Mozilla Firefox, Google Chrome, or Apple Safari. If you have disabled web page scripting, please re-enable it and refresh the page. If this web page is saved on your computer, you may need to click the yellow Information Bar at the top or bottom of the page to allow the puzzle to load.



  • 1. Chooses a value from a list of values
  • 2. Returns the number of rows in a reference
  • 3. Removes all nonprintable characters from text
  • 4. Returns the periodic payment for an annuity
  • 5. Converts a date in the form of text to a serial number
  • 6. Removed leading / trailing blanks
  • 7. Converts text to lowercase
  • 8. Returns the error value #N/A
  • 9. Rounds a number down to the nearest integer
  • 10. Returns the serial number of the last day of the month before or after a specified number of months


  • 11. Rounds up a number to the nearest integer or to the nearest multiple of significance
  • 12. XYZ gives SUM of filtered list in range A1:A10 =XYZ(9,A1:10)
  • 13. Returns a random number between the numbers you specify
  • 14. Returns the k-th smallest value in a data set
  • 15. Checks to see if two text values are identical, Case Sensitive
  • 16. Returns the logical value TRUE

Top Times

  • No Times Recorded Yet