Common Features Key Terms
Excel Key Terms
Excel Functions and Formulas
Features of Excel
Microsoft Office Terms
100
A collection of information stored on a computer under a single name
What is a file
100
Centralized space for file management tasks
What is Backstage View
100
A function that finds the middle value
What is Median Function
100
Excel functions that are useful to analyze a group of measurements
What is statistical function
100
Instructions to a computer program
What is a command
200
This is where you navigate to a different folder or library, or go back to a previous one
What is address bar
200
A command that enables you to select one or more columns or rows and freeze them.
What is Freeze Panes
200
Function that determines the lowest value
What is MIN
200
A series of rows and columns with related data that is managed independently
What is a pane
200
A file that has been reduced in size
What is a compressed file
300
Indicates the name of the related commands on the displayed tab
What is group names
300
Retrieves the date and time from your computer's calendar and clock
What is NOW function
300
A function that determines the highest value
What is MAX
300
A worksheet where totals from other worksheets are displayed and summarized
What is a summary sheet
300
A feature that corrects common spelling errors as you type
What is Auto Correct
400
Displays a group of task-oriented tabs that contains the commands, styles, and resources you need to work in Offi 2010 programs
What is the Ribbon
400
A cells content can be selected and moved from one location to another
What is Drag and Drop
400
Function that adds up all the items and divides the total by the amount of items added
What is AVERAGE
400
The option of letting you select and move cells
What is Drag and Drop
400
An existing document that you use as a starting point for a new document
What is Template
500
Highlighting by dragging with your mouse, areas of text, data, or graphics so that it can be edited, formatted, copied or moved
What is select
500
Arranging all data in a specific order, such as ascending or descending order
What is sort
500
Predefined formula that adds all the numbers in a range
What is SUM Function
500
A format that changes the appearance of a cell based on conditions
What is conditional format
500
A word with the same or similar meaning as another word
What is a synonym