Computer Applications (Excel Chapter 1)

10 September 2022
4.7 (114 reviews)
28 test answers

Unlock all answers in this set

Unlock answers (24)
question
Requirements document
answer
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...
answer
The mouse is a block plus sign mouse pointer.
question
Cancel box/Enter box
answer
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
answer
Works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
question
How does Excel automatically align text?
answer
When you enter text, Excel automatically left- aligns the text in the cell.
question
Which characters are considered numbers?
answer
A number can contain only the following characters. (0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
question
SUM function
answer
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?
answer
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?
answer
To enter a number as text, start the entry with an apostrophe.
question
Copy area (Source area)
answer
The cell being copied.
question
Paste area (Destination area)
answer
The range of cells receiving the copy.
question
Relative cell reference
answer
Each adjacent cell reference.
question
Format
answer
A worksheet to emphasize certain entries and make the worksheet easier to read but also looks more professional.
question
Point Size
answer
A character with a point size of 10 is about 10/72 of one inch in height.
question
Theme
answer
A collection of cell styles and other styles that have common characteristics, such as color scheme and font
question
Merging Cells
answer
Involves creating a single cell by combining two or more selected cells.
question
Splitting a merged cell
answer
The opposite of merging cells.
question
What effect does the Accounting Number format have on the selected text?
answer
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?
answer
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....
answer
Embedded chart (EX 36) the chart shown on page EX36 is an embedded chart because....
question
Snaps
answer
Holding down the ALT key while you drag the chart snaps the edge of the chart to the worksheets grid lines.
question
Legend
answer
Identifies the colors assigned to each bar in the chart.
question
Green computing
answer
Involves reducing the environmental waste generated when using a computer.
question
Auto Calculate area
answer
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
answer
Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell.
question
In-cell editing
answer
With Excel in edit mode, you can edit the contents directly in the cell -- a procedure called in-cell editing.
question
Insert mode
answer
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.
question
Overtype mode
answer
Excel over types, or replaces, the character to the right of the insertion point.