http://www.assignmentclick.com/bis-155/bis-155-week-1-quiz-data-analysis-with-spreadsheets-with-lab

For more classes visit

http://www.assignmentclick.com

(TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)

A range of cells containing results based upon manipulation of the variables in the input 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

(TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)

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

(TCO 1) Which of the following best describes the AutoComplete function? (Points : 2)

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

(TCO 1) Why would you use cell references in formulas instead of constant values? (Points : 2)

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

(TCO 1) In Excel 2010, a column width ________. (Points : 2)

is adjustable so you can display more or less characters in a columnis not adjustable so keep the formulas as short as possible

always switches back to default

is best left unchanged unless you absolutely have to

(TCO 1) Which of the following best describes a “Range” in Excel 2010? (Points : 2)

Cannot be selected with the mouse

Are the numbers that fall between the smallest and largest in the formula

Is another word for the active worksheet

Refers to a group...