Details Title: basic spreadsheets Description: number crunching Total Flash Cards: 20 Created: 09/24/2007 13:30:20		New Users: To study from this flashcard set, or to create your own your own study flash cards, REGISTER HERE. Existing Users: CLICK HERE. Additional Computer Science Flashcards
Cards in this set: Term spreadsheets use Definition rows and columns Term visicalc Definition first spreadsheet program for microcomputers Term who "wrote" visicalc Definition bricklin and frankston in 78-79 Term problems suitable for spreadsheets Definition moderate amt of data that will be reused need for formatting, graphing, analysis Term what are spreadsheets used for? Definition what if analysis accounting Term what is a spreadsheet Definition a document containing values and other data organized into rows and columns created using spreadsheet software Term what applications or software is used to create spreadsheets? Definition excel lotus 123 corel quattro pro Term worksheet vs workbook Definition worksheet is a single spreadsheet workbook is a group of worksheets saved in a single file Term What are cells identified by? Definition Their cell address rows=numbers columns=letters Term what is a range in reference to spreadsheets? Definition rectangular group of cells in a worksheet Term What does a formula do? Definition Tells the computer to do some calculations Term What do formulas use to tell the computer what to do? Definition cell reference. tells the computer what cells to use for calculations. Term label on spreadsheet Definition descriptive text name id section Term constant value on spreadsheet Definition number typed in Term formula on spreadsheet Definition derived value calculated by the machine Term Date functions NOW Definition Date and time Term Date functions TODAY Definition places current date in selected cell Term Auto Fill is used to Definition reptitively copy contents of one cell completes a sequence days, months, etc Term relative cell reference Definition changes relative to the direction in which the formula is copied Term absolute cell reference Definition DO NOT CHANGE when a formula is copied place $ in front of column letter and row number ex. when using sales tax