How can we help?

You can also find more resources in our Help Center.

29 terms

EXCEL PROJECT 1

STUDY
PLAY
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.