Search
Browse
Create
Log in
Sign up
Log in
Sign up
Spreadsheets
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (30)
Cell
The intersection of a row and column.
Column
A vertical collection of cells. Usually labelled alphabetically A..Z, AA..AZ, etc
Row
A horizontal collection of cells. Usually labelled numerically.
Range
A rectangular collection of cells. Identified by naming diagonally opposite corner cells.
Cell Reference
a unique identifier for a cell which is formed by combining the cell's column letter and row number. E.g. B12
Chart
A graphical representation of data.
Pie chart
A circular chart divided into triangular areas proportional to the percentages of the whole.
Bar chart
A chart with bars whose lengths are proportional to quantities.
Line chart
A chart that uses points connected by a line to illustrate values in a worksheet.
Sum
A spreadsheet function that calculates or adds up the total of the cells in a range.
Absolute addressing
When copying a term in a formula that has ____ ______ cell referencing, the displacement has no effect on the resulting formula.
Relative addressing
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.
Active cells
The active cell is the cell currently being edited. A border appears around this cell to highlight it and make it easy to locate.
Spreadsheets
An arrangement of cells in colums and rows used to organize, analyze, calculate, and report information, usually in numerical form, similar to a table.
Axis
The vertical and horizontal lines on a coordinate plane or graph.
Data Series
A group of related information in a column or row of a worksheet that is plotted on a chart.
Legend
A list that identify the different data series
in a chart, usually by colour or marker symbol.
Wall Area
The portion of a chart that forms the background to the plotted data.
Data Label
Text or numbers that provides additional information about a data marker.
max
A spreadsheet function that determines the largest value in the specified range, e.g. =max(A3:D4)
min
A spreadsheet function that determines the smallest value in the specified range, e.g. =min(A3:D4)
average
A spreadsheet function that determines the average value in the specified range, e.g. =average(A3:D4)
Chart area
The portion of a chart that forms a background to the entire chart, including the titles, legend and plotted data
Filter
A condition that data must meet to be included in a selection.
Borders
Lines around the edge(s) of text, a page, a cell, or a table.
Currency
A numeric format that includes a currency symbol, e.g. $, and two decimal places.
Explode
To separate a wedge of a pie chart slightly from other wedges in a pie
Gradient
An effect in which colors are gradually blended.
Stacked
A chart option where data series are added on top of each other.
Cell Background
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
ibbioteacher
$6.99
STUDY GUIDE
CIS: Excel
53 Terms
LYDIABICKHAM
Spreadsheet Vocab. Emily Quintana
39 Terms
emilycupcake100
Spreadsheet Terms 2012
40 Terms
harrison_da
OTHER SETS BY THIS CREATOR
IDT Networks #6 - Network Security
31 Terms
murrayg
TEACHER
IDT Networks #5 - Practical Networking
22 Terms
murrayg
TEACHER
IDT Networks #4 - Network Requirements
11 Terms
murrayg
TEACHER
IDT Networks #3 - Network Layers
59 Terms
murrayg
TEACHER
THIS SET IS OFTEN IN FOLDERS WITH...
ICAICT101A - Files and folders
24 Terms
murrayg
TEACHER
ICAICT101A - Startup and Shutdown
26 Terms
murrayg
TEACHER
ICAICT101A - The desktop environment
12 Terms
murrayg
TEACHER
ICAICT101A - Printing
13 Terms
murrayg
TEACHER
;