CS 131 - HW 7 Chapter 13 Spreadsheets
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 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)
How many different ways are there to combine absolute and relative references to a single cell? A) 4 B) 1 C) 6 D) 2
A - 4
Suppose cell B4 has an entry. If the data in A4 is too wide, it: A) is truncated B) is abbreviated C) is hyphenated D) cannot be entered into a cell
A - is truncated
Which of the following is used for computing common summary applications in a spreadsheet? A) formulas B) functions C) tables D) formatting
B - functions
How many cells are in the range B4:E8? A) 5 B) 10 C) 20 D) unknown
C - 20
The basic unit of a spreadsheet is a: A) cell B) cube C) box D) grid
C - box
What is the most common application of a spreadsheet? A) as a journal B) to process text data C) to process numerical data D) as a drawing application
C - to process numerical data
Which of the following is a valid cell range? A) 1A:3B B) A1>A5 C) C3-C8 D) B4:F5
D - B4:F5
A range of cells can include: A) cells from more than one row B) cells from more than one column C) the entire spreadsheet D) all of the above
D - all of the above
Spreadsheets: A) can only be sorted by column A B) can be sorted by any column provided the column is named C) are sorted by rows then columns D) can be sorted by any column
D - can be sorted by any column
A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n): A) date copy B) auto-increment C) conditional fill D) series fill
D - series fill
All cells of a spreadsheet are always visible
False
Column widths in a spreadsheet must be set manually
False
Data can be copied from one cell to another, but formulas cannot
False
Functions and column letters in a spreadsheet are case sensitive
False
Hidden columns cannot be referenced in a formula
False
Spreadsheets can only sort in descending order
False
Tables from a Web Page cannot be pasted into a spreadsheet
False
The fill handle can be used to copy values but not formulas
False
You cannot mix absolute and relative references in the same cell reference
False
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
A(n) _______ cell reference makes use of the dollar sign in its formula
absolute
We can see spreadsheets results graphically by creating _________
charts
________ means "join letter sequences together."
concatenate
The _________ 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 "pulling" the formula or data into other cells?
filling
Data from another application that one wants to import into a spreadsheet is called __________
foreign data
A(n) _________ cell reference will change its value when copied from one cell to another
relative
This data is often in _______
tab-delimited
