Shared Flashcard Set

Details

Lesson 8
Spreadsheets
18
Computer Science
8th Grade
04/03/2006

Additional Computer Science Flashcards

 


 

Cards

Term
Absolute cell reference
Definition
the content of the formula will not change when copied or removed to another cell
Term
Active Cell
Definition
the cell in which you are currently working in
Term
AutoFormat
Definition
customized preset styles
Term
Cell
Definition
the point at which a column and a row intersect or meet
Term
Cell Range
Definition
a group of cells that are closely situated
Term
Formula
Definition
a statement that performs a calculation
Term
Formula Bar
Definition
the area in a spreadsheet that displays formulas that have been entered
Term
Function
Definition
a built-in formula that is a shortcut for common calculations such as addition and average
Term
Label
Definition
is the alphabetical text and aligns at the left side of the cell
Term
Name box
Definition
the area on the spreadsheet that identifies the cell reference of the active cell
Term
Relative Cell Reference
Definition
when you copy cells that contain formulas, the program automatically adjusts the formula to the location into which it is copied
Term
Sorting
Definition
arranging data according to some particular order, such as alphabetical or numerical
Term
Spreadsheet
Definition
a row and column arrangement of data
Term
Task pane
Definition
In many software applications, a serpate pane to the right of the main window that displays commonly used commands
Term
Value
Definition
numerical text in a spreadsheet
Term
What-if-analysis
Definition
the process of using a spreadsheet to test the different scenarios or to apply a certain condition if a certain condition exists
Term
Workbook
Definition
a group of related spreadsheets
Term
Worksheet
Definition
A grid with columns and rows
Supporting users have an ad free experience!