# (TCO 2) In Excel, a relative cell reference: (Points : 2)

\$14.99

Question 1.1. (TCO 2) In Excel, a relative cell reference: (Points : 2)

Question 2.2. (TCO 2) Which of the following best describes a mixed cell reference? (Points : 2)

Question 3.3. (TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2)

TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points : 2)

Question 4.4. (TCO 2) Which of the following describes the SUM function? (Points : 2)

Question 5.5. (TCO 2) The _____ function returns a result based on a condition. (Points : 2)

(TCO 2) The MIN function would identify the _____. (Points : 2

Question 6.6. (TCO 2) Which of the following best describes the COUNT function? (Points : 2)

(TCO 2) The NOW function would perform which of the following? (Points : 2)

Question 7.7. (TCO 2) The NOW function would perform which of the following? (Points : 2)

Question 8.8. (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)

(TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2)

Question 9.9. (TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2)

(TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2)

Question 10.10. (TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2)

(TCO 2) The PMT function is best described by which of the following? (Points : 2)

Question 11.11. (TCO 2) The PMT function is best described by which of the following? (Points : 2)

Question 12.12. (TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks? (Points : 2)

(TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose. (Points : 2

(TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell. (Points : 2)

Question 13.13. (TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit. (Points : 2)

Question 14.14. (TCO 7) By default, a macro records cells as _____ references if they are selected while recording the macro. (Points : 2)

Question 15.15. (TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2)

 Additional Questions to Quiz 2   (TCO 2) In Excel, a function can be defined as a _____. (Points : 2)

(TCO 2) The rules for constructing a function can be referred to as the function's _____.

(TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____.

(TCO 2) If you enter an = and the first few letters of a function in the formula bar, Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.

(TCO 2) Which of the following best describes the HLOOKUP function?

(TCO 7) Which of the following file formats can store macros?

TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.