List and LookUp Function Test

Master spreadsheet functions and features! Practice identifying VLOOKUP, SUM, cell references, and more.

A function that is used for two-column vectors. Days360 If Statements LookUp A function that is used to assist in organizing information. List NOW Table Which function will automatically add up a range of cells? Average AutoSum Freeze Pane A function that is used when there are more than two columns in a table. VLookUp LookUp List A list that limits data entry to specific choices programmed into the function. Non-Validated Validated Graph A list that allows additional entries other than those provided in the drop-down menu. CountA Validated Non-Validated Used to compare a cell value to an array of cells and return a value that matches the location of the value in the array. NOW If Statements LookUp Function Which function should be used to total the number of boxes sold? Average SUM MAX A cell reference always states the _ letter first and then the _ number. Column, Row Row, Column Cell, Equal Sign All formulas begin with which symbol first? ? / = The symbols: +, *, -, + are known as _? Mathematical Operators Functions Signs Mary wishes to arrange her family names in alphabetical order. Which type of sort will she use? Sort Ascend Sort Descend Range Which symbol indicates that a column is too small for the data? +++ ### @@@ Using the "Fill Series" method of copying makes data entry faster and more efficient. True False Justin wishes to key his column heading on two lines. Which procedure should he follow? Key the heading on two spreadsheet rows Use the "wrap text" alignment feature Neither a or b Which cell reference uses an absolute cell reference? $A$2 A2 A2$ Which formula uses relative cell reference? B%4 B4 $B$4 If the tax rate is located in cell A5, and the user wishes to use the tax rate in a formula that will be filled down, they should use which type of reference for this cell? Relative Absolute Range The > symbol is known as: Greater Than Less Than Equal To The < symbol is known as: Greater Than Less Than Equal To