How can we help?

You can also find more resources in our Help Center.

Computer Applications Vocabulary

STUDY
PLAY
Chart
a visual Representation of selected worksheet data
Chart area
a chart object that contains all of the chart objects
Cell Address
In Excel, a column letter followed by a row number that specifies the location of a cell
Criteria
In Excel, conditions or qualifications that determine whether data is chosen for a filter
Chart objects
Individual components of a chart, such as the chart
MAX
Calculates the largest value in the list of arguments
SUM
In Excel, the function used to calculate the total of the arguments.
Sort
A command that organizes columns in Excel spreadsheet or a Word Table numerically or alphabetically.
MIN
Calculates the smallest value in a list of arguments
COUNT NUMBERS
Counts the number of values in the list of arguments
Cell References
The address of a cell in an Excel worksheet that defines its location in the worksheet by column
AutoFilter arrows
In Excel, arrows to the right of each column heading that appear when AutoFilter is selected for a list; click the arrows to open a menu containing options for filtering and sorting the list data.
Arguments
a value, cell reference, or text used in an Excel function
AVERAGE
Calculates the average value of the arguments in a list
Data marker
A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell
Data table
A grid in a chart that contains the chart's underlying worksheet data, and that is usually placed below the x-axis
Functions
A prewritten formula you can use instead of typing a formula from scratch
Filter
A command that displays only the data that you want to see in an Excel
Formula auto complete
In Excel, a feature that helps you enter a formula in a cell by suggesting a listing
Formula builder
A tab on the Excel Toolbox that helps users create mathematical calculations