Skip to content
Need to learn or teach remotely? Check out our new resources to help you work, learn or teach from anywhere.

1. Introduction to Wage a Sea Battle with Google Sheets

Playback Speed:

You can use a spreadsheet for a variety of purposes, such as to store data, complete calculations, and analyze information. Spreadsheet skills can be extremely helpful for both school and work. But did you know that your spreadsheet skills can also be used for fun?

In fact, you can even use a spreadsheet to make your own game!

In this lesson, you will create a guessing game in a spreadsheet. You will then play your game with a partner.

You will format your spreadsheet to contain a digital ocean and ships. Then you will wage a sea battle on your partner’s enemy fleet!

To complete this lesson, you will: Stake your ocean territory by formatting a grid and adding blue shading, Select cells to represent your ships and add conditional formatting to make them change color when “hit,” Disguise your ships and share your spreadsheet with your partner, Take turns “aiming” at each other’s ships and marking guesses on your spreadsheet, And continue playing until one person has “sunk” all of the other’s ships.

This lesson uses Google Sheets, but you could apply these skills and concepts in most other spreadsheet applications or even on a piece of paper.

To work on this lesson, sign in to your Google account. Open a new tab in your browser, and navigate to If you are not signed in, do so now.

If you do not have a Google account, pause the video and create one now.

For part of the lesson, you will work with a partner. If you don’t have a partner, ask your teacher. Then sit next to or across from your partner. Each of you will work at your own computer. To begin, open Google Drive and create a new spreadsheet.

Give your spreadsheet a title that describes your game.

Then, move on to the next video to begin building your game.

Now, it’s your turn: Sign in to your Google account, Sit next to or across from your partner, Open Google Drive, Create a new spreadsheet, And title it.


  1. Sign in to your Google account.
  2. Sit next to or across from your partner.
  3. Open Google Drive.
  4. Create a new spreadsheet.
  5. Title it.