Fluency with Information Technology Chapter 14

1. In spreadsheets, names

a. are used for cells

b. are used for cell ranges

C. can contain an underscore

d. all of the above

a are used for cells

2. All of the following are basic spreadsheet principles except

a. logical form

b. clean layout

C. no text

d. clear and easy to use entries

c no text

3. "Explain everything" in a spreadsheet means

a. you should easily be able to tell what every cell means

b. each cell and cell range should be labeled

c. each formula should be explained with a label

d. all of the above

a you should easily be able to tell what every cell means

4. Conditional formatting

a. allows you to display information in more than one way

b. allows you to write more than one formula for a cell

c. automatically finds and flags errors in formulas and formatting

d. all of the above

a allows you to display information in more than one way

5. To get the first characters in a cell you should use the

a. BEGIN ( ) function

b. START ( ) function

C. LEFT () function

D. GET ( ) function

c LEFT () function

6. Conditional formatting can change the

a. text color

b. text format

C. cell color

d. more than one of the above

d more than one of the above

7. Defining names for a spreadsheet allows you to refer to cells

a. by location

b. symbolically

c. conditionally

d. Alphabetically

b symbolically

8. If you saw regHours in a spreadsheet formula you'd know it's a

a. mistake

b. named reference

C. constant

d. Function

b named reference

9. Spreadsheets recalculate

a. whenever a cell is changed

b. only when saved

c. only when opened

d. once a minute

a whenever a cell is changed

10. AutoFiltering can only be used on

a. named ranges

b. tables that have column headings

c. cells containing formulas

d. rows with unique entries

b tables that have column headings

11. AutoFiltering allows

a. sorting rows

b. displaying rows with a limited number of values

c. displaying rows that match specific criteria

d. all of the above

d all of the above

12. Whenever a value in a spreadsheet is changed

a. everything except for hidden columns are recalculated

b. everything is recalculated

c. only conditional formatting is recalculated

b everything is recalculated

1. Spreadsheets are great for playing____. that is, they are useful for putting together

various possible scenarios.

"what if?"

2. ___ are a good way to explain a spreadsheet formula.

Comments

3. ____allows for the application of interpretation to the data in a spreadsheet.

conditional formatting

4. ___information that is not currently needed is a good way to make a spreadsheet

clear and easy to use.

Hiding

5. A single cell or a related rectangular group of cells is called a(n)____

Range

6. ___allow for programmatic manipulation and analysis of data in spreadsheets.

formulas

7. When you ____ for a spreadsheet, you create a symbolic reference for a range of cells.

name a range

8. A(n)______is a named alternative to a spreadsheet based on different inputs.

scenario

9. The ____ is the interface for managing scenarios.

scenario manager

10. ____ allows the selection of certain spreadsheet rows based on specified criteria.

filtering