Question 1: Formulas can be written with cell references only? A. True B. False Question 2: Excel can correct a circular reference for you. A. True B. False Question 3: Cell contents must be replaced individually. As multiple cell cannot be replaced simultaneously. A. True B. False Question 4: Which approach will not allow for the entry or modification of a formula? A. Clicking in the Formula Bar B. Double-clicking in the formula cell C. Selecting a cell and typing a formula D. Scrolling to a formula at the bottom of a worksheet Question 5: When is the AutoFill Options button displayed? A. After the fill handle is selected but before dragging B. Immediately after the original formula is written C. Before the original formula is written D. After the formula has been copied to other cells Question 6: What is the first step when using AutoFill? A. Select the desired option from the AutoFill Options button. B. Select the cell to be copied. C. Drag the fill handle. D. Highlight the range where the cell will be pasted. Question 7: The formula =A6*H2 is entered in cell B5. How will it appear when copied to cell B6? A. =A6*H2 B. =B6*12 C. =A7*H3 D. =A5*H1 Question 8: The formula =A8/N14 is entered in cell D9. How will it appear when copied to cell G2? A. =D8/014 B. =A1/N7 C. =A8/N14 D. =D1/07