Google Sheets Introduction
The intersection of a row and a column.
Cell
A line around the edges of a cell.
Border
To duplicate a cell's contents without affecting the original cell.
Copy
In a formula, to click a cell rather than type its cell reference.
Point-and-click method
Adds the numerical values in a range of cells
SUM
The worksheet that is displayed in the work area.
Active Worksheet
A preset collection of design elements, including fonts, colors, and effects.
Theme
The worksheet view for adjusting page breaks in a worksheet.
Page Break Preview
A constant (text or number) or cell reference used in a formula.
Operand
Returns the largest numeric value in the data provided
MAX
Appears to the right of the name box and displays a formula when the cell of a worksheet contains a calculated value.
Formula Bar
Enables you to copy formatting from one cell and paste it to other cells without pasting the first cells contents.
Format Painter
The blue square in the lower-right corner of the active cell or range that you drag over the cells you want to fill.
Fill Handle
Allows you to determine when Sheets calculates formulas in the worksheet.
Manual Calculation
Returns the mean of a series of numbers
AVERAGE
Each cell is identified by a unique _________, which is formed by combining the cell's column letter and row number.
Cell Reference
Text Orientation
To resize a worksheet to print on a specific number of pages.
Scale
A cell reference that does not change when copied or moved to a new cell.
Absolute Cell Reference
=H4*8%
Custom Function
Two or more adjacent ranges and selected cells.
Nonadjacent Range
To shift data within a cell and insert space between the cell border and its content.
Indent
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.
Freeze Panes
A cell reference that adjusts to its new location when copied or moved.
Returns the average of cells in a range that meet criteria you provide
AVERAGEIF