## CA I 4.01 Spreadsheet Components

##### Created by:

jenningba  on March 10, 2011

##### Classes:

COMPUTER APPLICATIONS I

Log in to favorite or report as inappropriate.
Pop out
No Messages

You must log in to discuss this set.

# CA I 4.01 Spreadsheet Components

 Workbooka file which contains one or more spreadsheets.
1/22
Preview our new flashcards mode!

Order by

#### Definitions

Workbook a file which contains one or more spreadsheets.
Spreadsheet an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.
Cells individual locations on a spreadsheet.
Cell address refers to one specific location, such as A4.
Cell range refers to a group of adjacent cells, such as A4:A16.
Column refers to all of the contents in a vertical range of cells of the spreadsheet.
Row refers to all of the contents in a horizontal range of cells.
Cell data classified according to its intended purpose.
Label used for cells that contain text or for numbers that will not be used in calculations.
Value indicates that the data has the potential to be used in calculations.
Formula instructs the software to perform a calculation.
Order of Operations Calculations are performed according to this
Basic function a shortcut for a formula.
Cell reference indicates a cell's location and provides instructions for how cell data is copied or used in calculations.
Relative Cell Reference cell value changes as the formula is copied
Absolute Cell Reference cell value remains static when copied to other locations
Mixed Cell Reference combination of an absolute and a relative cell
Parentheses control the Order of Operations
Sum adds the range of cells
Average determines the average of the range of cells
Maximum finds the highest number in the range of cells
Minimum finds the lowest number in the range of cells

### First Time Here?

Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.

### Set Champions

There are no high scores or champions for this set yet. You can sign up or log in to be the first!