Eazyquizes

# New Perspectives on Computer Concepts 2014 Comprehensive 17th Edition June Jamrich Parsons Dan Oja- Test Bank

\$25.00

Category:

## Description

New Perspectives on Computer Concepts 2014 Comprehensive 17th Edition June Jamrich Parsons Dan Oja- Test Bank

Sample Questions

Chapter 2: Manipulating Numbers with Excel

TRUE/FALSE

1. Microsoft Excel is text and data processing software and is not suited for working with formulas.

ANS:  F                    PTS:   1                    REF:   72

1. The Excel workspace is a grid of rows and columns.

ANS:  T                    PTS:   1                    REF:   73

1. Labels are used only for worksheet or column titles.

ANS:  F                    PTS:   1                    REF:   74

1. After you have pressed the Enter key, you cannot edit the value entered into the cell.

ANS:  F                    PTS:   1                    REF:   74

1. The letter “X” is used for multiplication in Excel.

ANS:  F                    PTS:   1                    REF:   76

1. Cell references used in formulas can lead to unexpected results when you copy or move the formulas.

ANS:  T                    PTS:   1                    REF:   69

1. Formulas cannot include more than two functions.

ANS:  F                    PTS:   1                    REF:   77

1. 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

1. 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

1. To delete an existing worksheet, right-click anywhere within the worksheet and click Delete.

ANS:  F                    PTS:   1                    REF:   82

1. Borders and background colors define areas of a worksheet and call attention to important information.

ANS:  T                    PTS:   1                    REF:   91

1. Font attributes can be applied only to the entire contents of a cell.

ANS:  F                    PTS:   1                    REF:   92

1. You can apply number formats to any cell.

ANS:  F                    PTS:   1                    REF:   93

1. If a label is too long to fit into a cell it is always truncated.

ANS:  F                    PTS:   1                    REF:   94

1. By default, values are always centered within the cell.

ANS:  F                    PTS:   1                    REF:   95

1. You have to manually modify your formulas if blank rows or columns are inserted or deleted.

ANS:  F                    PTS:   1                    REF:   96

1. Like Word, Excel allows you to work with styles.

ANS:  T                    PTS:   1                    REF:   97

1. After a chart is selected, you cannot resize it.

ANS:  F                    PTS:   1                    REF:   98

1. After a chart is selected, Excel displays only the FORMAT contextual tab.

ANS:  F                    PTS:   1                    REF:   99

1. Photographs can be inserted only from a file.

ANS:  F                    PTS:   1                    REF:   100

1. Excel provides tools that allow you to sort data in ascending order only.

ANS:  F                    PTS:   1                    REF:   109

1. You can hide rows or columns of data in a worksheet if the data they contain is confidential.

ANS:  T                    PTS:   1                    REF:   110

1. Like Word’s spelling checker, Excel provides a grammar checker.

ANS:  F                    PTS:   1                    REF:   111

1. Orientation refers to the relative positions of the worksheet and the paper.

ANS:  T                    PTS:   1                    REF:   113

1. 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

ANS:  F                    PTS:   1                    REF:   115

1. You can use options on the ribbon to customize which elements of a worksheet will print.

ANS:  T                    PTS:   1                    REF:   116

1. To print multiple copies of the current worksheet use the FILE tab’s Print option.

ANS:  T                    PTS:   1                    REF:   118

1. You can output worksheets as PDF files.

ANS:  T                    PTS:   1                    REF:   119

1. 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

1. Excel worksheets are saved in a(n) two-dimensional workbook. _________________________

ANS:  F, three-dimensional

PTS:   1                    REF:   73

1. 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

1. A(n) range is a series of cells. _________________________

ANS:  T                                                     PTS:   1                    REF:   73

1. 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

1. Excel calculates results using the standard mathematical order of operations, referred to as mathematical priority. _________________________

ANS:  F, precedence

PTS:   1                    REF:   77

1. Excel includes more than 250 functions from which you can choose. _________________________

ANS:  T                                                     PTS:   1                    REF:   78

1. One of the commonly used functions is the function MAXIMUM. _________________________

ANS:  T                                                     PTS:   1                    REF:   78

1. The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab. _________________________

ANS:  F, Clipboard

PTS:   1                    REF:   80

1. 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

1. The default workbook contains a worksheet, titled Worksheet1. _________________________

ANS:  F, Sheet1

PTS:   1                    REF:   82

1. An effectively formatted worksheet is more approachable and helps readers understand the meaning of values and formulas. _________________________

ANS:  T                                                     PTS:   1                    REF:   90

1. 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

1. After you’ve finished formatting a worksheet cell, click inside the cell to complete the process. _________________________

ANS:  F, outside

PTS:   1                    REF:   92

1. 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

1. To change the width of a cell, you must increase the width of the entire column. _________________________

ANS:  T                                                     PTS:   1                    REF:   94

1. By default, labels are aligned along the left edge of a cell. _________________________

ANS:  T                                                     PTS:   1                    REF:   95

1. The Worksheet Styles button displays formatting options that you can apply to sections of a worksheet. _________________________

ANS:  F, Cell

PTS:   1                    REF:   97

1. A(n) line chart is used to show the proportions of parts to a whole. _________________________

ANS:  F, pie

PTS:   1                    REF:   98

1. 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

1. The square handle that appears at the top of a graphic allows you to rotate the graphic. _________________________

ANS:  F, round

PTS:   1                    REF:   100

1. When sorting data click a cell in the column after you click the desired sort button. _________________________

ANS:  F, before

PTS:   1                    REF:   109

1. 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

1. To add a flagged word to the spelling dictionary, click the Add to Dictionary button. _________________________

ANS:  T                                                     PTS:   1                    REF:   111

1. 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

1. Use the Save As option to rename and save an extra copy of your worksheet. _________________________

ANS:  T                                                     PTS:   1                    REF:   112

1. Orientation refers to the absolute positions of the worksheet and the paper. _________________________

ANS:  F, relative

PTS:   1                    REF:   113

1. Use the Zoom control to see the entire page. _________________________

ANS:  T                                                     PTS:   1                    REF:   114

1. You can specify scaling to reduce or enlarge a worksheet for printing. _________________________

ANS:  T                                                     PTS:   1                    REF:   115

1. Worksheet labels are the column letters and row numbers. _________________________

PTS:   1                    REF:   116

MULTIPLE CHOICE

1. 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

1. 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

1. Excel worksheets are saved in a(n) _____-dimensional workbook
 a. three c. one b. two d. multi

ANS:  A                    PTS:   1                    REF:   73

1. 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

1. The active cell is marked with a _____ outline.
 a. black c. blue b. green d. red

ANS:  B                    PTS:   1                    REF:   73

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. Excel includes more than _____ functions from which you can choose.
 a. 1000 c. 250 b. 500 d. 750

ANS:  C                    PTS:   1                    REF:   78

1. 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

1. 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

1. 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

1. 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

1. 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

1. Excel treats all cells as _____ references, by default.
 a. absolute c. corresponding b. fixed d. relative

ANS:  D                    PTS:   1                    REF:   80

1. Referring to the accompanying figure, the active cell is cell _____.
 a. C9 c. A9 b. B9 d. C10

ANS:  A                    PTS:   1                    REF:   80

1. 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

1. 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

1. 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

1. Which of the following signs is used when creating an absolute reference?
 a. # c. \$ b. @ d. &

ANS:  C                    PTS:   1                    REF:   81

1. 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

1. 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

1. 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

1. The default workbook contains _____ worksheets.
 a. one c. three b. two d. four

ANS:  C                    PTS:   1                    REF:   82

1. Which of the following is the New sheet button?
 a. c. b. d.

ANS:  A                    PTS:   1                    REF:   82

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. The _____ Accounting Number Format button displays cell contents in your local currency format.
 a. c. b. d.

ANS:  B                    PTS:   1                    REF:   93

1. 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

1. 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

1. Which of the following buttons displays one more digit after the decimal point?
 a. c. b. d.

ANS:  C                    PTS:   1                    REF:   93

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. Which of the following buttons represents the Format Painter tool?
 a. c. b. d.

ANS:  D                    PTS:   1                    REF:   97

1. 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

1. 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

1. 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

1. 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

1. 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

1. Which of the following is a button that allows you to customize a chart?
 a. c. b. d.

ANS:  A                    PTS:   1                    REF:   98

1. 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

1. 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

1. 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

1. 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

1. 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

1. _____ 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

1. 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

1. 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

1. 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

1. 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

1. Which of the following buttons is used to specify additional sort levels?
 a. c. b. d.

ANS:  C                    PTS:   1                    REF:   109

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. _____ 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. In Page Layout view, gridlines are shown in _____.
 a. light gray c. black b. light blue d. red

ANS:  A                    PTS:   1                    REF:   116

1. 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

1. 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

1. Which of the following buttons is used to insert manual page breaks?
 a. c. b. d.

ANS:  C                    PTS:   1                    REF:   117

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. Which of the following is the normal Excel file format?
 a. .excl c. .xcl b. .xlsx d. .exl

ANS:  B                    PTS:   1                    REF:   119

1. _____ 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

1. 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

1. 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.

1. 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

1. 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

1. 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.

1. 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

1. 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

1. 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?

1. 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

1. 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

1. 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

1. A worksheet ____________________ is the rectangle formed by the intersection of a column and row.

ANS:  cell

PTS:   1                    REF:   73

1. The ____________________ cell is the cell you can currently edit or modify.

ANS:  active

PTS:   1                    REF:   73

1. A(n) ____________________ is any text entered into a cell of a worksheet.

ANS:  label

PTS:   1                    REF:   74

1. 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

1. A cell ____________________ is the column and row location of a cell.

ANS:  reference

PTS:   1                    REF:   76

1. 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

1. In addition to writing your own formulas, you can use predefined formulas called ____________________.

ANS:  functions

PTS:   1                    REF:   78

1. A(n) ____________________ consists of values or cell references used to calculate the result of the function.

ANS:  argument

PTS:   1                    REF:   79

1. A cell reference that changes when a formula is copied or moved is called a(n) ____________________ reference.

ANS:  relative

PTS:   1                    REF:   80

1. A collection of worksheets is called a(n) ____________________.

ANS:

workbook

3D workbook

PTS:   1                    REF:   82

1. Each type of data has special ____________________ characteristics that help to identify its purpose.

ANS:  formatting

PTS:   1                    REF:   90

1. You can quickly add simple borders using the Borders button in the ____________________ group on the HOME tab.

ANS:  Font

PTS:   1                    REF:   91

1. Font ____________________ are typically applied to the entire contents of a cell.

ANS:  attributes

PTS:   1                    REF:   92

1. When you click the ____________________ Decimal button, one fewer digit is displayed after the decimal point.

ANS:  Decrease

PTS:   1                    REF:   93

1. Excel automatically adjusts the height and width of selected cells when you use the ____________________ command.

ANS:  AutoFit

PTS:   1                    REF:   94

1. To quickly select all cells in a column, click the column _____ at the top of the column.

PTS:   1                    REF:   95

1. As you insert and delete rows and columns, Excel adjusts _____ cell references in formulas to keep them accurate.

ANS:  relative

PTS:   1                    REF:   96

1. Predefined _____ are built into the software, and include formats for displaying currency, percentages, and general numbers.

ANS:  styles

PTS:   1                    REF:   97

1. A(n) _____ chart (sometimes called a column chart) is used to show comparisons.

ANS:  bar

PTS:   1                    REF:   98

1. In general, you begin most modifications by _____ the chart element you want to change.

ANS:  right-clicking

PTS:   1                    REF:   99

1. ____________________ 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

1. 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

1. If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.

ANS:  Not in Dictionary

PTS:   1                    REF:   111

1. You should always ____________________ your worksheets before relying on the results.

ANS:  test

PTS:   1                    REF:   112

1. 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

1. Excel’s ____________________ view helps you refine the appearance of a worksheet before you print it.

ANS:  Page Layout

PTS:   1                    REF:   113

1. ____________________ orientation prints a worksheet on the page sideways.

ANS:  Landscape

PTS:   1                    REF:   113

1. The ____________________ button allows you to clear the print area setting so that the entire worksheet prints.

ANS:  Print Area

PTS:   1                    REF:   113

1. ____________________ are the lines that separate one cell from another.

ANS:  Gridlines

PTS:   1                    REF:   116

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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

1. 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.