1) The most obvious way to select a cell in a worksheet is to click it with the A scroll arrow B tab key C mouse D. vertical scroll bar 2) When you select a cell that contains a formula, the cell displays the A value B text C formula D. calculation 3) The button automatically merges the selected cells and then centers the data from the first cell across the merged area. A Quick Analysis B. Merge & Center C Center D. Mini toolbar 4) refers to how text and numbers are positioned with the cell both horizontally and vertically. A Centering B. Alignment C. Formatting D. Placement 5) Excel will update the relative references to reflect a new cell position in the workbook when a cell is copied. True False 6) The MAX (maximum) statistical function provides the largest value in a range of values. True False 7) #DIVO is an example of a worksheet that can display in a cell. A cell reference B. error C. status D. value 8) An example of the AVERAGE function is A AVERAGE(B3:D3)