Week 1 Quiz

Grading Summary
These are the automatically computed results of your exam. Grades for essay questions, and comments from your instructor, are in the "Details" section below. Question Type: Multiple Choice Grade Details - All Questions 1. Question : Date Taken: Time Spent: Points Received: 7/10/2013 57 min , 47 secs 26 / 30 (86.7%)

# Of Questions: 15

# Correct: 13

(TCO 1) An Input Area (as it applies to Excel 2010) is defined as______. a range of cells containing results based on the output area displays the name of a worksheet within a workbook a range of cells containing values for variables used in formulas displays the content of the active cell

Student Answer:

Instructor Explanation:

Textbook Chapter 1

Points Received: Comments:

2 of 2

2.

Question :

(TCO 1) In Excel 2010, a cell is best described by which of the following? Must have formulas entered into it Cannot be used for labels or headings Must have text entered into it Is the intersection of a column and a row

Student Answer:

Instructor Explanation:

Textbook Chapter 1

Points Received: Comments:

2 of 2

3.

Question :

(TCO 1) Which of the following best describes the AutoComplete function? Adds all the numbers in the row automatically Searches for and displays any other similar label in the current column as you begin to type Adds all the numbers in the columns automatically Is a number that represents a quantity and can be the basis of calculations

Student Answer:

Instructor Explanation:

Textbook Chapter 1

Points Received: Comments:

2 of 2

4.

Question :

(TCO 1) Why would you use cell references in formulas instead of constant values? You can easily include letters, numbers, and spaces It is easier to debug the errors You can change the input values without changing the formulas You can control the sequence in which Excel performs arithmetic operations

Student Answer:

Instructor Explanation:

Textbook Chapter 1