Home
Subjects
Explanations
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
JH Excel Terms
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (32)
Spreadsheet
Contains rows and columns of data
Row
Horizontal line of data identified by a number
Column
Vertical line of data identified by a letter
Cell
An intersection of a row and column
Cell indicator
Shows the active cell
Active cell
The cell that is selected
Entry bar
Type in text here and it will show in the cell (formula bar)
Cancel box
Canceled current entry ( or ESC)
Enter box
Enters data into cell ( or enter, tab, arrow keys)
Label
Character or text data that may not be used in a calculation
Value
Numeric data that may be used in a calculation
Date/time
Either a date or time
Wrap text
Word wrap text in a cell
Merging cells
Select a range of cells to merged together and centers data
Borders
Each cell has four of these (T, B, R, L)
Formula
Mathematical statement used to calculate a value
SUM function
Used to add a range of cells
AVERAGE function
Used to average a range of cells
MIN function
Used to find the smallest value in a range of cells
MAX function
Used to find the largest value in a range of cells
Marquee
The range of cells that is to be used (dancing ants)
Fill handle
Small black box in the lower right corner of the cell used to copy formulas to a range of cells
Relative referencing
Cell references of a copied formula that applies to a new row or column
Absolute referencing
Placing $ around column letter so cell reference will not change when filled down (F4)
Pie chart
Used to show percentages of a whole
Line chart
Used to show differences over time
Column chart
Shows differences in data
Embedded chart
Chart shown on the same sheet as the data
Legend
Explains part of the chart
X axis
Horizontal axis
Y axis
Vertical axis
Largest cell reference
XFD1048576
Sets with similar terms
Spreadsheet Terms 2012
40 terms
Spreadsheet Terms
46 terms
Spreadsheet Terms 7th
46 terms
Basic Computer Skills Review Vocab
74 terms
Other sets by this creator
CH7 Digital Literacy - Exploring the Internet
10 terms
CH2 Digital Literacy - Internet Saftey
20 terms
Security First Principals
10 terms
Code.Org Lesson 1-9
26 terms