Bis 155 All Quizzes Week 1 - 5

Submitted by: Submitted by

Views: 10

Words: 1480

Pages: 6

Category: Other Topics

Date Submitted: 11/19/2015 09:00 PM

Report This Essay

BIS 155 All Quizzes Week 1 - 5

Purchase here

http://devrycourse.com/bis-155-all-quizzes-week-1-5

Product Description

Week 1

1. (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)? (Points : 2)

2. (TCO 1) Which of the following best describes a cell address? (Points : 2)

3. (TCO 1) If you wanted to insert the current date into an active cell, which of the following would you use? (Points : 2)

4. (TCO 1) In Excel a Formula is _______. (Points : 2)

5. (TCO 1) Which of the following describes the Auto Fill in Excel 2010? (Points : 2)

6. (TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)

7. (TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are ________________. (Points : 2)

8. (TCO1) In Excel, a border ________. (Points : 2)

9. (TCO 3) A data series is a group of related ____________. (Points : 2)

10. (TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole. (Points : 2)

11. (TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)

12. (TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a: (Points : 2)

13. (TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a: (Points : 2)

14. (TCO 3) Which of the following best describes the X Y (scatter) chart? (Points : 2)

15. (TCO 3) Which of the following best describes a trendline? (Points : 2)

Week 2

1. (TCO 2) An absolute cell reference: (Points : 2)

2. (TCO 2) Which of the following best describes a circular reference? (Points: 2)

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

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