Wage a Sea Battle with Google Sheets (Middle/High School)

Marc wants to add a border around a group of cells in his spreadsheet. In the picture below, where should Marc click to add a border?

• A. [Icon labeled A]

• B. [Icon labeled B]

• C. [Icon labeled C]

• D. [Icon labeled D]

Meg is placing her ships in her sea territory. In the picture below, where should Meg click to shade the cells representing her ship a different color?

• A. [Icon labeled A]

• B. [Icon labeled B]

• C. [Icon labeled C]

• D. [Icon labeled D]

Mina is formatting her game sheet so that the cells are square. What should Mina do to create square cells in her sheet?

• Change the fill color of her cells

• Add borders to each of the cells

• Adjust the pixel size of the rows and columns

• Add a border around a section of rows and columns

Rory wants to adjust the width of their Documents column. In the picture below, what should Rory click to change the width of the column?

• Add another text box

• Resize the text

• Center the text

• Change the color of the text

Isaac and Marina are using conditional formatting to show when a ship has been "hit" in the game. What does conditional formatting do?

• Changes the color of cells, rows, or columns based on rules

• Resizes all of the text in a spreadsheet at once

• Adds a border around the rows and columns that make up a game area

• Deletes text from a cell if the cell meets certain conditions

Bradlee and his partner Rafael are guessing the location of each other's ships by calling out the column letter and row number of different cells. What is this address (for example, A1) called?

• Formula

• Cell reference

• Hit

• Conditional formatting

Dominique wants her partner to easily find Dominique's territory in her spreadsheet. What should Dominique do to add a descriptive label to the tab at the bottom of the spreadsheet?

• Make a copy of the tab in the spreadsheet

• Open the share settings for the tab in the spreadsheet

• Give her partner viewing access to the tab in the spreadsheet

• Rename the tab in the spreadsheet

Nadia is sharing her spreadsheet with her partner. What should Nadia do so that her partner cannot make any changes to the sheet?

• Share the spreadsheet with viewing permission

• Add conditional formatting to the spreadsheet

• Share the spreadsheet with editing permission

• Add a border around the cells of the game territory

Chase and their partner added a list with the name of each ship and how many cells that ship contains to their spreadsheet to help keep track of which ships have been sunk. What is this list called?

• A. A dictionary

• B. A condition

• C. A key

• D. A pixel

What was most difficult about this lesson?

• Understanding the main concept

• Completing the exercises

• Following the instructions

• Staying focused