CIS 105 test 2 Arizona State University - Question and answers verified to pass

CIS 105 test 2 Arizona State University - Question and answers verified to pass CIS 105 test 2 3 types of information that can be entered into a cell - correct answer Texts, Numbers, and formulas A group of selected cells - correct answer Range, block of cells Creating a basic chart - correct answer Highlight range of cells for the data you want to use and create a chart for it in the insert tab. best way to calculate a total - correct answer =sum est way to calculate an average - correct answer = average Use absolute in formula - correct answer Want the value to remain the same when you plug it into a formula. Use relative in a formula - correct answer use when the value will change on the different cell/ range that you choose. widening columns - correct answer choose the top columns marked "a,b,c,d..." and widen. =if() - correct answer Used when you need to find an outcome given another number or factor, " =if(D7>60, "P", "z") =vlookup() - correc