Computer Applications Vocabulary

20 terms by RudeAndNotGinger

Create a new folder

Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set