Terms in this set (30)
The intersection of a row and column.
A vertical collection of cells. Usually labelled alphabetically A..Z, AA..AZ, etc
A horizontal collection of cells. Usually labelled numerically.
A rectangular collection of cells. Identified by naming diagonally opposite corner cells.
a unique identifier for a cell which is formed by combining the cell's column letter and row number. E.g. B12
A graphical representation of data.
A circular chart divided into triangular areas proportional to the percentages of the whole.
A chart with bars whose lengths are proportional to quantities.
A chart that uses points connected by a line to illustrate values in a worksheet.
A spreadsheet function that calculates or adds up the total of the cells in a range.
When copying a term in a formula that has ____ ______ cell referencing, the displacement has no effect on the resulting formula.
When copying a formula from one cell to another, Excel uses _____ ________which means that the same function will be used, but the letters or row numbers will be changed reelative to the destination location.
The active cell is the cell currently being edited. A border appears around this cell to highlight it and make it easy to locate.
An arrangement of cells in colums and rows used to organize, analyze, calculate, and report information, usually in numerical form, similar to a table.
The vertical and horizontal lines on a coordinate plane or graph.
A group of related information in a column or row of a worksheet that is plotted on a chart.
A list that identify the different data series
in a chart, usually by colour or marker symbol.
The portion of a chart that forms the background to the plotted data.
Text or numbers that provides additional information about a data marker.
A spreadsheet function that determines the largest value in the specified range, e.g. =max(A3:D4)
A spreadsheet function that determines the smallest value in the specified range, e.g. =min(A3:D4)
A spreadsheet function that determines the average value in the specified range, e.g. =average(A3:D4)
The portion of a chart that forms a background to the entire chart, including the titles, legend and plotted data
A condition that data must meet to be included in a selection.
Lines around the edge(s) of text, a page, a cell, or a table.
A numeric format that includes a currency symbol, e.g. $, and two decimal places.
To separate a wedge of a pie chart slightly from other wedges in a pie
An effect in which colors are gradually blended.
A chart option where data series are added on top of each other.
The area behind the contents of a cell, which may be coloured in a solid colour or a gradient.
YOU MIGHT ALSO LIKE...
Core Topic 1 Cell Biology | IB Biology Guide
Spreadsheet Vocab. Emily Quintana
Spreadsheet Terms 2012
OTHER SETS BY THIS CREATOR
IDT Networks #6 - Network Security
IDT Networks #5 - Practical Networking
IDT Networks #4 - Network Requirements
IDT Networks #3 - Network Layers
THIS SET IS OFTEN IN FOLDERS WITH...
ICAICT101A - Files and folders
ICAICT101A - Startup and Shutdown
ICAICT101A - The desktop environment
ICAICT101A - Printing