Formula & Functions
Formatting
Spreadsheet Basics
Vocab
Softball
100
What is the first thing you type when entering a formula
=
100
What is format cells?
dialog to display cells as currency
100
Individual location on a spreadsheet.
Cell
100
a present formula in excell
Function
100
What is the spot called that is in between first base and second base?
Second baseman
200
what is the easiest way to add up a range of numbers?
Sum Function
200
What is format painter ?
copy cell color or border or font with single click
200
What is the column averaged by?
Alphabet
200
small black dot or square at the bottom right corner of the active cell.
fill handle
200
What is a the name for a ball that goes straight in the air really high?
Pop fly
300
what is a cell referring to itself?
circular reference
300
What is conditional formatting
Set cell background depending on rules about vaule
300
what is the row identified by?
numbers
300
Used to find the largest or number in a given list of values
MAX
400
what do you use for the multiplication?
*
400
What are data bars?
width of color background indicates relative value of cell.
400
A worksheet which is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical
Spreadsheet
400
highlight what you have In the box then go up to format or the home tab then click on_______ then it's centered.
Merge and Center
500
what is logic function
If statement
500
What is format cells> date >locate?
Set Arabic format date
500
What is another name for the cell address?
Cell Reference
500
function in data base software that allows multiple adjacent cells tab combined into a single larger cell.
Merge Cell
M
e
n
u