Shared Flashcard Set

Details

SPREADSHEET vocabulary
NC computer competency skills test review
13
Computer Science
03/28/2011
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
Spreadsheet
Definition
a row and column arrangement of data used to enter, calculate, manipulate, and analyze numbers.

Term
Row
Definition
horizontal sections of a spreadsheet; identified by a number.
Term
Column
Definition
Vertical sections of a spreadsheet; identified by a letter.
Term
Cell
Definition
The point at which a column and row intersect or meet.
Term
Cell Address/Reference
Definition
The location of a cell as identified by the column letter and row number
Term
Range
Definition
A group of cells closely related.
Term
Active Cell
Definition
The cell in which you are currently working.
Term
Formula
Definition
statement that performs a calculation. Example: =B1+B2+B3+B4+B5+B6
Term
Function
Definition
Built-in formulas used with a range to perform calculations. Example: =sum(B1:B25)
Term
IF Statement
Definition
a logical function (formula) that allows the user to set up a condition to test data.
Term
Bar Graph
Definition
represents different quantities by using bars.
Term
Line Graph
Definition
shows changes in data over a period of time.
Term
Pie Graph
 Definition
divides the total into the parts of a circle.