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

Test Bank For New Perspectives on Computer Concepts 2014 Comprehensive 17e June Jamrich Parsons Dan Oja

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

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

ANS: T PTS: 1 REF: 73

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

ANS: F PTS: 1 REF: 74

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

ANS: F PTS: 1 REF: 74

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

ANS: F PTS: 1 REF: 76

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

ANS: T PTS: 1 REF: 69

7.Formulas cannot include more than two functions.

ANS: F PTS: 1 REF: 77

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

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

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

ANS: F PTS: 1 REF: 82

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

ANS: T PTS: 1 REF: 91

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

ANS: F PTS: 1 REF: 92

13.You can apply number formats to any cell.

ANS: F PTS: 1 REF: 93

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

ANS: F PTS: 1 REF: 94

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

ANS: F PTS: 1 REF: 95

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

ANS: F PTS: 1 REF: 96

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

ANS: T PTS: 1 REF: 97

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

ANS: F PTS: 1 REF: 98

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

ANS: F PTS: 1 REF: 99

20.Photographs can be inserted only from a file.

ANS: F PTS: 1 REF: 100

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

ANS: F PTS: 1 REF: 109

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

ANS: T PTS: 1 REF: 110

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

ANS: F PTS: 1 REF: 111

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

ANS: T PTS: 1 REF: 113

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

26.Excel includes predefined headers, and you cannot create your own headers.

ANS: F PTS: 1 REF: 115

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

ANS: T PTS: 1 REF: 116

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

ANS: T PTS: 1 REF: 118

29.You can output worksheets as PDF files.

ANS: T PTS: 1 REF: 119

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

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

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

ANS: T PTS: 1 REF: 73

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

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

ANS: F, precedence

PTS: 1 REF: 77

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

ANS: T PTS: 1 REF: 78

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

ANS: T PTS: 1 REF: 78

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

ANS: F, Clipboard

PTS: 1 REF: 80

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

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

ANS: F, Sheet1

PTS: 1 REF: 82

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

ANS: T PTS: 1 REF: 90

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

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

ANS: F, outside

PTS: 1 REF: 92

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

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

ANS: T PTS: 1 REF: 94

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

ANS: T PTS: 1 REF: 95

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

ANS: F, Cell

PTS: 1 REF: 97

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

ANS: F, pie

PTS: 1 REF: 98

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

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

ANS: F, round

PTS: 1 REF: 100

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

ANS: F, before

PTS: 1 REF: 109

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

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

ANS: T PTS: 1 REF: 111

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

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

ANS: T PTS: 1 REF: 112

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

ANS: F, relative

PTS: 1 REF: 113

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

ANS: T PTS: 1 REF: 114

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

ANS: T PTS: 1 REF: 115

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

ANS: F, headings

PTS: 1 REF: 116