Fluency with Information Technology Chapter 13

1. Text too wide to fit into a cell is truncated.

a. true

b. false

c. not enough information

b False

2. Cells in a spreadsheet are 10 characters wide.

a. true

b. false

c. not enough information

b False

3. Relative cell references change as associated values change.

a. true

b. false

c. not enough information

a True

4. Copy/Paste will duplicate a formula, but it won't utilize relative and absolute cell references.

a. true

b. false

c. not enough information

b False

5. The small box or handle in a selected cell's lower-right corner is used to move the contents of a cell.

a. true

b. false

c. not enough information

b False

6. A cell reference cannot contain a relative and an absolute reference at the same time.

a. true

b. false

c. not enough information

b False

7. Column references in cell ranges must be typed using uppercase.

a. true

b. false

c. not enough information

b False

8. To change a relative cell reference to an absolute reference, you should use the ampersand (&).

a. true

b. false

c. not enough information

b False

9. Spreadsheet columns can be hidden but rows cannot.

a. true

b. false

c. not enough information

b False

10. A spreadsheet can import any kind of data.

a. true

b. false

c. not enough information

b False

1. Functions and column letters are___ in formulas.

a. case sensitive

b. not case sensitive

c. case sensitive if you put a $ in the formula

d. not case sensitive if you put a $ in the formula

b not case sensitive

2. How many different ways are there to combine absolute and relative references to a single cell?

a. 4

b. 1

С. 6

d. 2

a 4

3. Respectively, rows and columns are designated with

a. numbers, letters

b. letters, numbers

c. numbers, numbers

d. names, numbers

a numbers, letters

4. Which of the following is a valid range of cells?

a. D1: D4

b. C3:05

C. A1:E1

d. all of the above

d all of the above

5. Which of the following is not a valid range of cells?

a. A1>A5

b. C3-08

С. ЗВ: 6B

d. all of the above

d all of the above

6. How many cells are in the range B2: D7 ?

a. 6

b. 12

c. 18

d. unknown

c 18

7. Spreadsheet formulas start with

a. +

b. =

C. @

d. !

b =

8. What function would you use to change the color of certain cells based on the value stored inside of them?

a. sort

b. text formatting

c. cell formatting

d. conditional formatting

d conditional formatting

9. Which of the following is a completely relative cell reference?

a. J4

b. $J4

C. J$4

d. $J$ 4

a J4

10. If the formula =$B$3 * 062 is copied from cell B4 to B5, the result will be

a. =$B$4 * .062

b. =$B$3 * .062

C. =B5 * .062

d. an error

b =$B$3 * .062

11. If $G5 appeared in a formula, you'd know

a. the G is absolute and the 5 is relative

b. the is relative and the 5 is absolute

c. both are relative

d. both are absolute

a the G is absolute and the 5 is relative

1. If a cell does not start with an equal sign then the cell contains____.

Data

2. Cell entries are ____ ; that is, the computer will not consider any of their constituent parts.

atomic or monolithic

3. The ____statement finds the maximum value in column J for rows 3-7 (assume the cells are filled with numerical values).

MAX(J3:J7),

4. The _____statement finds the minimum value in row 8 for columns A-E (assume the cells are filled with numerical values).

MIN(A8:E8)

5. A rectangular group of one or more cells is called a(n)____.

Range

6. The small box in the lower-right corner of a selected cell (or range of cells) is called the ___

Fill Handle

7. A(n) ____cell reference automatically transforms a formula when it is pasted or filled.

Relative

8. A(n) ___ cell reference retains a reference to a fixed position when it is pasted or filled.

Absolute

9. Data imported into a spreadsheet should generally be ____

tab-delimited ASCII

10. Using _____automatically fills and increments values.

Seris Fill

11. _____ are formulas built into a spreadsheet to make it easier to create calculations.

Function

12. Use the ____ function to find the average of a range of cells.

AVERAGE

13. Use the____ function to find the largest of the numbers in a range of cells.

MAX

14. A_____ is a range of cells filled with increments of a certain type of data.

Seris Fill

15. The PMT ( ) function returns a (an)_____ because it's money you owe.

Negative

16. To change the formatting on a chart you should ______on that item to access the appropriate menus.

Right Click

17. _____means "join letter sequences together."

concatenate