Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Apply date format with day, month and year |
|
Definition
|
|
Term
| Apply currency format with 2 decimal places |
|
Definition
|
|
Term
| Display Format Cells dialog box |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Highlight all & adjacent cells in desired direction |
|
Definition
|
|
Term
| Display the Paste Special dialog box |
|
Definition
|
|
Term
| Apply percentage formal with no decimal places |
|
Definition
|
|
Term
| Switches to next workbook window when more than 1 workbook is open |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Display the Macro dialog box |
|
Definition
|
|
Term
| Minimizes workbook window |
|
Definition
|
|
Term
| Calculate active worksheet |
|
Definition
|
|
Term
|
Definition
|
|
Term
| Repeat the last worksheet action |
|
Definition
|
|
Term
| Lock cell selection in formula (must be in editing formula in cell when using) |
|
Definition
|
|
Term
| Return the month of a date. |
|
Definition
| equalsMONTH(cell_reference) *Can also use =YEAR, =DAY or =WEEKDAY |
|
|
Term
|
Definition
| equalsNOW() *Can also use =TODAY to return date only |
|
|
Term
| Round a number to a specified number of decimal places or digit positions. |
|
Definition
| equalsROUND (cell_reference,number_of_digits) |
|
|
Term
| Format desired text to “ALL CAPS” |
|
Definition
| equalsUPPER(cell_reference) |
|
|
Term
| Format desired text to “all lower case” |
|
Definition
| equalsLOWER(cell_reference) |
|
|
Term
| Format desired text to “Proper Case” |
|
Definition
| equalsPROPER(cell_reference) |
|
|
Term
| Return the largest number in a range |
|
Definition
|
|
Term
| Sum the numbers in a range |
|
Definition
|
|
Term
| Average the numbers in a range |
|
Definition
| equalsAVERAGE(data_range) |
|
|
Term
| Count the number of cells in a range that contain numbers. |
|
Definition
|
|
Term
| Extract specified characters from the middle of a text string. |
|
Definition
| equalsMID(cell_reference,start_number,number_of_steps) |
|
|
Term
| Extract specified number of characters from a text string, beginning from the left. |
|
Definition
| equalsLEFT(cell_reference,number_of_steps) |
|
|
Term
| Return the number of steps to a given character or text string. |
|
Definition
| equalsSEARCH(“what_to_find”,cell_reference) |
|
|
Term
| Compute the desired interval between 2 dates. |
|
Definition
| equalsDATEDIF(date1,date2,interval) |
|
|
Term
| Join several text strings into 1 text string. |
|
Definition
| equalsCONCATENATE(cell_reference1,"delimiter",cell_reference2) |
|
|
Term
| Look for a value in the leftmost column of a table and then return a value from the specified column from the same row. |
|
Definition
| equalsVLOOKUP(lookup_value, table_array, column_num, TRUE/FALSE) |
|
|
Term
| Return the value_if_error if the expression is an error. |
|
Definition
| equalsIFERROR( value, value_if_error ) |
|
|
Term
| Checks if a condition is met, and returns one value if true and another value is false. |
|
Definition
| equalsIF(logical_test_value,value_if_true,value_if_false) |
|
|
Term
| Calculate a sum from the values that meet a given condition. |
|
Definition
| equalsSUMIF(range,criteria) |
|
|
Term
| Count the number of cells in a range that match a given condition. |
|
Definition
| equalsCOUNTIF(range,criteria) |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| A formula or a function inside a formula cannot find the referenced data |
|
|
Term
|
Definition
| Text in the formula is not recognized |
|
|
Term
|
Definition
| A space was used in formulas that reference multiple ranges; a comma separates range references |
|
|
Term
|
Definition
| A formula has invalid numeric data for the type of operation |
|
|
Term
|
Definition
|
|
Term
|
Definition
| The wrong type of operand or function argument is used |
|
|
