Google Sheets Test Quizlet
Number
0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ %
Range
A selection of cells extending across a row, column, or both.
Chart Sheet
A separate sheet containing only the chart
Formula
A sequence inside a cell that is used to produce a value. It must begin with an equal sign (=).
Cell
A single data point or element in a spreadsheet. The intersection of a column and a row
Column
A vertical set of cells.
Point Mode
Allows you to select cells for use in a formula by using the pointer (mouse).
Spreadsheet
Also called a workbook. The entire document containing your worksheets
Equal Sign (=)
Always precedes a formula in a cell
AutoFill
Enables you to effortlessly copy data to more than one cell.
IF Function
Returns one value if the logical test is true and another if it is false
Pie Chart
a circular chart that is divided up into sections, each of which represents the numerical proportion of the whole
Conditional Formatting
a technique for formatting cells based on whether they meet certain conditions
Spell Checker
used to check the worksheet for spelling errors
Chart
conveys a visual representation of data
Merge Cells
creating a single cell by combining two or more selected cells
AVERAGE Function
sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range.
Order of Operations
the collection of rules that define which mathematical operations take precedence over the others in expressions with multiple operations.
Portrait Orientation
the printed page is taller than it is wide
Landscape Orientation
the printed page is wider than it is tall
Fill Handle
the small green square located in the lower-right corner of the heavy border around the active cell. Used to copy to adjacent cells.
Best Fit
the width of the column is increased or decreased so that the widest entry will fit in the column
SUM Function
Adds all the numbers in a range of cells
Function
A formula prebuilt into Sheets. Can be used to calculate cell, row, column, or range values, manipulate data, and more.
Row
A horizontal set of cells.
Worksheet
The named sets of rows and columns making up your spreadsheet; one spreadsheet can have multiple sheets
+
Used to perform addition in a formula
/
Used to perform division in a formula
*
Used to perform multiplication in a formula
-
Used to perform subtraction in a formula
Source Area
Cell or cells being copied (copy area)
Logical Test
The decision-making process
Destination Area
The range of cells receiving the copy (paste area)
Format
Used to emphasize certain entries and make the worksheet easier to read and understand
Select
When you select a cell you make it active
Range
a series of two or more adjacent cells in a column, row or rectangular group of cells
Cell Reference
a set of coordinates that identifies a specific cell (A6)
MAX Function
determines the highest number in the range.
MIN Function
determines the lowest number in the range
Drag and Drop
using the mouse to move or copy cells
