### Free Educational Resources

• > BIS 155 ALL QUIZZES WEEK 1 – 5
+

# BIS 155 ALL QUIZZES WEEK 1 – 5

(0)
Author: un quite
##### Description:

http://unquite.com/question-details/BIS-155-ALL-QUIZZES-WEEK-1-%E2%80%93-5/67

or email us at:

query@unquite.com

BIS 155 ALL QUIZZES WEEK 1 – 5

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? (Points: 2)

5. (TCO 2) The MEDIAN function would identify the ____. (Points: 2)

6. (TCO 2) The MAX function identifies the _____. (Points: 2)

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

8. (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)

9. (TCO 2) Arithmetic operations, cell references, and ____can be used in Excel formulas. (Points : 2)

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

12. (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year. (Points : 2)

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial