Excel Ch 2 Terms1Versión en línea Match the definition with the correct term. por Kerri Stegman 1 Button that lists formatting options following an insertion of cells, rows, or columns a insert options b paste options c arguments d auto fill options 2 A formula in a cell that contains a reference back to itself a order of operations b circular reference c function d trace error 3 A prewritten formula that is built into Excel a average function b auto fill options c function d arguments 4 Button that gives options for how to fill cells following a fill operation a order of operations b fill handle c paste options d auto fill options 5 Can be assigned to a cell and will calculate a result a formula b function c circular reference d trace error 6 Contains the numerical value of zero a point mode b blank cell c trace error d arguments 7 Order in which arithmetic operators are calculated a fill handle b formula c order of operations d circular reference 8 Button that specifies how moved or pasted items should appear a function b fill handle c insert options d paste options 9 Small rectangle in lower-right corner of a cell that is used to copy formulas a fill handle b blank cell c auto fill options d rows 10 Sums numbers in a specified range and then divides by the number of values a formula b average function c insert options d equal sign 11 Select cells and create formulas with the mouse, rather than typing a cell reference a average function b row c arguments d point mode 12 The values that are used with a function a average function b arguments c point mode d formula 13 Button that lists error-checking options following the assignment of an invalid formula to a cell a blank cell b fill handle c trace error d function 14 Typically contain items analogous to items in a list a rows b point mode c blank cell d order of operations 15 Used to indicate the start of a formula or function a formula b equal sign c circular reference d rows 16 Occurs when Excel does not understand a cell reference used in a formula a invalid reference b circular reference c blank cell d trace error
Crear