Description
New Perspectives on Computer Concepts 2014 Comprehensive 17th Edition June Jamrich Parsons Dan Oja- Test Bank
Sample Questions
Instant Download With Answers
Chapter 2: Manipulating Numbers with Excel
TRUE/FALSE
- Microsoft Excel is text and data processing software and is not suited for working with formulas.
ANS: F PTS: 1 REF: 72
- The Excel workspace is a grid of rows and columns.
ANS: T PTS: 1 REF: 73
- Labels are used only for worksheet or column titles.
ANS: F PTS: 1 REF: 74
- After you have pressed the Enter key, you cannot edit the value entered into the cell.
ANS: F PTS: 1 REF: 74
- The letter “X” is used for multiplication in Excel.
ANS: F PTS: 1 REF: 76
- Cell references used in formulas can lead to unexpected results when you copy or move the formulas.
ANS: T PTS: 1 REF: 69
- Formulas cannot include more than two functions.
ANS: F PTS: 1 REF: 77
- To select a range of cells for use as arguments in a function, click the upper-left cell and release the mouse button.
ANS: F PTS: 1 REF: 79
- To create an absolute reference, insert a pound sign (#) before the column reference and another pound sign before the row reference.
ANS: F PTS: 1 REF: 81
- To delete an existing worksheet, right-click anywhere within the worksheet and click Delete.
ANS: F PTS: 1 REF: 82
- Borders and background colors define areas of a worksheet and call attention to important information.
ANS: T PTS: 1 REF: 91
- Font attributes can be applied only to the entire contents of a cell.
ANS: F PTS: 1 REF: 92
- You can apply number formats to any cell.
ANS: F PTS: 1 REF: 93
- If a label is too long to fit into a cell it is always truncated.
ANS: F PTS: 1 REF: 94
- By default, values are always centered within the cell.
ANS: F PTS: 1 REF: 95
- You have to manually modify your formulas if blank rows or columns are inserted or deleted.
ANS: F PTS: 1 REF: 96
- Like Word, Excel allows you to work with styles.
ANS: T PTS: 1 REF: 97
- After a chart is selected, you cannot resize it.
ANS: F PTS: 1 REF: 98
- After a chart is selected, Excel displays only the FORMAT contextual tab.
ANS: F PTS: 1 REF: 99
- Photographs can be inserted only from a file.
ANS: F PTS: 1 REF: 100
- Excel provides tools that allow you to sort data in ascending order only.
ANS: F PTS: 1 REF: 109
- You can hide rows or columns of data in a worksheet if the data they contain is confidential.
ANS: T PTS: 1 REF: 110
- Like Word’s spelling checker, Excel provides a grammar checker.
ANS: F PTS: 1 REF: 111
- Orientation refers to the relative positions of the worksheet and the paper.
ANS: T PTS: 1 REF: 113
- To get a good view of the entire worksheet before you change the margins, you might want to increase the zoom level to more than 100%.
ANS: F PTS: 1 REF: 114
- Excel includes predefined headers, and you cannot create your own headers.
ANS: F PTS: 1 REF: 115
- You can use options on the ribbon to customize which elements of a worksheet will print.
ANS: T PTS: 1 REF: 116
- To print multiple copies of the current worksheet use the FILE tab’s Print option.
ANS: T PTS: 1 REF: 118
- You can output worksheets as PDF files.
ANS: T PTS: 1 REF: 119
- To format numbers for easy reading, do not use commas in numbers for cells that hold numbers pertaining to money.
ANS: F PTS: 1 REF: 120
MODIFIED TRUE/FALSE
- Excel worksheets are saved in a(n) two-dimensional workbook. _________________________
ANS: F, three-dimensional
PTS: 1 REF: 73
- The active cell is the cell you can currently edit or modify, and it is marked with a(n) black outline. _________________________
ANS: F, green
PTS: 1 REF: 73
- A(n) range is a series of cells. _________________________
ANS: T PTS: 1 REF: 73
- Any numerical data you do not intend to use in a calculation should be entered as a(n) label. _________________________
ANS: T PTS: 1 REF: 74
- Excel calculates results using the standard mathematical order of operations, referred to as mathematical priority. _________________________
ANS: F, precedence
PTS: 1 REF: 77
- Excel includes more than 250 functions from which you can choose. _________________________
ANS: T PTS: 1 REF: 78
- One of the commonly used functions is the function MAXIMUM. _________________________
ANS: T PTS: 1 REF: 78
- The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab. _________________________
ANS: F, Clipboard
PTS: 1 REF: 80
- If the cell references should not be modified when moved to a new location, you should use a(n) relative reference. _________________________
ANS: F, absolute
PTS: 1 REF: 81
- The default workbook contains a worksheet, titled Worksheet1. _________________________
ANS: F, Sheet1
PTS: 1 REF: 82
- An effectively formatted worksheet is more approachable and helps readers understand the meaning of values and formulas. _________________________
ANS: T PTS: 1 REF: 90
- To add borders around the outside and inside edges of selected cells, click both the Outside and Inside border buttons in the Preset section. _________________________
ANS: F, Outline
PTS: 1 REF: 91
- After you’ve finished formatting a worksheet cell, click inside the cell to complete the process. _________________________
ANS: F, outside
PTS: 1 REF: 92
- The most commonly used number formats are available as buttons in the Data group on the HOME tab. _________________________
ANS: F, Number
PTS: 1 REF: 93
- To change the width of a cell, you must increase the width of the entire column. _________________________
ANS: T PTS: 1 REF: 94
- By default, labels are aligned along the left edge of a cell. _________________________
ANS: T PTS: 1 REF: 95
- The Worksheet Styles button displays formatting options that you can apply to sections of a worksheet. _________________________
ANS: F, Cell
PTS: 1 REF: 97
- A(n) line chart is used to show the proportions of parts to a whole. _________________________
ANS: F, pie
PTS: 1 REF: 98
- You can change to a different chart type clicking the FORMAT tab, then clicking the Change Chart Type button. _________________________
ANS: F, DESIGN
PTS: 1 REF: 99
- The square handle that appears at the top of a graphic allows you to rotate the graphic. _________________________
ANS: F, round
PTS: 1 REF: 100
- When sorting data click a cell in the column after you click the desired sort button. _________________________
ANS: F, before
PTS: 1 REF: 109
- To display rows or columns that are hidden, select the rows or columns that border the hidden section, then right-click and choose Show. _________________________
ANS: F, Unhide
PTS: 1 REF: 110
- To add a flagged word to the spelling dictionary, click the Add to Dictionary button. _________________________
ANS: T PTS: 1 REF: 111
- If the correct spelling appears in the Suggestions list, click to select it, then click the Replace button to correct the misspelled word. _________________________
ANS: F, Change
PTS: 1 REF: 111
- Use the Save As option to rename and save an extra copy of your worksheet. _________________________
ANS: T PTS: 1 REF: 112
- Orientation refers to the absolute positions of the worksheet and the paper. _________________________
ANS: F, relative
PTS: 1 REF: 113
- Use the Zoom control to see the entire page. _________________________
ANS: T PTS: 1 REF: 114
- You can specify scaling to reduce or enlarge a worksheet for printing. _________________________
ANS: T PTS: 1 REF: 115
- Worksheet labels are the column letters and row numbers. _________________________
ANS: F, headings
PTS: 1 REF: 116
MULTIPLE CHOICE
- A worksheet _____ is the rectangle formed by the intersection of a column and row.
| a. | input | c. | field |
| b. | cell | d. | element |
ANS: B PTS: 1 REF: 73
- The columns are typically labeled with _____.
| a. | numbers, starting with 1 as the column farthest to the left |
| b. | letters, starting with A as the column farthest to the right |
| c. | numbers, starting with 1 as the column farthest to the right |
| d. | letters, starting with A as the column farthest to the left |
ANS: D PTS: 1 REF: 73
- Excel worksheets are saved in a(n) _____-dimensional workbook
| a. | three | c. | one |
| b. | two | d. | multi |
ANS: A PTS: 1 REF: 73
- A cell located in the third row and forth column is named _____.
| a. | 3D | c. | D3 |
| b. | C4 | d. | 4C |
ANS: C PTS: 1 REF: 73
- The active cell is marked with a _____ outline.
| a. | black | c. | blue |
| b. | green | d. | red |
ANS: B PTS: 1 REF: 73
- When specifying a range, use a _____ to separate the first and last cells.
| a. | semicolon | c. | slash |
| b. | dash | d. | colon |
ANS: D PTS: 1 REF: 73
- Any text entered into a cell of the worksheet is called a(n) _____.
| a. | label | c. | entry |
| b. | value | d. | string |
ANS: A PTS: 1 REF: 74
- To edit a label after the Enter key has been pressed, you should first click the cell, then click in the _____, type your correction, then press the Enter key to complete your entry.
| a. | label input bar | c. | formula bar |
| b. | entry bar | d. | text field |
ANS: C PTS: 1 REF: 74
- If the label is too long to fit in the current cell and the cells on the right are not empty, _____.
| a. | extra cells will be inserted |
| b. | part of the label will be truncated |
| c. | the label will replace the content of the cells |
| d. | none of the above |
ANS: B PTS: 1 REF: 74
- Which of the following buttons on the formula bar should you click to complete your entry?
| a. | c. | ||
| b. | d. |
ANS: D PTS: 1 REF: 74
- It is possible to edit a label inside a cell; to activate it, first _____ the cell.
| a. | left-click | c. | right-click |
| b. | double-click | d. | point to |
ANS: B PTS: 1 REF: 74
- Which of the following data should be entered as a label?
| a. | telephone number | c. | volume |
| b. | price | d. | distance |
ANS: A PTS: 1 REF: 74
- Which of the following should be added before a number if you want to enter a number as a label, for example, as a telephone number?
| a. | slash | c. | apostrophe |
| b. | double quote | d. | pound |
ANS: C PTS: 1 REF: 75
- Values and labels can be entered automatically using the fill handle and a technique called _____.
| a. | fill-and-drag | c. | drag-and-drop |
| b. | drag-and-fill | d. | drag-and-paste |
ANS: B PTS: 1 REF: 75
- All of the following are arithmetic operators used in Excel, except _____.
| a. | x (multiplication) | c. | % (percent) |
| b. | ^ (exponent) | d. | + (addition) |
ANS: A PTS: 1 REF: 76
- After you click a cell for a formula, a rectangle of _____ called a marquee appears around that cell.
| a. | dots | c. | blue lines |
| b. | dots and dashes | d. | dashes |
ANS: D PTS: 1 REF: 76
- The method of creating formulas based on clicking cells instead of typing the cell reference is called the _____ method.
| a. | cursor | c. | marker |
| b. | pointer | d. | click |
ANS: B PTS: 1 REF: 76
- You can build complex formulas using arithmetic operators, parentheses, and a mixture of _____.
| a. | both constants and values | c. | cell references only |
| b. | both values and cell references | d. | values only |
ANS: B PTS: 1 REF: 77
- When using the standard mathematical order of operations _____ is/are performed last.
| a. | multiplication | c. | addition and subtraction |
| b. | subtraction | d. | multiplication and division |
ANS: C PTS: 1 REF: 77
- A formula that references the cell in which the formula resides is called a _____.
| a. | recursive reference | c. | self-reference |
| b. | circular reference | d. | relative reference |
ANS: B PTS: 1 REF: 78
- In addition to writing your own formulas, you can use predefined formulas called _____.
| a. | functions | c. | methods |
| b. | subroutines | d. | template formulas |
ANS: A PTS: 1 REF: 78
- Excel includes more than _____ functions from which you can choose.
| a. | 1000 | c. | 250 |
| b. | 500 | d. | 750 |
ANS: C PTS: 1 REF: 78
- Which of the following is a correct name for the function that calculates an average of values?
| a. | AVG | c. | MEAN |
| b. | AVERAGE | d. | AVGVAL |
ANS: A PTS: 1 REF: 78
- Which of the following functions calculates the total of a column or row of cells?
| a. | TOTAL | c. | SUMCOL |
| b. | SUM | d. | SUMROW |
ANS: B PTS: 1 REF: 78
- After you select a function, you have to specify the _____.
| a. | arguments | c. | inputs |
| b. | parameters | d. | data values |
ANS: A PTS: 1 REF: 79
- Functions can have _____ argument(s).
| a. | only one | c. | as many as needed |
| b. | not more than two | d. | three or less |
ANS: C PTS: 1 REF: 79
- The Function Arguments dialog box contains a link, _____, that you should click to get help with the arguments.
| a. | Help | c. | Function arguments |
| b. | F1 | d. | Help on this function |
ANS: D PTS: 1 REF: 79
- Excel treats all cells as _____ references, by default.
| a. | absolute | c. | corresponding |
| b. | fixed | d. | relative |
ANS: D PTS: 1 REF: 80
- Referring to the accompanying figure, the active cell is cell _____.
| a. | C9 | c. | A9 |
| b. | B9 | d. | C10 |
ANS: A PTS: 1 REF: 80
- Referring to the accompanying figure, the _____ group contains the button used to paste a formula into a new cell.
| a. | Editing | c. | Cells |
| b. | Clipboard | d. | Number |
ANS: B PTS: 1 REF: 80
- Referring to the accompanying figure, the marquee around one of the cells can be removed by clicking the _____ key.
| a. | F1 | c. | Esc |
| b. | Enter | d. | Alt |
ANS: C PTS: 1 REF: 80
- In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.
| a. | absolute | c. | relative |
| b. | fixed | d. | constant |
ANS: A PTS: 1 REF: 81
- Which of the following signs is used when creating an absolute reference?
| a. | # | c. | $ |
| b. | @ | d. | & |
ANS: C PTS: 1 REF: 81
- In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied to cell C7, the relative references in the formula change to _____.
| a. | =B6*C3 | c. | =B8*C5 |
| b. | =B7*C4 | d. | =B5*C2 |
ANS: B PTS: 1 REF: 81
- In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When it is copied and pasted into cell C8, why do the hash marks appear?
| a. | The copied formula does not refer to the correct cells and produces a result that is too large to fit in the cell. |
| b. | The copied formula contains a cell which is blank. |
| c. | The copied formula contains a cell with a label. |
| d. | none of the above |
ANS: A PTS: 1 REF: 81
- A collection of worksheets is sometimes called a _____.
| a. | worksheet collection | c. | 2D workbook |
| b. | 3D worksheet collection | d. | 3D workbook |
ANS: D PTS: 1 REF: 82
- The default workbook contains _____ worksheets.
| a. | one | c. | three |
| b. | two | d. | four |
ANS: C PTS: 1 REF: 82
- Which of the following is the New sheet button?
| a. | c. | ||
| b. | d. |
ANS: A PTS: 1 REF: 82
- Delete an existing worksheet by right-clicking the worksheet’s tab and clicking _____.
| a. | Cut | c. | Cross out |
| b. | Remove | d. | Delete |
ANS: D PTS: 1 REF: 82
- Which of the following refers to Column B, Row 2 on the worksheet called Sheet2?
| a. | Sheet2$B2 | c. | Sheet2&B2 |
| b. | Sheet2!B2 | d. | Sheet2#B2 |
ANS: B PTS: 1 REF: 82
- To put borders between individual cells you should click the _____ button in the Format Cells dialog box.
| a. | Inside | c. | Between |
| b. | Outside | d. | Outline |
ANS: A PTS: 1 REF: 91
- To add borders around the outside and inside edges of selected cells, click both Outline and Inside buttons in the _____ section in the Format Cells dialog box.
| a. | Border | c. | Style |
| b. | Presets | d. | Line |
ANS: B PTS: 1 REF: 91
- To add a colored background to a selected cell or cells, click the _____ tab in the Format Cells dialog box.
| a. | Border | c. | Format |
| b. | Fill | d. | Background |
ANS: B PTS: 1 REF: 91
- Which of the following buttons should you use to add and remove lines inside vertical border lines?
| a. | c. | ||
| b. | d. |
ANS: C PTS: 1 REF: 91
- To change the font for a range of cells, click the _____ cell, then drag the mouse to select the cells.
| a. | bottom-left | c. | bottom-right |
| b. | upper-left | d. | upper-right |
ANS: B PTS: 1 REF: 92
- To display the Format Cells dialog box you also can use the Format Cells Dialog Box Launcher in the _____ group.
| a. | Number | c. | Styles |
| b. | Cells | d. | Font |
ANS: D PTS: 1 REF: 92
- After selecting the cell you want to format, you can apply _____ font attribute(s).
| a. | only one | c. | multiple |
| b. | not more than three | d. | two |
ANS: C PTS: 1 REF: 92
- You can use buttons in the Font group on the _____ tab to select different font attributes for any data in worksheet cells.
| a. | HOME | c. | FORMAT |
| b. | VIEW | d. | INSERT |
ANS: A PTS: 1 REF: 92
- The most commonly used number formats are available as buttons in the _____ group on the HOME tab.
| a. | Value | c. | Number |
| b. | Cells | d. | Data |
ANS: C PTS: 1 REF: 93
- The _____ Accounting Number Format button displays cell contents in your local currency format.
| a. | c. | ||
| b. | d. |
ANS: B PTS: 1 REF: 93
- The Percent Style button displays cell contents as a percentage, which means .35 is displayed as _____.
| a. | 0.35% | c. | 350% |
| b. | 3.5% | d. | 35% |
ANS: D PTS: 1 REF: 93
- If your computer is configured for use in the U.S., the Comma Style button adds a comma every three digits to the left of the decimal point and displays _____ digits to the right of the decimal point.
| a. | one | c. | three |
| b. | two | d. | none |
ANS: B PTS: 1 REF: 93
- Which of the following buttons displays one more digit after the decimal point?
| a. | c. | ||
| b. | d. |
ANS: C PTS: 1 REF: 93
- Which of the following is displayed in the cell if the value is too long to fit into a cell?
| a. | &&&&&&& | c. | $$$$$$$$$$ |
| b. | *********** | d. | ######### |
ANS: D PTS: 1 REF: 94
- If a label is too long to fit into a cell and the next cell is empty, _____.
| a. | it extends into the next cell on the right |
| b. | it extends into the previous cell on the left |
| c. | the end of the label is cut off |
| d. | it automatically moves to the next line |
ANS: A PTS: 1 REF: 94
- To manually adjust the width of a column, position the pointer over the vertical line between two column headings so that the pointer changes to a _____ shape.
| a. | c. | ||
| b. | d. |
ANS: B PTS: 1 REF: 94
- Excel automatically adjusts the height and width of selected cells when you use the _____ command located in the HOME tab’s Format button.
| a. | AutoFormat | c. | AutoFit |
| b. | AutoAdjust | d. | Auto |
ANS: C PTS: 1 REF: 94
- To manually adjust the width of a column, position the pointer over the vertical line between two column headings so that the pointer changes to a shape. _____ while you drag the vertical line left or right to manually adjust the width of the column.
| a. | Double-click the right mouse button |
| b. | Press and hold the right mouse button |
| c. | Double-click the left mouse button |
| d. | Press and hold the left mouse button |
ANS: D PTS: 1 REF: 94
- In the accompanying figure, which callout points to the Merge and Center button?
| a. | A | c. | C |
| b. | B | d. | D |
ANS: A PTS: 1 REF: 95
- In the accompanying figure, which callout points to the button used to center cell contents?
| a. | A | c. | F |
| b. | B | d. | E |
ANS: D PTS: 1 REF: 95
- In the accompanying figure, which label was centered using the Merge and Center button?
| a. | Description | c. | Price |
| b. | Invoice | d. | Item # |
ANS: B PTS: 1 REF: 95
- Which of the following is aligned on the left edge of a cell by default?
| a. | value | c. | formula |
| b. | label | d. | number |
ANS: B PTS: 1 REF: 95
- To quickly select all cells in a column, _____.
| a. | click the column header at the top of the column |
| b. | click any cell in the column |
| c. | click on the first cell in the column and then drag mouse down |
| d. | individually click all cells in the column |
ANS: A PTS: 1 REF: 95
- To delete more than one row at a time, drag down over the rows you want to delete. Click the down-arrow button next to Delete in the _____ group, then click Delete Sheet Rows to delete the rows.
| a. | Alignment | c. | Data |
| b. | View | d. | Cells |
ANS: D PTS: 1 REF: 96
- To delete a row, first click _____.
| a. | any cell in the row | c. | only the cell letter |
| b. | only the first cell in the row | d. | none of the above |
ANS: A PTS: 1 REF: 96
- The formula =D3+D4 changes to _____ if the original column C is deleted.
| a. | =E3+E4 | c. | =F3+F4 |
| b. | =C3+C4 | d. | The formula does not change |
ANS: B PTS: 1 REF: 96
- The formula =D5+D6 changes to _____ if rows 1 and 2 are deleted.
| a. | =D4+D5 | c. | =D3+D4 |
| b. | =D2+D3 | d. | The formula does not change |
ANS: C PTS: 1 REF: 96
- Which of the following buttons represents the Format Painter tool?
| a. | c. | ||
| b. | d. |
ANS: D PTS: 1 REF: 97
- The _____ button displays formatting options that you can apply to sections of a worksheet.
| a. | Cell Styles | c. | Style Selection |
| b. | Format Painter | d. | Format as Section |
ANS: A PTS: 1 REF: 97
- A variety of predefined themes that improve the appearance of your worksheets are located on the _____ tab.
| a. | REVIEW | c. | INSERT |
| b. | PAGE LAYOUT | d. | HOME |
ANS: B PTS: 1 REF: 97
- You can use the Charts group on the _____ tab to chart or graph data in your worksheet.
| a. | REVIEW | c. | INSERT |
| b. | PAGE LAYOUT | d. | HOME |
ANS: C PTS: 1 REF: 98
- Which of the following chart types is used to show data that changes over time?
| a. | Pie chart | c. | Bar chart |
| b. | Line chart | d. | Column chart |
ANS: B PTS: 1 REF: 98
- Which of the following chart types is used to illustrate the proportion of parts to a whole?
| a. | Pie chart | c. | Bar chart |
| b. | Line chart | d. | Column chart |
ANS: A PTS: 1 REF: 98
- Which of the following is a button that allows you to customize a chart?
| a. | c. | ||
| b. | d. |
ANS: A PTS: 1 REF: 98
- The buttons that allow you to customize a chart appear in the _____ of the chart.
| a. | bottom-left | c. | upper-left |
| b. | bottom-right | d. | upper-right |
ANS: D PTS: 1 REF: 98
- In the accompanying figure, which callout points to the charting tabs?
| a. | D | c. | B |
| b. | C | d. | A |
ANS: D PTS: 1 REF: 99
- In the accompanying figure, which callout points to the charting buttons?
| a. | D | c. | B |
| b. | C | d. | A |
ANS: C PTS: 1 REF: 99
- In the accompanying figure, which callout points to the button that is used to change the source cells for a chart?
| a. | E | c. | C |
| b. | D | d. | B |
ANS: A PTS: 1 REF: 99
- In general, you begin most modifications on the chart by _____ the chart element you want to change.
| a. | left-clicking | c. | double-clicking |
| b. | right-clicking | d. | pointing to |
ANS: B PTS: 1 REF: 99
- _____ can be inserted from a file or imported directly from imaging devices.
| a. | Vector drawings | c. | Clip art |
| b. | Photographs | d. | Both photographs and clip art |
ANS: D PTS: 1 REF: 100
- If data becomes scrambled as a result of a sort, click the _____ button.
| a. | Undo | c. | Repeat |
| b. | Save | d. | Sort |
ANS: A PTS: 1 REF: 109
- It is a good idea to _____ your worksheet before performing a sort.
| a. | format | c. | review |
| b. | save | d. | select |
ANS: B PTS: 1 REF: 109
- To open the Sort dialog box, click the _____ tab, then click the Sort button.
| a. | HOME | c. | DATA |
| b. | VIEW | d. | REVIEW |
ANS: C PTS: 1 REF: 109
- Which of the following buttons is used to sort the data in one column in descending order?
| a. | c. | ||
| b. | d. |
ANS: B PTS: 1 REF: 109
- Which of the following buttons is used to specify additional sort levels?
| a. | c. | ||
| b. | d. |
ANS: C PTS: 1 REF: 109
- A data management feature that allows you to focus on a subset of the data in a worksheet is called _____.
| a. | Selecting | c. | Extracting |
| b. | Filtering | d. | Formatting |
ANS: B PTS: 1 REF: 110
- Which of the following operators can be used when filtering numbers?
| a. | Like | c. | Identical |
| b. | Less Than | d. | Starts With |
ANS: B PTS: 1 REF: 110
- Use the _____ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.
| a. | Number Filters | c. | Text Filters |
| b. | String Filters | d. | Character Filters |
ANS: C PTS: 1 REF: 110
- To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.
| a. | Proofing | c. | Changes |
| b. | Thesaurus | d. | Research |
ANS: A PTS: 1 REF: 111
- Which of the following words may not be recognized by Excel?
| a. | Price | c. | Quantity |
| b. | Jeremy | d. | Cash |
ANS: B PTS: 1 REF: 111
- If the correct spelling appears in the _____ list, click to select it.
| a. | Recommendations | c. | Suggestions |
| b. | Hints | d. | Synonyms |
ANS: C PTS: 1 REF: 111
- If you are sure the word is spelled correctly and appears multiple times in your worksheet, click the _____ button if you want to ignore all occurrences of this word throughout the entire worksheet.
| a. | Ignore All | c. | Ignore Once |
| b. | Disregard All | d. | Disregard Once |
ANS: A PTS: 1 REF: 111
- _____ orientation prints a worksheet on a vertically oriented page that is taller than it is wide.
| a. | Landscape | c. | Vertical Sheet |
| b. | Portrait | d. | Horizontal Sheet |
ANS: B PTS: 1 REF: 113
- To select a specific area of a worksheet to print, you should first use the _____ button.
| a. | Select Area | c. | Print Area |
| b. | Worksheet Area | d. | Area |
ANS: C PTS: 1 REF: 113
- To clear an area of the worksheet selected for printing you should use the _____ button.
| a. | Deselect Area | c. | Clear Area |
| b. | Worksheet Area | d. | Print Area |
ANS: D PTS: 1 REF: 113
- To get a good view of an entire worksheet before you change margins, you might want to reduce the zoom level to less than _____.
| a. | 80% | c. | 75% |
| b. | 100% | d. | 50% |
ANS: B PTS: 1 REF: 114
- If your worksheet contains multiple pages, the margin settings apply _____.
| a. | only to the current page | c. | to all the pages |
| b. | to the first two pages | d. | to the specified pages |
ANS: C PTS: 1 REF: 114
- You can adjust column widths while in _____ view.
| a. | Page Layout | c. | Page Preview |
| b. | Review | d. | Page Setup |
ANS: A PTS: 1 REF: 114
- You should select _____ margins if you want to control the space allocated for headers and footers.
| a. | Margins | c. | Custom Margins |
| b. | Predefined Margins | d. | Build Margins |
ANS: C PTS: 1 REF: 114
- Pages that contain cells that will not be printed are shown in _____.
| a. | white | c. | yellow |
| b. | light blue | d. | gray |
ANS: D PTS: 1 REF: 114
- In the accompanying figure, which callout points to the group of buttons used to add header elements?
| a. | F | c. | D |
| b. | C | d. | B |
ANS: C PTS: 1 REF: 115
- In the accompanying figure, which callout points to the button you should click to select header and footer options?
| a. | F | c. | D |
| b. | C | d. | B |
ANS: B PTS: 1 REF: 115
- In the accompanying figure, which callout points to the area you should click in the worksheet to exit Header/Footer mode?
| a. | E | c. | C |
| b. | G | d. | F |
ANS: A PTS: 1 REF: 115
- In the accompanying figure, which callout points to the area you should click first when adding a header or footer?
| a. | D | c. | C |
| b. | G | d. | A |
ANS: D PTS: 1 REF: 115
- In Page Layout view, gridlines are shown in _____.
| a. | light gray | c. | black |
| b. | light blue | d. | red |
ANS: A PTS: 1 REF: 116
- If you want headings displayed and printed, make sure there are checkmark(s) in _____.
| a. | the Heading View box | c. | both the Heading View and Print boxes |
| b. | the Print box | d. | none of the above |
ANS: C PTS: 1 REF: 116
- If you want formulas to be printed, click the _____ button on the FORMULAS tab.
| a. | View Formulas | c. | Display Formulas |
| b. | Show Formulas | d. | Print Formulas |
ANS: B PTS: 1 REF: 116
- Which of the following buttons is used to insert manual page breaks?
| a. | c. | ||
| b. | d. |
ANS: C PTS: 1 REF: 117
- Which of the following buttons should you click to specify label titles that should be repeated on every page?
| a. | c. | ||
| b. | d. |
ANS: B PTS: 1 REF: 117
- In the accompanying figure, which callout points to the option that allows you to change the default printing option, which prints the active worksheet?
| a. | A | c. | C |
| b. | B | d. | D |
ANS: D PTS: 1 REF: 118
- Referring to the accompanying figure, which callout points to the control that allows you to preview each page?
| a. | G | c. | C |
| b. | D | d. | E |
ANS: A PTS: 1 REF: 118
- Referring to the accompanying figure, which callout points to the button that starts printing?
| a. | H | c. | D |
| b. | F | d. | B |
ANS: B PTS: 1 REF: 118
- You can output Excel worksheets as PDF files using the _____ option on the FILE tab.
| a. | Export | c. | Send to PDF |
| b. | Import | d. | Transmit |
ANS: A PTS: 1 REF: 119
- You can use the FILE tab’s Share option to save a worksheet in Excel format to Microsoft’s Internet-based _____ and allow others to view it.
| a. | iCloud | c. | SkyDrive |
| b. | Live Connect | d. | Dropbox |
ANS: C PTS: 1 REF: 119
- Which of the following is the normal Excel file format?
| a. | .excl | c. | .xcl |
| b. | .xlsx | d. | .exl |
ANS: B PTS: 1 REF: 119
- _____ are a valuable formatting tool for creating Web pages; you can use Excel to create them.
| a. | Frames | c. | Divs |
| b. | Cells | d. | Tables |
ANS: D PTS: 1 REF: 119
- Which one of the following recommendations applies to making the longest data sets go down the screen?
| a. | Structure your data. |
| b. | Make sure your data is entered accurately. |
| c. | Remember the rules of mathematical precedence. |
| d. | Use absolute and relative references appropriately. |
ANS: A PTS: 1 REF: 120
- What should be avoided when developing worksheets?
| a. | formatting numbers for easy reading |
| b. | circular references |
| c. | using consistent formats for similar data |
| d. | using meaningful labels |
ANS: B PTS: 1 REF: 120
Case-Based Critical Thinking Questions
Case 2-1
Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions.
- Ethan starts by saying that a worksheet will always consist of _____.
| a. | ranges and active cells | c. | formulas and calculations |
| b. | rows and columns | d. | values and labels |
ANS: B PTS: 1 REF: 73 TOP: Critical Thinking
- Ethan explains that a _____ contains one or more worksheets.
| a. | workgroup | c. | workbook |
| b. | filegroup | d. | sheetbook |
ANS: C PTS: 1 REF: 73 TOP: Critical Thinking
- Ethan then shows James how to select a(n) _____, which is a series of cells.
| a. | order | c. | sequence |
| b. | range | d. | group |
ANS: B PTS: 1 REF: 73 TOP: Critical Thinking
Case 2-2
Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has.
- Gabe asks Kyra how to insert clip art. She tells him to _____.
| a. | click the EDITING tab, select Illustrations, then click the Online Pictures button |
| b. | click the INSERT tab, select Illustrations, then click the Online Pictures button |
| c. | click the INSERT tab, select Clip Art, then click the Online Pictures button |
| d. | click the INSERT tab, select Illustrations, then click the Clip Art button |
ANS: B PTS: 1 REF: 100 TOP: Critical Thinking
- Gabe asks Kyra how he can resize a graphic inserted into his worksheet. Kyra says he can _____.
| a. | use the round handle at the top of the graphic |
| b. | use the handles that appear on the edges of a selected graphic |
| c. | use the Zoom option |
| d. | drag the graphic |
ANS: B PTS: 1 REF: 100 TOP: Critical Thinking
- Gabe asks Kyra where he can find tools that will allow him to draw simple lines and shapes. She advises him to use the _____.
| a. | Shapes tools from the Illustrations group on the INSERT tab |
| b. | Lines and Shapes tools from the Illustrations group on the HOME tab |
| c. | Shapes tools from the Drawings group on the INSERT tab |
| d. | Vector Graphic tools from the Illustrations group on the INSERT tab |
ANS: A PTS: 1 REF: 100 TOP: Critical Thinking
Case 2-3
Max wants to save a worksheet as a Web page. What should he do?
- In the Save As dialog box, Max should save his Excel file as a(n) _____ file type.
| a. | HTTP | c. | XML |
| b. | HTML | d. | JS |
ANS: B PTS: 1 REF: 119 TOP: Critical Thinking
- Part of Max’s worksheet contains formatting that cannot be duplicated in a Web page. He is notified of the problem areas and is given the option of _____.
| a. | canceling |
| b. | continuing with the save |
| c. | both canceling and continuing with the save |
| d. | either canceling or continuing with the save |
ANS: D PTS: 1 REF: 119 TOP: Critical Thinking
- To make sure that his worksheet will work as a Web page, Max should preview his worksheet in _____ prior to posting the file online.
| a. | a Web browser | c. | Microsoft Word |
| b. | Print Preview | d. | Microsoft Excel |
ANS: A PTS: 1 REF: 119 TOP: Critical Thinking
COMPLETION
- A worksheet ____________________ is the rectangle formed by the intersection of a column and row.
ANS: cell
PTS: 1 REF: 73
- The ____________________ cell is the cell you can currently edit or modify.
ANS: active
PTS: 1 REF: 73
- A(n) ____________________ is any text entered into a cell of a worksheet.
ANS: label
PTS: 1 REF: 74
- To edit a label after you’ve pressed the Enter key, click the cell, then click in the ____________________ bar.
ANS: formula
PTS: 1 DIF: 74 REF: 66
- A cell ____________________ is the column and row location of a cell.
ANS: reference
PTS: 1 REF: 76
- After you click a cell for a formula, a rectangle of dashes called a(n) ____________________ appears around that cell.
ANS: marquee
PTS: 1 REF: 76
- In addition to writing your own formulas, you can use predefined formulas called ____________________.
ANS: functions
PTS: 1 REF: 78
- A(n) ____________________ consists of values or cell references used to calculate the result of the function.
ANS: argument
PTS: 1 REF: 79
- A cell reference that changes when a formula is copied or moved is called a(n) ____________________ reference.
ANS: relative
PTS: 1 REF: 80
- A collection of worksheets is called a(n) ____________________.
ANS:
workbook
3D workbook
PTS: 1 REF: 82
- Each type of data has special ____________________ characteristics that help to identify its purpose.
ANS: formatting
PTS: 1 REF: 90
- You can quickly add simple borders using the Borders button in the ____________________ group on the HOME tab.
ANS: Font
PTS: 1 REF: 91
- Font ____________________ are typically applied to the entire contents of a cell.
ANS: attributes
PTS: 1 REF: 92
- When you click the ____________________ Decimal button, one fewer digit is displayed after the decimal point.
ANS: Decrease
PTS: 1 REF: 93
- Excel automatically adjusts the height and width of selected cells when you use the ____________________ command.
ANS: AutoFit
PTS: 1 REF: 94
- To quickly select all cells in a column, click the column _____ at the top of the column.
ANS: header
PTS: 1 REF: 95
- As you insert and delete rows and columns, Excel adjusts _____ cell references in formulas to keep them accurate.
ANS: relative
PTS: 1 REF: 96
- Predefined _____ are built into the software, and include formats for displaying currency, percentages, and general numbers.
ANS: styles
PTS: 1 REF: 97
- A(n) _____ chart (sometimes called a column chart) is used to show comparisons.
ANS: bar
PTS: 1 REF: 98
- In general, you begin most modifications by _____ the chart element you want to change.
ANS: right-clicking
PTS: 1 REF: 99
- ____________________ is a data management feature that allows you to focus on a subset of the data in a worksheet.
ANS: Filtering
PTS: 1 REF: 110
- Use the ____________________ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.
ANS: Text Filters
PTS: 1 REF: 110
- If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.
ANS: Not in Dictionary
PTS: 1 REF: 111
- You should always ____________________ your worksheets before relying on the results.
ANS: test
PTS: 1 REF: 112
- You can test your worksheet by entering a set of ____________________ values for which you already know the results.
ANS: real-world
PTS: 1 REF: 112
- Excel’s ____________________ view helps you refine the appearance of a worksheet before you print it.
ANS: Page Layout
PTS: 1 REF: 113
- ____________________ orientation prints a worksheet on the page sideways.
ANS: Landscape
PTS: 1 REF: 113
- The ____________________ button allows you to clear the print area setting so that the entire worksheet prints.
ANS: Print Area
PTS: 1 REF: 113
- ____________________ are the lines that separate one cell from another.
ANS: Gridlines
PTS: 1 REF: 116
- You might want to insert a manual ____________________ if a page ends with a row that should be grouped with data on the next page.
ANS: page break
PTS: 1 REF: 117
ESSAY
- It is important to distinguish between a value and a label when entering information into an Excel worksheet. Please describe both a label and a value.
ANS:
– A label is any text entered into a cell of the worksheet. You can use labels for a worksheet title, to describe the numbers you’ve entered in other cells, and for text data, such as the names of people or cities. Any numerical data you do not intend to use in a calculation should be entered as a label. This data might be a telephone number, a Social Security number, or a street address.
– A value is a number that you intend to use in a calculation and that is entered into a cell of a worksheet. Cells containing values can be used in formulas to calculate results.
PTS: 1 REF: 74-75 TOP: Critical Thinking
- Using formulas is a basic part of Microsoft Excel. Please describe a formula and a cell reference and how they interact.
ANS:
– A formula specifies how to add, subtract, multiply, divide, or otherwise calculate the values in worksheet cells. A formula always begins with an equal sign (=) and can use cell references that point to the contents of other cells.
– A cell reference is the column and row location of a cell, for example, B1 and B2.
– How a formula uses cell references: The formula =B1-B2 subtracts the contents of cell B2 from the contents of cell B1 and displays the results in the active cell, for example, B3.
PTS: 1 REF: 76 TOP: Critical Thinking
- Excel gives you the ability to apply number formats to your values. Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.
ANS:
– The Accounting Number Format button displays cell contents in your local currency format. For example, if your copy of Windows is configured for use in the U.S., the currency button displays cell contents as dollars and cents with a leading dollar sign ($) and two digits to the right of the decimal point. An example would be: $1234.67.
– The Percent Style button displays cell contents as a percentage, which means .35 is displayed as 35%.
– The Comma Style button adds a comma to the values displayed in the cell. If your computer is configured for use in the U.S., the Comma Style button adds a comma every three digits to the left of the decimal point and displays two digits to the right of the decimal point. An example would be: 12,345.67.
PTS: 1 REF: 93 TOP: Critical Thinking
- Excel gives you the ability to chart or graph data in your worksheet. Describe the main chart types (line, pie, and bar) and their purpose. Also describe how to insert a chart in your worksheet.
ANS:
– A line chart is used to show data that changes over time.
– A pie chart illustrates the proportion of parts to a whole.
– A bar chart (sometimes called a column chart) is used to show comparisons.
– To insert a chart to the worksheet: Select the cells containing data to be included in the chart; then, on the INSERT tab, select a chart type from Charts group, and select a chart subtype.
PTS: 1 REF: 98 TOP: Critical Thinking
- Excel has many Page Setup options. Please briefly describe each of the following: Portrait orientation, Landscape orientation, Gridlines, and Worksheet headings.
ANS:
– Portrait orientation prints a worksheet on a vertically oriented page.
– Landscape orientation prints a worksheet on the page sideways (horizontally).
– Gridlines—the lines that separate one cell from another—can be printed to create visual boundaries for rows and columns.
– Worksheet headings are the column letters and row numbers.
PTS: 1 REF: 113 | 116 TOP: Critical Thinking
- The Options button offers several useful settings for headers and footers. List some suggestions on how to use them.
ANS:
Different First Page: Because the worksheet title is visible on the first page, you can omit it from the page 1 header.
Different Odd and Even Pages: Specify page numbers on the left side of even numbered pages, but on the right side of odd numbered pages.
Scale with Document: Scale the headers and footers the same amount as the document scaling when printing.
Align with Page Margins: Align the header/footer text with page margins for a clean block style.
PTS: 1 REF: 115 TOP: Critical Thinking
Reviews
There are no reviews yet.