Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
|
Adjacent/contiguous and non-adjacent/non-contiguous
|
Cells rows or columns which share a common border
|
|
|
Axis (X/Y)
|
x-axis is horizontal y-axis is vertical – often used to show value (y) over time (x)
|
|
|
Calculations
|
Mathematical signs such as + - * /
|
|
|
Cell references (absolute and relative)
|
Contents of cell does not change value when moved (absolute)
|
|
|
Chart/Graph
|
Graphical view of data in a spreadsheet
|
|
|
Columns/Rows
|
Columns are vertical and rows are horizontal
|
|
|
Control/Shift
|
Control highlights one cell at a time shift highlights a contiguous range
|
|
|
Currency/Percentage
|
Formatting currency could include using dollar and cent signs as well as decimal points and commas
|
|
|
Date/Time
|
Formatting date/time could include using / - abbreviations full names years and time examples
|
|
|
Excel
|
Microsoft Office program for spreadsheets
|
|
|
Filtering
|
Taking out values that do not meet parameters of test
|
|
|
Formulas
|
Start with = sign and include average min max if sum count
|
|
|
Gridlines
|
Lines which break down range into smaller parts
|
|
|
Hyperlinks
|
Can be included in spreadsheets
|
|
|
Import/export of data
|
Import data into spreadsheet (often by data logger) export data out of spreadsheet (often into a database)
|
|
|
Label/Legend
|
Label is text placed in a cell – Legend is a label placed in a chart/graph
|
|
|
Macro
|
A series of keyboard strokes or mouse moves/clicks that are automated
|
|
|
Range/Marquee select
|
Range is the series of cells selected – Marquee select is the process of selecting the cells
|
|
|
Replicating
|
The process of being able to reproduce results again that gives the same result
|
|
|
Sorting
|
Changing the order of a row or column alphabetically or numerically (A-Z low to high)
|
|
|
Text
|
Non-numerical and non-character input
|
