Mid Quarter Knowledge Check

Alyssa has created a spreadsheet for her sea battle game. In the picture below, where should she click to add a title to her spreadsheet?

• A
• B
• C
• D

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
• B
• C
• 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
• B
• C
• 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

The text on Raj's spreadsheet is too small and hard to read. What should Raj do to make the text larger?

• Resize the text
• Add another text box
• 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 dictionary
• A condition
• A key
• A pixel