The portion of a chart that forms a background to the entire chart, including the titles, legend and plotted data
When copying a term in a formula that has ____ ______ cell referencing, the displacement has no effect on the resulting formula.
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 numeric format that includes a currency symbol, e.g. $, and two decimal places.
A chart that uses points connected by a line to illustrate values in a worksheet.
Lines around the edge(s) of text, a page, a cell, or a table.
The portion of a chart that forms the background to the plotted data.
A spreadsheet function that determines the average value in the specified range, e.g. =average(A3:D4)
A graphical representation of data.
The intersection of a row and column.
A group of related information in a column or row of a worksheet that is plotted on a chart.
a unique identifier for a cell which is formed by combining the cell's column letter and row number. E.g. B12
A spreadsheet function that determines the smallest value in the specified range, e.g. =min(A3:D4)
A vertical collection of cells. Usually labelled alphabetically A..Z, AA..AZ, etc
The vertical and horizontal lines on a coordinate plane or graph.
A spreadsheet function that determines the largest value in the specified range, e.g. =max(A3:D4)
An arrangement of cells in colums and rows used to organize, analyze, calculate, and report information, usually in numerical form, similar to a table.
A rectangular collection of cells. Identified by naming diagonally opposite corner cells.
The area behind the contents of a cell, which may be coloured in a solid colour or a gradient.
To separate a wedge of a pie chart slightly from other wedges in a pie
A list that identify the different data series in a chart, usually by colour or marker symbol.
An effect in which colors are gradually blended.
A spreadsheet function that calculates or adds up the total of the cells in a range.
A chart option where data series are added on top of each other.
A horizontal collection of cells. Usually labelled numerically.
Text or numbers that provides additional information about a data marker.
The active cell is the cell currently being edited. A border appears around this cell to highlight it and make it easy to locate.
A condition that data must meet to be included in a selection.
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.
What operating systems can someone use Excel on?