Advertisement Upgrade to remove ads

Ascending sort

Data with letters arranged in alphabetical order (A to Z), data with numbers arranged from lowest to highest, and data with dates arranged from earliest to latest.

Comment

A note attached to a cell that is usually used to explain or identify information
contained in the cell.

Conditional formatting

Highlights worksheet data by changing the look of cells that meet a specified condition.

Descending sort

Arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.

Filter

Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria.

Filter arrow

Appear in the lower-right corners of the column heading cells and are used to access the AutoFilter menu for that column.

Hyperlink

A cell in a worksheet that opens another file or page when you click it.

Object

Anything that appears on the screen that you can select and work with as a whole.

Picture

A digital photograph or other image file.

Research task pane

Provides access to information typically found in references such as dictionaries, thesauruses, and encyclopedias.

Screen clipping

When you take a screenshot, you can include everything visible on your monitor or a screen clipping, which is the area you choose to include.

Screenshot

A picture of all or part of something you see on your monitor, such as a Word document, an Excel workbook, a photograph, or a Web page.

Shape

Shapes, such as rectangles, circles, arrows, lines, flowchart symbols, and callouts, can help make a worksheet more informative.

SmartArt graphic

Enhance worksheets by providing a visual representation of information and ideas.

Sort

Rearranging the data in a more meaningful order.

Template

A predesigned workbook file that you can use as the basis or model for a new workbook.

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