Question 1. � Question : � (TCO 2) In Excel, a relative cell reference indicates a cell’s specific location and the reference does not change when you copy the formula. contains both an absolute and a relative cell reference. indicates a cell’s relative location from the cell containing the formula; the reference changes when you copy the formula. occurs when a formula directly or indirectly refers to the cell containing the formula. Question 2. � Question : � (TCO 2) Which of the following best describes a mixed cell reference? Occurs when a formula directly or indirectly refers to the cell containing the formula Causes a potential error Contains absolute or relative cell references, but not both Contains both an absolute and a relative cell reference Question 3. � Question : � (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. abstract relative mixed absolute Question 4. � Question : � (TCO 2) In Excel, an argument would be best described by which of the following statements? Calculates the total of values contained in two or more cells Is an input, such as a cell reference or a value needed to complete a function Is a small pop-up description that displays the results of the cell Question 5. � Question : � (TCO 2) Which of the following describes the AVERAGE function? Calculates the arithmetic mean of values in a range Identifies the midpoint value in a set of values Identifies the highest value in a range Displays the lowest value in a range Question 6. � Question : � (TCO 2) The MIN function would identify the _____. highest value in a range Tallies of the number of blank cells in a range lowest value in a range midpoint value in a range Question 7. � Question : � (TCO 2) The NOW function would perform which of the following? Contains another function embedded inside one or more of its arguments Evaluates a condition and returns one value if the condition is true and a different value if the condition is false Evaluates true or false Displays the current date and time Question 8. � Question : � (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. lookup value column index lookup table random Question 9. � Question : � (TCO 2) Arithmetic operations, cell references, and _____ can be used in Excel formulas. constants macros programs procedures Question 10. Question : � (TCO 2) To simplify entering ranges in formulas, you can use _____. range names a cell’s relative location both an absolute and a relative cell reference a cell’s specific location Question 11. Question : � (TCO 2) When calculating a PMT function, the RATE would be described best by which of the following? It is the periodic interest rate, such as a monthly interest rate. It is the total number of payment periods. It is a word or a string of characters that represent one or more cells. It is the present value of the loan. Question 12. Question : � (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year. template macro web query function Question 13. Question : � (TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell. home page layout data view Question 14. Question : � (TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do. begin stop copy paste Question 15. Question : � (TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette. View Data Insert Developer
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer