Google Sheets Terms

deleting cells, rows, or columns (removing the actual cells)

Actually removing cells, rows, or columns, which requires any adjacent data to shift positions (coordinates)

formula bar

A bar located between the ribbon and the worksheet in which users can easily edit the contents of a cell.

chart editor

Double-clicking on a chart will open the _______

clearing cells (deleting the content of cells)

Highlighting content and removing the contained text or functions by pressing delete

borders

The ____ option allows you to emphasize cells or cell ranges using thick lines.

fill handle

The small square in the lower right corner of a selected cell. It shows crosshairs when selected

insert column

This option (accessed by right-clicking a column letter) allows you to create a new column and push existing columns either left or right

insert row

This option (accessed by right-clicking a row number) allows you to create a new row and push existing rows either up or down

advanced sort

This option allows you to properly sort the data contained in a spreadsheet table (range) by a column heading. It's accessed by clicking Data -> Sort Range -> then clicking _______.

freeze

This option keeps cells within view when scrolling

charts

Visual representations of numerical data within a spreadsheet

cell coordinates

Where rows and columns intersect (it's the address of the cell)

SUM

adds all the numbers in a range to provide a total

AVERAGE

adds all the numbers in a range, & then divides the total by the total number of values

columns

vertical spaces within the spreadsheet; labeled A B C

cells

boxes created where the columns and rows meet

merge

combine two or more cells within a single rectangular area into a merged cell

pattern

content that repeats in a consistent way

auto-fill

copy data to adjacent cells

COUNTIF

counts the number of cells within a range that meet the given condition

COUNT

counts the total number of values in a range

rows

horizontal spaces within the spreadsheet; labeled 1 2 3

spreadsheet

layout of calculated information arranged in rows & columns in a table

protecting a range

prevents changing cell content and formulas accidentally

sort

rearrange the order of a range of cells or the rows based on ABC or 123 order

MAX

return the maximum value in a range

MIN

returns the minimum value in a range

range

selected set of data in a table; two cell names separated by a colon

conditional formatting

the formatting characteristics of a data set changes when user-specified conditions are met. For example, setting a red fill color for all cells containing a value of less than 60%.

replicate

to repeat, to copy, or to duplicate data or a formula

alternating colors

An effect to keep your eyes from skipping when reading data across a row

control clicking

Refers to holding down the Control key and clicking the left (or single) mouse button. Has the same effect as right-clicking with a 2-button mouse.

naming a range

To do this select the "Data" tab, followed by "Named ranges". Within the dialog box enter the name you want to assign to the range and click "Done"

cell reference

Accessing the content of another cell (in either a formula or a function) is called a ___________.

function

Any built-in formula for performing calculations. Examples: SUM, AVE, MIN, MAX

format

Number formatting, text formatting, text alignment, text rotation are some of the option found within the _____ tab.

data validation

This ensures that users enter the correct data into a spreadsheet. Optional dropdowns can also be created.

import

Uploading data to your Google Sheet from another type of spreadsheet software is accessed by the ____ option

range

When referring to multiple adjacent cells

formulas

a series of values and operators put together to perform calculations (must start with the equal symbol)

descending

begin a list with a Z or the highest number

ascending

begin a list with an A or a 1

column headers

cells containing text that informs what data is contained in the rest of the cells in that column

row headers

cells containing text that informs what data is contained in the rest of the cells in that row

cell formatting

changing the appearance of a cell or cells.