# Devry BIS 155 Quiz 2 Latest

\$16

## Devry BIS 155 Quiz 2 Latest

Question 1. Question : (TCO 2) A formula in Excel begins with a(n):

\$.

=.

/.

Instructor Explanation: Textbook Chapter 2

Question 2. Question : (TCO 2) In Excel, a function can be defined as a _____.

Student Answer: 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

Instructor Explanation: Textbook Chapter 2

Question 3. Question : (TCO 2) =\$E2-G\$4 contains examples of _____ cell references.

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

Student Answer: Calculates the total of values contained in two or more cells.

Displays a list of functions and defined names as you enter a function.

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.

Instructor Explanation: Textbook Chapter 2

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

Instructor Explanation:

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

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

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 _____.

Question 9. Question : (TCO 2) Which of the following best describes the HLOOKUP function?

Question 10. Question : (TCO 2) To simplify entering ranges in formulas, you can use _____.

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

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.

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

Question 14. Question : (TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.

Question 15. Question : (TCO 7) Users must click _____ Content to use the workbook and run the macros in the workbook.

DeVry Courses helps in providing the best essay writing service. If you need 100% original papers for Devry BIS 155 Quiz 2 Latest, then contact us through call or live chat.

Devry BIS 155 Quiz 2 Latest