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;
20 Cards in this Set
- Front
- Back
Adjacent Range
|
A single rectangular block that includes a group of connected cells
|
|
Argument
|
Specifies the numbers, text, or cell references used in a function to perform a calcuation
|
|
Arithmetic Operator
|
A symbol such as +, -,*,or / which is used in a formula to perform arithmetic calcuations
|
|
Autocomplete
|
A feature that makes it easier to enter repetitive text. As you eneter text in a worksheet, you'll see text displayed that begins with the same letters from a previous entry in the same column
|
|
Autofill
|
A feature to copy the contents of selected cells by dragging the fill handle over adjacent cells rather than using copy and paste
|
|
Auto sum
|
To quickly add a column or row of values in Excel This icon also selects from common functions: Sum, Count, Average, Min, Max
|
|
Chart
|
Graph that provides a visual representation of workbook data
|
|
Comparison Operator
|
Symbol used to indicate the relationshipbetween two values (>,<, =
|
|
Excel Table
|
A range of data you can treatas a distinct object in a worksheet
|
|
Fill Handle
|
A small black squarein the lower right corner of a selected cell (or range ) that you drag to copy the contents of the selected cells into adjacent cells
|
|
Filter
|
Used to search for and displayspecific items, based on selection criteria
|
|
Formula View
|
View where cell formulas are displayed rather than the values returned by formulas
|
|
Legend
|
Used to identify the format of data used in a chart
|
|
Non adjacent range
|
Cell range comprised of two or more separate adjacent ranges
|
|
Operator
|
A mathematical symbol used to combine values and return a single value (comparison or arithmetic)
|
|
Order of Operations
|
The defined rules that Excel uses to calculate valuesby determining which operator will be applied first. PEDMAS is an acronym to remember this order:
Parentheses, exponents, division, multiplicatoons, addition and then subtraction |
|
Range
|
A group of worksheet cellswhich can be adjacent or non adjacent
|
|
Range Reference
|
Identification of a cell range, using the uppper left and lower rightcorners of the rectangleto select cells. Use a (:) with cell addresses to indicate a range
|
|
Sort
|
Rearrange items in A-Z or Z-A order
|
|
Turncate
|
To cut off or hidethe partof an entry that does not fitin a cell
|