Formula
Formatting
Charts
All around Excel
Miscellaneous
100
A function that automatically adds the values in the cells directly above or to the left of the active cell.
What is Auto Sum
100
Arranging the shape, size, type, and general makeup of a cell or group of cells
What is Format
100
a chart that shows the relationship of a part to a whole
What is Pie Chart
100
to copy a cells contents and/or formatting into an adjacent cell or range
What is Fill
100
A prewritten formula that makes it easy to preform common calculations
What is Function
200
Adds all the numbers in a range of cells
What is Sum
200
to arrange a list of words or numbers in ascending or descending order
What is Sort
200
a graphic representation of values and their relationships: pie, line, column, bar, scattered
What is Chart/Graph
200
a selected worksheet cell that is ready for data entry
What is active cell
200
a vertical group of cells ina worksheet identified by letters
What is Column
300
returns the average (arithmetic means) of its arguments
What is Avarage
300
a collection of related worksheets
What is Workbook
300
a chart that uses points connected by a line to illustrate values in a worksheet
What is Line Chart
300
a cell reference that contains both relative and absolute refernces
What is Mixed Cell Referance
300
the workspace made up of columns and rows where data is entered to create an electronic spreadsheet
What is Worksheet
400
returns the numbers of cells in a range that contains numbers
What is Count
400
the position of data within a cell
What is alignment
400
a chart that uses bars of varying height to illustrate values in a worksheet
What is Column chart
400
the mathematical rules used for calculating the value of a formula
What is Order of Operations
400
Keeps selceted rows or columns visible on the screen as the rest of the worksheet scrolls
What is Freeze
500
Returns the smallest value in a set of values
What is Min
500
a horizontal group of cells in a worksheet identified by numbers
What is Row
500
Process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
What is What if anaylisis
500
numeric characters that can b e used in a calculation
What is Value
500
What are the ALL the phases of the moon
What is New Moon, New Crescent, First Quarter, Waxing Gibbous, Full moon, Waning gibbous, last quarter, old crescent.