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
A single rectangular block that includes a group of connected cells.
|
ADJACENT RANGE
|
|
Specifies the numbers, text, or cell references used in a function to perform a calculation.
|
ARGUMENT
|
|
A symbol such as +, -, *, or /, which is used in a formula to perform arithmetic calculations.
|
ARITHMETIC OPERATORS
|
|
A feature that makes it easier to enter repetitive text. As you enter text in a worksheet, you'll see text displayed that begins with the same letters from a previous entry in the same column.
|
AUTOCOMPLETE
|
|
A feature to copy the contents of selected cells by dragging the fill handle over adjacent cells rather than using copy and paste.
|
AUTOFILL
|
|
To quickly add a column or row of values in Excel. This icon also selects from common functions: Sum, Count, Average, Min, or Max.
|
AUTOSUM
|
|
Graph that provides a visual representation of workbook data.
|
CHART
|
|
Symbol used to indicate the relationship between two values (>, <, =)
|
COMPARISON OPERATOR
|
|
A range of data you can treat as a district object in a worksheet.
|
EXCEL TABLE
|
|
A small black square in the lower-right corner of a selected cell ( or cell range) that you drag to copy the contents of the selected cells into adjacent cells.
|
FILL HANDLE
|
|
Used to search for and display only spoecific items, based on selection criteria.
|
FILTER
|
|
View where all cell formulas are displayed, rather than the values returned by formulas
|
FORMULA VIEW
|
|
Used to identify the format of data used in a chart
|
LEGEND
|
|
Cell range comprised of two or more separate adjacent ranges.
|
Non-Adjacent Range
|
|
A mathematical symbol used to combine values and return a single value. (Comparison or arithmetic)
|
OPERATOR
|
|
The defined rules Excel uses to calculate values by determining which operator will be applied first. PEDMAS is an acronym to remember this order: Parentheses, exponents, division, multiplication, addition, and then subtraction.
|
Order of operations
|
|
A group of worksheet cells which can be adjacent or non-adjacent
|
RANGE
|
|
Identification of a cell range, using the upper left and lower right corners of the rectangle to select cells. Use a colon (:) with cell addresses to indicate a range.
|
RANGE REFERENCE
|
|
Rearrange items in A-Z or Z-A order.
|
SORT
|
|
To cut off or hide the part of an entry that does not fit in a cell
|
TRUNCATE
|