Homework c 13 Flashcards
(22 cards)
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)
