Definitions (Unit M)
Excel 101
Guess The Unit
Formulas and Functions
Charts
100
Data that can be exchanged that may consist of text, a worksheet, or any other type of data.
What is Object
100
The first thing you do when you create a new Excel worksheet
What is Save
100
Working with formulas and functions.
What is Unit B
100
A formula that adds a range of cells.
What is Sum
100
The name at the top of the chart
What is Chart Title
200
Inserting a copy of the original object in the destination document and, if necessary, to subsequently edit this data seperately from the source document.
What is Embedding
200
In page layout view, what appears at the bottom or top of the page.
What is Header or Footer
200
Exchanging data with other programs.
What is Unit M
200
A formula that takes the average of the cells.
What is Average
200
The horizontal axis that often contains the names of data groups, such as locations, months, or years.
What is Category Axis
300
Inserting a copy of the original object that can be updated automatically if the data in the source document changes.
What is Linking
300
The button that you press to change the worksheet to either landscape or portrait.
What is Orientation
300
Working with charts (Introduction)
What is Unit D
300
A function that finds the largest value in a range of cells.
What is MAX
300
A series of data points on a line that shows data values that represent the general direction of the data.
What is Trendline
400
A seperator such as a space, comma, or semicolon between elements in imported data.
What is Delimeter
400
The typeface of design of a set of characters (letters, numbers, symbols, and punctuation marks)
What is Font
400
Using macros
What is Unit I
400
A logical formula that takes an action depending on whether the logical test is true or false.
What is IF Function
400
The sequence of values that Excel uses to plot or create a chart.
What is data series
500
A program such as Microsoft Powerpoint that you can use to create slideshow presentations.
What is Presentation Graphics
500
Indicated by a dollar sign before the column letter and/or row number.
What is Absolute Cell Reference
500
Using What-If Analysis
What is Unit K
500
A function that counts the cells in the range.
What is COUNT
500
Pulling a slice away from a pie chart.
What is Exploding
M
e
n
u