Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel Spreadsheet Vocabulary (Active Cell- a selected worksheet that is…
Excel Spreadsheet Vocabulary
Active Cell- a selected worksheet that is ready for data entry
Alignment- the position of data within a cell
Argument- value, cell reference, range, or text that acts as an operand in a function formula
Ascending- sort order arranging text or numbers from A to Z from smallest to largest, or from earliest to latest
Autosum- a function that automatically adds the values in the cells directly above or to the left of the active cell
AVERAGE- return the average of its arguments
Cell- the space formed by the intersection of a row and a column, the basic unit of a worksheet
Cell Reference- A unique identifier for a cell which is formed by combining the cells column letter and a row number
Chart/Graph- a graphic representation of values and their relationships pie , line, column, bar, scattered
Column- a vertical group of cells in a worksheet identified by a letter
Column Chart- a chart that uses bars of varying height to illustrate values in a worksheet
COUNT- returns the number of cells in a range that contains nnumbers
Descending- sort order arranging text or numbers form Z to A largest to smallest or latest to earliest
Fill- to copy a cells content and formatting into an adjacent cell or range
Format- arranging the shape size type and general makeup of a cell or group of cells
Formula- an equation that calculates a new value using values currently on a worksheet
Freeze- keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
Function- a prewritten formula that makes it easy to perform common calculations
Label- alphanumeric text that will not be used in calculations
Line chart- a chart that uses points connected by a line to illustrate values in a worksheet
MAX- returns the largest sum value in a set of values
MIN- returns the smallest value in a set of values
Mixed Cell Reference- a cell reference that contains both relative and absolute references
Operand- a number or cell reference used in a formula
Operator- a symbol that indicates what mathematical operation to perform on the operands plus minus multiply divide
Order of Operation- the mathematical rules used for calculating the value of a formula
Pie Chart- a chart that shows the relationship of a part to a whole
Range- selsected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right
Relative Cell Reference- cell reference that adjusts to a new location when copied or moved
Row- a horizontal group of cells in a worksheet identified by numbers
Sort- to arrange a list of words or numbers in ascending or descending order
Spreadsheet- a grid of rows and columns containing numbers text and formulas used to perform calculations
SUM- adds all the numbers in a range of cells
Value- numeric characters that can be used in a calculation
Workbook- a collection of related worksheets corner separated by a colon
Worksheet- the workspace made up of columns and rows where data is entered to create an electronic spreadsheet