Devry BIS 155 Quiz 2 Latest

Description

Devry BIS 155 Quiz 2 Latest

Grade Details – All Questions

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

Student Answer: *.

$.

=.

/.

Instructor Explanation: Textbook Chapter 2

Points Received: 2 of 2

Comments:

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

Points Received: 2 of 2

Comments:

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

Student Answer:

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

Points Received: 2 of 2

Comments:

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

Student Answer:

Instructor Explanation:

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

Student Answer:

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

Student Answer

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

Student Answer:

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

Student Answer:

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

Student Answer:

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

Student Answer:

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.

Student Answer

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

Student Answer:

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

Student Answer

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

Student Answer:

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