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
