EXCEL PROJECT 1

Created by danaepley 

Upgrade to
remove ads

29 terms

Relative Reference

Adjusted cell reference, when Excel automatically adjusts the cells for a new position (results in the SUM function entries being adjusted).

Fill Handle

The small black square located in the lower-right corner of the heavy border around the active cell.

See-Through View

The heavy border and transparent blue background that indicates a selected range

Format

Emphasizes certain entries and make the worksheet easier to read and understand.

Font Type

Font face, defines the appearance and shape of the letters, numbers, and special characters.

Font Style

Indicates how the characters are formatted.

Font Size

Specifies the size of the characters on the screen.

Point Size

A measurement system.

Font Color

Defines the color of the characteristics.

Bolding an entry emphasizes it or makes it

Stand out from all the rest of the worksheet.

Merging Cells

Involves creating a single cell by combining two or more selected cells.

Splitting A Merged Cell

The opposite of merging cells.

AutoFormat

A built-in collection of formats such as a font style, font color, borders, and alignment.

Embedded Chart

3-D Clustered column chart.

Y-Axis or Value Axis

Excel derives the chart scale based on the values in the worksheet and then displays the scale along the vertical axis

Chart Location

The area on the worksheet where the chart appears.

X-Axis or Category Axis

Excel automatically selects the entries in the topmost row of the chart range as the titles for the horizontal axis.

Legend

Identifies the colors assigned to each bar in the chart.

Default Chart Type

The chart that Excel draws if you click the Finish button in the first Chart Wizard dialog box.

File

A saved workbook is called this.

Backup Copy

This type of copy is when Excel copies the current version of the workbook on disk to a file with the same name, but with the words, backup of, appended to the front of the file name.

Case-Sensitive

Means Excel can differentiate between uppercase and lowercase letters

Hard Copy or Printout

A printed version of the worksheet.

Print Area

The range of cells you choose to print.

Edit Mode

In this mode, Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell.

In-Cell Editing

To edit the contents directly in the cell.

Insert Mode

As you type a character, Exel inserts the character and moves all characters to the right of the typed character one position to the right.

Overtype Mode

Exel overtypes, or replaces, the character to the right of the insertion point.

Excel Help

Place where you can get answers in Excel.

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.

NEW! Voice Recording

Click the mic to start.

Create Set