ISTM 210 Exam 2 Excel (phinney)Exam 2024 Questions & Answers 100% Updated!

Phinney's Fav formula - ANSWERSCONCATENATE CONCATENATE function - ANSWERSCONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - ANSWERSNOT case sensitive COUNT function - ANSWERSA function that determines how many cells in a range contain a number. Workbook - ANSWERSexcel file that stores all information, calculations, and analyses. Worksheet - ANSWERSA computerized spreadsheet in Excel. Cells - ANSWERSstore individual pieces of data/collections Cell Address - ANSWERSThe name of the cell is determined by the name of the row and the column intersecting, such as A8. Fill Feature - ANSWERSallows you to automatically populate cells in a worksheet by copying the contents of one cell to other contiguous cells Freeze Panes - ANSWERSallows user to lock rows and columns so they don't disappear. Format Painter - ANSWERSA 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 - ANSWERSaverage, calculates the simple average of a set of numbers Absolute Reference - ANSWERScell reference that remains constant when a formula is pasted into a new cell. C$1, $C$1, $C1 Relative reference - ANSWERSchanges when reference is copied and pasted into other cells SUM function - ANSWERScalculates the total of values contained in two or more cells