Google Sheets Study Guide

Cell Range

A group of cells (A1:A5)

Spreadsheet Title

By default, any new spreadsheet is named Untitled Spreadsheet. Click the title to rename the spreadsheet.

Text

Cells contain text : letters, numbers, and dates.

True or False: A Google spreadsheet can not contain one or more sheets.

False; A Google spreadsheet can contain one or more sheets.

Modifying all rows and columns allows you to ______________________

...set a uniform size for the spreadsheet's rows and columns.

What is an intersection of a row and a column called?

A cell

Column

A column is a group of cells that runs vertically from top to bottom. Columns are identified by letters.

Fill Handle

A method to quickly copy and paste content from one cell to any other cells in the same row/column. Fill handles can continue series (Columns/rows follow a sequential order : numbers and days.)

Row

A row is a group of cells that runs horizontally from side to side. Rows are identified by numbers.

Delete cell content

Backspace/delete button

Formatting Attributes

Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, percentages can appear as 0.15 or 15%. You can even change a cell's background color.

How to use the paste special option:

Click Edit in the toolbar menu, hover the mouse over Paste Special, and select your desired paste option from the drop-down menu.

To unfreeze rows:

Click View, hover the mouse over Freeze, then select No rows. To unfreeze columns, click View, hover the mouse over Freeze, then select No columns.

To modify all rows and columns:

Click the Select All button just below the formula bar to select every cell in the spreadsheet. Hover the mouse over the line between two rows. The cursor will turn into a double arrow. Click and drag the row border to modify the height. Release the mouse when you are satisfied with the new row height for the spreadsheet.

To unmerge a cell:

Click the drop-down arrow next to the Merge cells button, then select Unmerge from the drop-down menu.

Collaboration Options

Collaboration options allow you to share your spreadsheet with others and make comments as you work.

What are columns identified as?

Columns are identified by letters

Formulas ALWAYS have an __________ to start the equation.

EQUAL SIGN (=)

Cell

Each rectangle in a spreadsheet is called a cell. A cell is the intersection of a row and a column. Click to select a cell.

Sheets Toolbar

Every spreadsheet can have multiple sheets. Select the sheet tabs to navigate among sheets, and click the plus sign (+) to add a new sheet.

Google Sheets uses mathematical expressions called __________bthat make handling these calculations easy.

Formulas

Saved Changes Notification

Google Sheets automatically saves your changes as you work. The saved changes notification lets you know your spreadsheet has been saved.

By freezing rows or columns in place, you'll be able to scroll through your spreadsheet while continuing to see the __________ __________.

Header cells

To modify column width:

Hover the mouse over the line between two columns. The cursor will turn into a double arrow. Click and drag the column border to the right to increase column width. Dragging the border to the left will decrease column width. Release the mouse when you are satisfied with the new column width. All of the cell content is now visible.

To autosize a column's width:

Hover the mouse over the line between two columns. The cursor will turn into a double arrow. Then, double-click the mouse.

To freeze a column:

Locate the column or columns you want to freeze. In this example, we'll freeze the leftmost column. Note: You do not need to select the columns you want to freeze. Click View in the toolbar. Hover the mouse over Freeze, then select the desired number of columns to freeze from the drop-down menu. You can scroll across your worksheet while continuing to view the frozen column on the left.

To freeze a row:

Locate the row or rows you want to freeze. Click View in the toolbar. Hover the mouse over Freeze, then select the desired number of rows to freeze from the drop-down menu. You can scroll down your worksheet while continuing to view the frozen rows at the top.

What is modifying row height for?

Makes cells taller. Changing the row height will create additional space in a cell, which often makes it easier to view cell content.

To insert a column:

Right-click a column heading. A drop-down menu will appear. There are two options to add a column. Select Insert 1 left to add a column to the left of the current column, or select Insert 1 right to add a column to the right of the current column.

To insert a row:

Right-click a row heading. A drop-down menu will appear. There are two options to add a row. Select Insert 1 above to add a row above the current row, or select Insert 1 below to add a column below the current row.

What are rows identified as?

Rows are identified by numbers

If you need to add more than one row at a time:

Scroll to the bottom of the spreadsheet and click the Add button. By default, this will add 1000 new rows to your spreadsheet, but you can also set the number of rows to add in the text box.

Copy and paste cells

Select cells you want to copy & Command+C (Copied cells will have a blue box with lines around it. Then, Command+V to paste the content in another cell.

How to use fill handle:

Select the cell you want to use. A small square—known as the fill handle—will appear in the bottom-right corner of the cell. Hover the mouse over the fill handle. The cursor will change to a black cross. Click and drag the fill handle over the cells you want to fill. A dotted black line will appear around the cells that will be filled. Release mouse to fill selected cells.

To merge cells:

Select the cells you want to merge. Select the Merge cells button. The cells will now be merged into a single cell.

To wrap text:

Select the cells you want to wrap. Open the Text wrapping drop-down menu, then click the Wrap button. The cells will be automatically resized to fit their content.

To move a row or column:

Select the column you want to move, then hover the mouse over the column heading. The cursor will become a hand icon. Click and drag the column to its desired position. An outline of the column will appear. Release the mouse when you are satisfied with the new location.

To delete a row or column:

Select the row you want to delete. Right-click the row heading, then select Delete row from the drop-down menu. The rows below the deleted row will shift up to take its place.

To modify row height: Hover the mouse over the line between two rows.

The cursor will turn into a double arrow. Click and drag the row border down to increase the height. Dragging the border up will decrease the row height. Release the mouse when you are satisfied with the new row height.

Cell Address

The name of a cell. The order of cell address is column and row. Ex : C10.

Shortcut Toolbar

This toolbar provides convenient shortcut buttons for formatting the data in your spreadsheet, like font size, text alignment, and text color.

When should you need to use the paste special option?

Times when you want to copy and paste only certain parts of a cell's content.

Cell Reference

When a formula contains a cell address.

Selecting cells

When selecting a cell, a blue box appears around the selected cell. When clicking on the box, the cursor is an arrow.

Formula Bar

You can use the formula bar to enter and edit data, functions, and formulas for a specific cell.

Toolbar Menu

You can use the toolbar menu options to edit and modify your spreadsheet in various ways. Click a menu and select the desired action from the drop-down list.

The autosizing feature will allow you to set a column's width to fit its content __________.

automatically

Most of the time, you will be using a cell's address in the formula. This is called using a __________ __________.

cell reference

Wrapping the text will automatically modify a cell's row _____________, allowing the cell contents to be displayed on multiple lines.

height

Every row and column of a new spreadsheet is always set to the same __________ and __________.

height and width

Google Sheets

is a web-based spreadsheet application that allows you to store and organized different types of information

Merging allows you to combine a cell with adjacent empty cells to create __________ __________ __________.

one large cell

Google sheets allows you to __________, __________, and __________ different types of information using spreadsheets.

organize, edit, and analyze

If you want to remove the content of a row or column without causing the others to shift:

right-click a heading, then select Clear row or Clear column

Cut and paste cells

select cell you want to cut, Command+X to cut the cells (cell content will remain in its original location until the cells are pasted), select the cells where you want to paste it in.

Freezing is useful when:

times when you'll want to see certain rows or columns all the time, especially when using header cells

Drag and Drop cells

to move a cell's content. Select a cell, hover mouse over an outside edge of the blue box. The cursor will turn into a hand icon. Click and drag the cell to its desired location and release the mouse to drop the cell.