Details of this Paper

DeVry Chicago BIS 155 Week 2 Quiz 2014

Description

solution


Question

Week 2 Quiz 1. Question: (TCO 2) In Excel, a relative cell reference;Student Answer: 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?;Student Answer: 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) =$E2-G$4 contains examples of _____ cell references.;Student Answer: absolute;mixed;relative;constant;Question 4. Question: (TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.;Student Answer: PRESENT;TODAY;CURRENT;SET;Question 5. Question: (TCO 2) The MEDIAN function would identify the ____.;Student Answer: lowest value in a range.;midpoint value in a range.;highest value in a range.;total number of cells in a range.;Question 6. Question: (TCO 2) Which of the following best describes the COUNT function?;Student Answer: 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) The _____ function can be used to find an answer located in a vertical table.;Student Answer: FIND;SEARCH;HLOOKUP;VLOOKUP;Question 8. Question: (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values.;Student Answer: lookup value;column index;lookup table;random;Question 9. Question: (TCO 2) Which of the following best describes the HLOOKUP function?;Student Answer: 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 _____.;Student Answer: 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) When calculating a PMT function, the PV is best described by which of the following?;Student Answer: It is a set of range names.;It is a word or a string of characters that represent one or more cells. It is the present value of the loan.;It is why you do not have to make the cell reference absolute in the formula. Question 12. Question: (TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.;Student Answer: theme;style;template;macro;Question 13. Question: (TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.;Student Answer: home;page layout;data;view;Question 14. Question: (TCO 7) Which of the following file formats can store macros?;Student Answer: xlsm;csv;xml;xlsx;Question 15. Question: (TCO 7) Users must click _____ Content to use the workbook and run the macros in the workbook.;Student Answer: Enable;Disable;Run;Delete

 

Paper#35178 | Written in 18-Jul-2015

Price : $22
SiteLock