Chapter 13 Homework

A range of cells can include..

1) cells from more than one row 2) cells from more than one column 3) the entire spreadsheet

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

4

Write a formula that would find the average in the cells of row 5, columns C - H

=AVERAGE(C5:H5)

Write the formula that would find the minimum of the values in the cells in Row 6, Columns B - N.

=MIN(B6:N6)

Write a formula that would find the total for the values in the cells in column B, rows 2 - 25

=SUM(B2:B25)

Which of the following is a valid cell range?

B4:F5

The basic unit of a spreadsheet is a:

Cell

A formula in a cell always starts with an equal sign

True

A group of cells is called a range.

True

By default, a formula in a spreadsheet will automatically recalculate if the value contained in any of the formula's cell references change.

True

Cell entries in spreadsheets can be formatted similarly to formatting in word processors.

True

cell reference that makes use of the dollar sign in its formula.

absolute

Spreadsheets can be sorted by

any column

We can see spreadsheets results graphically by creating

charts

What means "join letter sequences together."

concatenate

What at the beginning of a cell entry determines whether a spreadsheet cell contains a formula or data.

equals sign

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

fill handle

What is another word that describes "pullling" the formula or data into other cells?

filling

Data from another application that one wants to import into a spreadsheet is called

foriegn data

Which of the following is used for computing common summary applications in a spreadsheet?

functions

Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it:

is truncated

Spreadsheet columns are labeled with

letter

Spreadsheet rows are labeled with

numbers

cell reference that will change its value when copied from one cell to another.

relative

A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n):

series fill

What is the most common application of a spreadsheet?

to process numerical data