# Computer Applications (Excel Chapter 1)

## Unlock all answers in this set

question
Requirements document
includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet, such as charting and Web support.
question
When selecting a cell the mouse pointer looks like...
The mouse is a block plus sign mouse pointer.
question
Cancel box/Enter box
If you type the wrong letter and notice the error before clicking the Enter box or pressing the ENTER key, use the BACKSPACE key to delete all the characters back to and including the incorrect letter. To cancel the entire entry before entering it into the cell, click the Cancel box in the formula bar or press the ESC key.
question
AutoCorrect feature
Works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
question
How does Excel automatically align text?
When you enter text, Excel automatically left- aligns the text in the cell.
question
Which characters are considered numbers?
A number can contain only the following characters. (0 1 2 3 4 5 6 7 8 9 + - ( ) , / . \$ % E e
question
SUM function
Adds all of the numbers in a range of cells, provides a convenient means to accomplish this task.
question
How does Excel know which cells to sum?
When entering the SUM function using the Sum button, Excel automatically selects what it considers to be your choice of the range to sum. When proposing the range to sum, Excel first looks for a range of cells with numbers above the active cell and then to the left.
question
How do you enter a number as text?
To enter a number as text, start the entry with an apostrophe.
question
Copy area (Source area)
The cell being copied.
question
Paste area (Destination area)
The range of cells receiving the copy.
question
Relative cell reference
question
Format
A worksheet to emphasize certain entries and make the worksheet easier to read but also looks more professional.
question
Point Size
A character with a point size of 10 is about 10/72 of one inch in height.
question
Theme
A collection of cell styles and other styles that have common characteristics, such as color scheme and font
question
Merging Cells
Involves creating a single cell by combining two or more selected cells.
question
Splitting a merged cell
The opposite of merging cells.
question
What effect does the Accounting Number format have on the selected text?
Accounting numbers format causes the cells to be displayed with two decimal places so that decimal places in cells align vertically.
question
What effect does the Comma Style format have on the selected text?
The Comma Style format causes the class to be displayed with two decimal places and commas as thousands separators.
question
Embedded chart the chart shown on page 36 is an embedded chart because....
Embedded chart (EX 36) the chart shown on page EX36 is an embedded chart because....
question
Snaps
Holding down the ALT key while you drag the chart snaps the edge of the chart to the worksheets grid lines.
question
Legend
Identifies the colors assigned to each bar in the chart.
question
Green computing
Involves reducing the environmental waste generated when using a computer.
question
Auto Calculate area
You can easily can obtain a total, an average, or other information about the numbers in a range by using Auto Calculate.
question
Edit mode