Excel Ch 2 Terms1Versión en línea Match the definition with the correct term. por Kerri Stegman 1 A formula in a cell that contains a reference back to itself a order of operations b circular reference c function d trace error 2 A prewritten formula that is built into Excel a average function b auto fill options c function d arguments 3 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 4 Can be assigned to a cell and will calculate a result a formula b function c circular reference d trace error 5 Contains the numerical value of zero a point mode b blank cell c trace error d arguments 6 Order in which arithmetic operators are calculated a fill handle b formula c order of operations d circular reference 7 Button that specifies how moved or pasted items should appear a function b fill handle c insert options d paste options 8 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 9 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 10 Select cells and create formulas with the mouse, rather than typing a cell reference a average function b row c arguments d point mode 11 values or cell references that a function uses to perform its calculation a average function b arguments c point mode d formula 12 Used to indicate the start of a formula or function a formula b equal sign c circular reference d rows 13 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 14 Displays the lowest value in a range a Max b Min c Lowest d Bottom 15 Displays the highest value in a range a Max b Min c Average d Highest 16 Used to check which cells are referenced in a formula a values version b formula version c range finder d formula version 17 A predefined set of colors, fonts, chart styles, cell styles, and fill effects a best fit b conditional formatting c values version d theme
Crear