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;
18 Cards in this Set
- Front
- Back
|
Define spreadsheet |
A grid of cells or electronic documents in which data is arranged in rows and columns |
|
|
Define row |
A series of data banks lid out in a horizontal fashion in a table or spreadsheet |
|
|
Define column |
A vertical series of cells in a chart, table or speadsheet |
|
|
Define cell |
The intersection between a row and a column on a spreadsheet |
|
|
Define cell address |
a combination of a letter and a number that specifies the column and row in which a cell is located on a spreadsheet |
|
|
Define label |
a heading used to identify a column of data |
|
|
Define formula |
Performs calculations using numbers, address of cells and mathematical operators |
|
|
Define function |
A predefined calculation used to perform common tasks |
|
|
Define worksheet |
A single spreadsheet that contains cells organized by rows and columns |
|
|
Define template |
A spreadsheet in which all the cells have been defined but no data has ye been entered |
|
|
Define range |
a group of selected cells which can be next to one another or non-adjacent. Ranges are identified by cell references |
|
|
Define title |
Most often refers to a text entry such as a heading used to identify a column of data |
|
|
What is the purpose of COUNTA? |
Counts the numbers of cells in a range that are not empty |
|
|
What is the purpose of =DATE(year,month,day) |
Returns the number that represents the data |
|
|
What is the purpose of COUNT? |
Counts the number of cells in a range that contain numbers |
|
|
What is the purpose of VLOOKUP? |
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order |
|
|
What is the purpose of =RANK(number, ref, order) |
Returns the rank of a number in a list of numbers: its size relative to other values in the list |
|
|
Name the two types of cell references |
Relative and absolute |
