MS Excel Chapter 3

Created by allisonng26 

Upgrade to
remove ads

14 terms

Office Clipboard

A reserved place in the computer's memory that allows you to collect text and graphics from and Office document and then paste them into almost any other type of document.

Drag and Drop

Using the mouse to move or copy cells.

#REF

The error message Excel displays to indicate there is a reference error.

Format Symbol

Excel immediately displays a number with an assigned format.

Freeze Titles

Excel displays the titles on the screen, no matter how far down or to the right you scroll.

Date Stamp

Shows the date the workbook, report, or other document was created or the period it represents.

NOW Function

Returns a number that corresponds to the system date and time beginning with December 31, 1899.

Absolute Cell Reference

Instructs Excel to keep the cell reference constant in the formula as it copies it to the destination area.

Relative Cell Reference

Instructs Excel to adjust the cell reference as it copies it to the destination area.

Mixed Cell Reference

A cell reference with only one dollar sign before either the column or the row.

IF Function

Useful when you want to assign a value to a cell based on a logical test.

Sparkline Chart

Provides a simple way to show trends and variations in a range of data within a single cell.

Chart Sheet

A sheet that contains only the chart.

Data Series

The data that determines the size of the slices in a pie chart.

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