Technology- Chapter 13 Flashcards Preview

Fall 2016 > Technology- Chapter 13 > Flashcards

Flashcards in Technology- Chapter 13 Deck (14):
1

cells

spreadsheets give us an array of these to help us create lists

2

spreadsheets were invented by

-Dan Brocklin and Bob Frankston in 1978
-there system was called VisiCalc and it ran on Apple II

3

Cell range

the cells b2:d7

4

the equal sign acts as the indicator because

it shows that it is a formula and not data

5

filling

is an automated copying and pasting

6

fill handle

saves us from explicitly setting each cell in the column or manually using the copy/paste operations

7

relative cell reference

when the software automatically transforms the formulas as it pastes them or fills them into a cell when you write F2

8

absolute cell reference

it tells the software never to change the reference when filling or pasting
has a $ sign

9

functions

spreadsheet software provides this for computing common summary operations such as totals (sum), averages, maximum and many others

10

functions and column letters

are not case sensitive in spreadsheets

11

format

font color and cell color

12

foreign data

data from another application that we want to import into a spreadsheet

13

tab-delimited text

-spreadsheets prefer to import foreign data as this
-means that each cell entry is delimited (ends with ) a tab in the file

14

concatenate

which means to join pieces of text together, one after the other