#### Description of this paper

##### DEVRY BIS155 week 2 quiz-In Excel, a relative cell reference

Description

solution

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) In Excel, a function can be defined as a _____.;predefined formula that performs a calculation;cell reference or a value;list of values and defined names as you enter data into a spreadsheet;set of rules that govern the structure and components for a formula;Question 3. Question;(TCO 2) The rules for constructing a function can be referred to as the function's _____.;synthesis;synergy;synchronization;syntax;Question 4. Question;(TCO 2) Which of the following describes the SUM function?;Identifies the midpoint value in a set of values.;Calculates the total of values contained in two or more cells.;Calculates the arithmetic mean or average of values in a range.;Displays the lowest value in a range.;Question 5. Question;(TCO 2) The _____ function returns a result based on a condition.;Student Answer: MAX;TODAY;FIND;IF;Question 6. Question;(TCO 2) Which of the following best describes the COUNT function?;Tallies the number of cells in a range that are not empty.;Tallies the number of blank cells in a range.;Displays the current date.;Tallies the number of cells in a range that contain values.;Question 7. Question;(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 _____.;logical test;lookup value;breakpoint;table array action;Question 8. Question;(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 _____.;Syntax Helper;Formula AutoComplete;Formula Wizard;Question 9. Question;(TCO 2) Which of the following best describes the HLOOKUP function?;The periodic interest rate, such as a monthly interest rate.;Calculates the periodic payment for a loan with a fixed interest rate and fixed term.;Looks up a value in a lookup table where the first column contains the values to compare with the lookup value.;Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value.;Question 10. Question;(TCO 2) One benefit of using range names in formulas is that _____.;it directly or indirectly refers to the cell containing the formula;it contains both an absolute and a relative cell reference;it identifies the present value of the loan;if you copy the formula, you do not have to make the cell reference absolute;Question 11. Question;(TCO 2) The PMT function is best described 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 the present value of a loan.;It calculates the periodic payment for a loan with a fixed interest rate and a fixed term.;Question 12. Question;(TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks?;Macros;Templates;Themes;INCORRECT Background;Question 13. Question;(TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit.;format;hide;lock;unlock;Question 14. Question;(TCO 7) Which of the following file formats can store macros?;xlsm;csv;xml;xlsx;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

Paper#30098 | Written in 18-Jul-2015

Price : \$36