Homework c 13 Flashcards
Spreadsheets were invented by Dan Bricklin and Bob Frankston in 1978. The name of their product was
VisiCalc
Spreadsheets are made up of an array of
cells
Sptreadsheet__are labeled with letters
columns
A __ __ is defined by putting a starting cell reference followed by the ending cell reference separated by a colon.
cell range
A common operation on any type of list is to alphabetize or ___ it
sort
The spreadsheet views the cell entries as ___ or monolithic
atomic
All formulae begin with what type of sign?
=
The little square box in the lower-right corner of a highlighted cell is called the
Fill handle
A(n) ____ cell reference is one that will change when copied into another cell.
relative
A(n) ____ cell reference is one that will not change when copied into another cell.
absolute
How would you write an absolute cell reference for row K and column 6?
$K$6
Most spreadsheets allow us to convert our data into a visual format or a ____, like pie, bar, column, line, etc.
chart
Spreadsheets provide ____ for computing common summary operations like totals, averages, etc.
functions
When creating things like calendars, spreadsheets provide the ability to do a ____ where the values are incremented by one as you fill.
series fill
Specifying the format of a cell under certain conditions is called ___ formatting.
conditional
Data imported from another application is called ____.
foreign data
Foreign data should be in _____ format.
tab-delimited
___ means to “join together”
concatenate
the characters(s) used in a spreadsheet formula for multiplication.
*
Find the total of all the values in the cells from B2 to E6.
=sum(B2:E6)
Find the maximum value of all the values in the cells from B8 to B25.
=max(B8:B25)
Find the average value of all the values in the cells from B2 to J2.
=average(B2:J2)
