Charts
Fun with Cells
Vocab
Formulas
Ginger mix
100
Pie chart;)
What is a chart that shows part of a whole?
100
Ascending.
What is sort order arranging text or numbers from a-z from smallest to largest.
100
Operand
What is number or cell reference used in a formula.
100
Sum
What is adds all the numbers in a range of cells.
100
What-if analysis?
What is a process of changing valuse in cells to see how those changes affect the outcome of formulas in the worksheet. Aka cute little ginger.
200
Line chart:P
What is a chart that uses points connected by a line?
200
Descending
What is sort order that arranges text and numbers from z-a.
200
Label
What is alphanumeric text that will not be used in calculation.
200
AVERAGE
What is returns the average of its arguments.
200
Function
What is a prewritten formula that makes it easy to perform common calculations. Whats a two headed ginger? Guess it right..and you get a kiss.
300
Column chart(*-*) *---( )---* ^^
What is a chart that uses bars of varying height to illustrate values?
300
Cell
What is space fromed by the intersection of a row and a column; the basic unit of a better and worksheet.
300
Alignment
What is the position of data within a cell.
300
COUNT
What is returns the number of cells in a range that contains numbers.
300
Argument
What is value, cell refernece, range, or text that acts as an operand in a function formula. What do they call a really big ginger....big red:)
400
Chart/graph:D (your gettin good)
What is a grafic representaion of values and their relationships?
400
Cell reference
What is unique identifier for a cell which is formed by combinging the cell's comlumn letter and row number.
400
Sort
What is arrange a list of words or numbers in ascending or descending order.
400
MAX
What is returns the largest value in a set of values.
400
Workbook
What is a collection of related worksheet. What do gingers lack that everyone else has.....souls.;)
500
Pie chart-uses data to represent a whole Line chart-uses points connected by a line to illustrate values Column chart-uses bars of varying height to illustrate values. If you got that right....well just go home B-)
Name any two charts and name their functions.
500
Absolute cell reference
What is cell refernce that does not adjust to the new cell location when copied or moved.
500
Spreadsheet.
What is grid of rows and coumns containing numbers, text, and formulas used to prefrom calculations.
500
MIN
What is returns the smallest value in a set of values. 500 points sweetness
500
Freeze
What is a function that keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls. What did the bartender say to the ginger...we dont take your color. THANK YOU FOR PLAYING OUR GINGER GAMES:)
M
e
n
u