It is a great way for students to be able to see the power of Google Sheets all while having fun.
Players will need to make a copy of the sheet, rename it, and then share it with another player (who also has editing rights).
Players then need to select the tab at the bottom of the sheet and be either Player 1 or Player 2. They will then need to place their "ships" using the following:
Once placed, players will then be able to play the game. If students want to chat, they can since they are on the same sheet by selecting the name in the upper right (to the left of Share button).
Then, players can use what you see below to play the game.
Embedded below is a GIF followed by a 2 minute and 32 second YouTube tutorial.