The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (negation), multiplication, division, percentage, and exponentiation in an Excel formula. The values that an Excel function uses to perform calculations or operations. The area on the PivotTable Field List task pane used to place fields in different positions on the PivotTable. The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.Ī command that enables you to display data in another area of the worksheet and to use either or conditions.Ī logical function that evaluates more than one argument and returns true only if all of the arguments are true, and returns false if any of the arguments are false.
dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers. The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S.
GO Excel Volume 1 Glossary GO Excel Volume 1 Glossary # A B C D E F G H I J K L M N O P Q R S T U V W X Y ZĪn error code that means you cannot divide by zero.Īn error code that means the value needed for a formula is not available.Īn error code that means Excel does not recognize a name used in a formula usually the function name is or range name is misspelled.Īn error code that means there are no common cells between two ranges in a formula.Īn error code that means an unacceptable argument may have been used in a function.Īn error code that means the cell reference cannot be located.Īn error code that means a formula refers to a cell that contains text rather than numeric values or a formula.Ī cell reference that refers to cells by their fixed position in a worksheet an absolute cell reference remains the same when the formula is copied.