Excel Chapter 1
point size
A character with this size of 10 is about 10/72 of one inch in height.
in-cell editing
A procedure that with Excel in Edit mode, you can edit the contents directly in the cell.
format
A worksheet to emphasize certain entries and make the worksheet easier to read and understand.
SUM function
Adds all the numbers in a range of cells.
fill handle
Appears as a black and white rectangle with a blue down arrow in it.
standard properties
Are associated with all Microsoft Office flies and include author, title, and subject.
Insert mode
As you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.
number
Can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e.
Cancel box
Cancels an entry.
Enter box
Completes and entry.
font color
Defines the color of the characters.
relative reference
Each adjusted cell reference.
Overtype mode
Excel over types, or replaces, the character to the right of the insertion point.
equal sign
In the formula alerts Excel that you are entering a formula or function and not a text.
minus sign
In the formula is the arithmetic operator that directs Excel to perform the subtraction operation.
Edit mode
In this mode, Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell.
automatically updated properties
Includes file system properties, such as the date you create or change a file, and statistics, such as the file size.
font style
Indicates how the characters are emphasized.
merging
Involves creating a single cell by combining two or more selected cells.
insertion point
Is a blinking vertical line that indicates where the next typed character will appear.
range
Is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
hard copy
Is information that exists on a physical medium such as paper.
printout
Is information that exists on a physical medium such as paper.
select
Is to tap it or use the mouse to move the block plus sign pointer to the cell and then click.
text
Is used to place titles, such as worksheet titles, column titles, and row titles, on the worksheet.
font
Or Font face, defines the appearance and shape of the letters, numbers, and special characters.
font size
Specifies the size of the characters on the screen.
bold
Text has a darker appearance than normal text.
copy area
The cell being copied.
source area
The cell being copied.
category names
The expense titles in the range A9:A16 will identify the slices of the pie chart.
splitting
The opposite of merging cells is doing this to a merged cell.
chart sheet
The pie chart resides on a separate sheet, which contains only the chart.
data series
The range N9:N16 contains the data that determines the size of the slices in the pie.
destination area
The range of cells receiving the copy.
paste area
The range of cells receiving the copy.
document properties
Which are the details about a file such as the project author, title, and subject.
green computing
Which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.
AutoCorrect feature
Works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
AutoCalculate area
You easily can obtain a total, an average, or information about the numbers in a range by using this.