Quiz 4

A range of cells that shows how changing certain values in your formulas affects the results of those formulas. a) Data table b) Table Array c) Validation List

a) Data Table

A method to find a specific value for a cell by adjusting the value of one other cell. With this, you can work backward from the desired outcome to find the number necessary to achieve your goal. a) Goal Seek b) VLOOKUP c) HLOOKUP

a) Goal Seek

The location within which a name is recognized without qualification. a) Scope b) Range c) Defined Name

a) Scope

The command that displays arrows to indicate what cells affect the value of the cell that is selected is: a) Trace precedencts b) Trace dependents c) Error Checking

a) Trace Precedents

A group of Excel functions that look up a value in a defined range of cells located in another part of the workbook to find a corresponding value is referred to as: a) Tabs b) Lookup functions c) Logical function

b) lookup functions

An Excel function that looks up values that are displayed vertically in a column is the: a) HLOOKUP function b) VLOOKUP c) AutoSum

b)VLOOKUP

Cells that contain formulas that refer to other cells are: a) Precedent Cells b) Tracers c) Dependent Cells

c) Dependent Cells

Cells that are referred to by a formula in another cell are: a) Dependent Cells b) Tracers c) Precedent Cells

c) Precedent Cells

A list of values that are acceptable for a group of cells is a: a) Data List b) Information List c) Validation List

c) Validation List

Tracer arrows are red if a cell contains: a) a green triangle b) a formula c) an error value

c) an error value