Spreadsheets

Google sheets tour

100

is a group of cells that go from the top of the spreadsheet to the bottom. Columns are identified by letters.

Column

200

is a group of cells that go from the left side of the spreadsheet to the right. Rows are identified by numbers.

Row

300

Each rectangle in a spreadsheet is a

Cell

400

is where a column and row intersect. The cell address is the column letter followed by the row number.

Cell Address

500

What can a cell contain?

A number, text, formula, or function

Selecting cells rows and columns

100

. How do you select a row or column in a spreadsheet?

Click

200

Which method is the most common way to select multiple cells?

Click and drag

300

. List the three methods for selecting multiple rows and columns.

Click and Drag, Shift Key, and Ctrl Key

400

Pieces of information that describe the appearance of the cell’s content

Format Attributes

500

The currently selected cell

Active Cell

Formatting Cells

100

Allows you to edit existing data in a cell

Edit mode

200

How the text is positioned within the borders of the cell

Alignment

300

Forces text that is too wide for a cell to fit within the cell by wrapping the text onto other line

Wrap Text

400

What is one way to change the column width in Google Sheets?

Right click

Deleting and Clearing Cells

100

What keyboard shortcut is used to clear content for the selected cell(s)?

Delete

200

What Menu tab would you click to access the Delete command?

Edit Tab

300

What Menu tab would you click to access the Clear Formatting command?

Format Tab

400

What is the keyboard shortcut to clear formatting?

Ctrl+\

copy, cut, and paste content

100

Copy the selected cell(s)

Ctrl+C

200

Paste the cell(s) at the selected location

Ctrl+V

300

Undo previous actions

. Ctrl+Z

400

Cancels a command

Escape

500

: Cut the selected cells

Ctrl+X