#### Details of this Paper

##### DEVRY BIS155 week 2 quiz

**Description**

solution

**Question**

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#36894 | Written in 18-Jul-2015

Price :*$21*