EXCEL PROJECT 1
Adjusted cell reference, when Excel automatically adjusts the cells for a new position (results in the SUM function entries being adjusted).
The small black square located in the lower-right corner of the heavy border around the active cell.
The heavy border and transparent blue background that indicates a selected range
Emphasizes certain entries and make the worksheet easier to read and understand.
Font face, defines the appearance and shape of the letters, numbers, and special characters.
Indicates how the characters are formatted.
Specifies the size of the characters on the screen.
A measurement system.
Defines the color of the characteristics.
Bolding an entry emphasizes it or makes it
Stand out from all the rest of the worksheet.
Involves creating a single cell by combining two or more selected cells.
Splitting A Merged Cell
The opposite of merging cells.
A built-in collection of formats such as a font style, font color, borders, and alignment.
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
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.
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.
A saved workbook is called this.
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.
Means Excel can differentiate between uppercase and lowercase letters
Hard Copy or Printout
A printed version of the worksheet.
The range of cells you choose to print.
In this mode, Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell.
To edit the contents directly in the cell.
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.
Exel overtypes, or replaces, the character to the right of the insertion point.
Place where you can get answers in Excel.