Intro. to Google Sheets
A grids of rows and columns in which you enter text, numbers, and the results of calculations.
Spreadsheet
________ is a combination of formatting characteristics.
Style
Text that is printed at the bottom of each page.
Footer
Allows you to determine when Sheets calculates formulas in the worksheet.
Manual Calculation
Displays numbers with a fixed number of decimal places.
Number
The intersection of a row and a column.
Cell
To specify how the contents of a cell are lined up horizontally or vertically within a cell.
Align
Blank space around the top, bottom, left, and right sides of a page.
Margin
A constant (text or number) or cell reference used in a formula.
Operand
Displays numbers as dates
Date
The cell in the worksheet in which you can type data.
Active Cell
To hide text that can not fit in the cell.
Truncate
To resize a worksheet to print on a specific number of pages.
Scale
Inserts the SUM function to add long columns or rows of numbers.
Sum Button
Displays numbers with two decimal places and a percent sign
Percentage
An equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A3 and A4.
To move data to a new line when the cell is not wide enough to display all the contents.
Wrap text
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
The sequence used to to calculate the value of a formula.
Order of Evaluation
Displays data in a format you design
Custom
The range is identified by its ___________, which lists both the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon.
Range Reference
What enables you to copy formatting from one cell and paste it to other cells without pasting the first cell's contents?
Format Painter
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.
Freeze Panes
In a formula, to click a cell rather than type its cell reference.
Point-and-click method
Sum the values in a range that meet criteria you specify.
SUMIF