ISTM 210 Exam 2 Excel (phinney) Questions with 100% Correct Answers

ISTM 210 Exam 2 Excel (phinney) Questions with 100% Correct Answers Phinney's Fav formula - answerCONCATENATE CONCATENATE function - answerCONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - answerNOT case sensitive COUNT function - answerA function that determines how many cells in a range contain a number. Workbook - answerexcel file that stores all information, calculations, and analyses. Worksheet - answerA computerized spreadsheet in Excel. Cells - answerstore individual pieces of data/collections Cell Address - answerThe name of the cell is determined by the name of the row and the column intersecting, such as A8. Fill Feature - answerallows you to automatically populate cells in a worksheet by copying the contents of one cell to other contiguous cells Freeze Panes - answerallows user to lock rows and columns so they don't disappear. Format Painter - answerA feature that copies format attributes such as colors, borders, and fill effects from an object, text, or cell in order to apply the same formatting to another object, text, or cell. AVG - answeraverage, calculates the simple average of a set of numbers Absolute Reference - answercell reference that remains constant when a formula is pasted into a new cell. C$1, $C$1, $C1 Relative reference - answerchanges when reference is copied and pasted into other cells SUM function - answercalculates the total of values contained in two or more cells Function Wizard - answer1. allows you to enter or select the inputs for the function 2. provides a description of the function and each argument 3. lists the function result based on the inputs you enter COUNT - answercounts the number of cells in a range of cells that contain numbers MAX - answerreturns the largest v