ISTM 210 Exam 2- Excel Questions with 100% Correct Answers

ISTM 210 Exam 2- Excel Questions with 100% Correct Answers what do all formulas begin with = what does #### mean the cell needs to be widened in order to fit characters active cell has green, dashed lines around it what is the shortcut for viewing formulas ctrl ~ first step in creating an effective worksheet understand what is required workbook whole thing worksheet individual pages example of cell range A4:A6 how to bring data into a worksheet data, get data how to hide a column right click, hide how to fill in remainder of cells right click bottom corner of the cell what is the shortcut for absolute reference ctrl f4 or $ SUM adds numbers together to get a result AVERAGE adds set of numbers and divides by how many numbers added MAX returns largest number in data set MIN returns smallest number in data set what are best practices making formulas as simple as