Technology- Chapter 13

Question 1

cells

Answer 1

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

Question 2

spreadsheets were invented by

Answer 2

• Dan Brocklin and Bob Frankston in 1978

- there system was called VisiCalc and it ran on Apple II

Question 3

Cell range

Answer 3

the cells b2:d7

Question 4

the equal sign acts as the indicator because

Answer 4

it shows that it is a formula and not data

Question 5

filling

Answer 5

is an automated copying and pasting

Question 6

fill handle

Answer 6

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

Question 7

relative cell reference

Answer 7

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

Question 8

absolute cell reference

Answer 8

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

Question 9

functions

Answer 9

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

Question 10

functions and column letters

Answer 10

are not case sensitive in spreadsheets

Question 11

format

Answer 11

font color and cell color

Question 12

foreign data

Answer 12

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

Question 13

tab-delimited text

Answer 13

• spreadsheets prefer to import foreign data as this

- means that each cell entry is delimited (ends with ) a tab in the file

Question 14

concatenate

Answer 14

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