BIS 155 Advanced PC Applications Complete Quizzes Week 1 to 5
http://homeworktimes.com/downloads/bis-155-advanced-pc-applications-complete-quizzes-week-1-5/
Week 1 Quiz
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 Quiz
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...