TEST BANK for Exploring Microsoft Excel 2013 Comprehensive by Mary Anne Poasty Keith Mulbery Jason D by welldoneassistant

Exploring Microsoft Excel 2013 Comprehensive by Mary Anne Poatsy Keith Mulbery Jason Davidson Robert Grauer (Test Bank All Chapters, 100% Original Verified, A+ Grade) Exploring Microsoft Excel 2013, Comprehensive (Poatsy) Chapter 1 Introduction to Excel: Hands-On-Exercise Videos 1) Pressing Tab moves the insertion point ________. A) down a row in the same column B) to the beginning of the next row C) right one cell D) left one cell Answer: C Diff: 1 Objective: HOE 1: Introduction to Spreadsheets 2) If .25 is typed and Enter or Tab is pressed, Excel will automatically: A) add a percent sign after the number. B) delete the number. C) add a zero in front of the decimal point. D) insert a formula. Answer: C Diff: 2 Objective: HOE 1: Introduction to Spreadsheets 3) Which of the following symbols represents division? A) / B) \ C) ÷ D) ^ Answer: A Diff: 2 Objective: HOE 1: Introduction to Spreadsheets 4) All Excel formulas begin with ________. A) * B) @ C) = D) # Answer: C Diff: 1 Objective: HOE 1: Introduction to Spreadsheets 5) Double-clicking on the fill handle copies a formula until: A) a new formula is entered. B) the Tab key is pressed. C) the Enter key is pressed. D) a blank row is encountered. Answer: D Diff: 2 Objective: HOE 1: Introduction to Spreadsheets 1 Copyright © 2014 Pearson Education, Inc.

6) Excel displays a series of ________ to indicate that the column width is too narrow to display entire cell contents. A) asterisks * B) pound signs # C) exclamation marks ! D) ampersands @ Answer: B Diff: 2 Objective: HOE 2: Mathematics and Formulas 7) What is the value of =1+2*3^2? A) 19 B) 49 C) 27 D) 81 Answer: A Diff: 2 Objective: HOE 2: Mathematics and Formulas 8) To display formulas instead of formula results you press Ctrl + ________. A) @ B) " C) $ D) ` Answer: D Diff: 3 Objective: HOE 2: Mathematics and Formulas 9) The check mark between the Name Box and the Formula Bar indicates ________. A) Go B) Enter C) Complete D) Correct Answer: B Diff: 3 Objective: HOE 3: Workbook and Worksheet Management 10) To change the color of a worksheet tab, you ________, click Tab Color from the menu, and select the desired color from the palette. A) click B) right-click C) double-click D) triple-click Answer: B Diff: 2 Objective: HOE 3: Workbook and Worksheet Management 2 Copyright © 2014 Pearson Education, Inc.

11) To automatically adjust the width of column C, you: A) double-click the column C heading. B) right-click the column C heading. C) double-click the border between columns C and D in the column headings. D) double-click the border between columns B and C in the column headings. Answer: C Diff: 2 Objective: HOE 3: Workbook and Worksheet Management 12) When copying or cutting a range of cells, the range is: A) surrounded by a solid green border. B) surrounded by a moving dashed green border. C) surrounded by a solid black border. D) surrounded by a moving dashed black border. Answer: B Diff: 2 Objective: HOE 4: Clipboard Tasks 13) When pasting the contents of the Clipboard, options such as Formulas & Number Formatting and Values & Source Formatting are displayed by selecting the destination cell or cells and ________. A) clicking Paste B) clicking the Paste arrow C) double-clicking D) clicking the object in the Clipboard Answer: B Diff: 2 Objective: HOE 4: Clipboard Tasks 14) The term ________ refers how data are placed in cells. A) positioning B) configuration C) arrangement D) alignment Answer: D Diff: 2 Objective: HOE 5: Formatting

15)

In the figure shown above, row 1 is the result of clicking ________. A) Merge Across B) Merge & Center C) Align to Center D) Align to Middle Answer: B Diff: 2 Objective: HOE 5: Formatting 16)

The four cells shown in figure above, are the result of clicking ________. A) Text Wrap B) Word Wrap C) Merge & Center D) Orientation Answer: B Diff: 2 Objective: HOE 5: Formatting 17)

The figure shown above, depicts the ________ button. A) Center B) Wrap Text C) Decrease Decimal D) Increase Decimal Answer: D Diff: 2 Objective: HOE 5: Formatting 18) Landscape and Portrait are examples of page ________. A) alignment B) arrangement C) positioning D) orientation Answer: D Diff: 2 Objective: HOE 6: Page Setup and Printing 4 Copyright © 2014 Pearson Education, Inc.

19) A ________ appears at the top of each printed page. A) header B) caption C) banner D) title Answer: A Diff: 2 Objective: HOE 6: Page Setup and Printing 20) Pressing Tab moves the insertion point right one cell. Answer: TRUE Diff: 1 Objective: HOE 1: Introduction to Spreadsheets 21) Clear All removes both cell contents and cell formatting. Answer: TRUE Diff: 2 Objective: HOE 1: Introduction to Spreadsheets 22) A workbook and a worksheet are the same thing. Answer: FALSE Diff: 1 Objective: HOE 2: Mathematics and Formulas 23) You can enter formulas by a combination of typing and clicking selected cells. Answer: TRUE Diff: 1 Objective: HOE 2: Mathematics and Formulas 24) You can change the name of a worksheet tab by clicking the tab and retyping the new name. Answer: FALSE Diff: 2 Objective: HOE 3: Workbook and Worksheet Management 25) To remove a worksheet, you click the worksheet tab and press Delete. Answer: FALSE Diff: 2 Objective: HOE 3: Workbook and Worksheet Management 26) To remove a row, you click the row number and press Delete. Answer: FALSE Diff: 2 Objective: HOE 3: Workbook and Worksheet Management

27) When pasting a range of cells, Values & Formatting copies the source formatting while converting the formulas to their current values. Answer: TRUE Diff: 2 Objective: HOE 4: Clipboard Tasks 28) are the Decrease Indent and Increase Indent buttons. Answer: TRUE Diff: 2 Objective: HOE 5: Formatting 29) A frame is a line that encloses a cell or a range of cells. Answer: FALSE Diff: 1 Objective: HOE 5: Formatting 30) A footer appears at the bottom of each printed page. Answer: TRUE Diff: 1 Objective: HOE 6: Page Setup and Printing

Exploring Microsoft Excel 2013, Comprehensive (Poatsy) Chapter 1 Introduction to Excel: What Is a Spreadsheet? 1) A spreadsheet is: A) the core of a slide presentation. B) an electronic file that is used to write text and graphics on the Web. C) an electronic file of a grid of columns and rows of related data. D) another word for a letter written on a computer. Answer: C Diff: 1 Objective: 1. Explore the Excel window 2) A workbook is defined as: A) similar to a spreadsheet but hard copy rather than electronic. B) an unchangeable picture of data. C) the address of the current cell. D) a file containing related worksheets. Answer: D Diff: 1 Objective: 1. Explore the Excel window 3) Which of the following is NOT a standard interface of Microsoft Office applications? A) Quick Access Toolbar B) Scroll bars C) Ribbon D) Input area Answer: D Diff: 2 Objective: 1. Explore the Excel window 4) An input area is defined as: A) a range of cells containing results based on the output area. B) a display of the name of a worksheet within a workbook. C) a range of cells containing values for variables used in formulas. D) the active cell within a workbook. Answer: C Diff: 1 Objective: 1. Explore the Excel window

5) An output area is defined as: A) a region of a worksheet with formulas dependent on values from an input area. B) a display of the range name and tab name within a workbook. C) a range of cells containing values for variables used in formulas and functions within a worksheet. D) the active cell on an active worksheet. Answer: A Diff: 1 Objective: 1. Explore the Excel window 6) The Formula Bar: A) displays the name of a worksheet within a workbook. B) is located at the intersection of a column and a row. C) identifies the address of the current cell in a worksheet. D) displays the formula or contents of an active cell. Answer: D Diff: 2 Objective: 1. Explore the Excel window 7) What does a sheet tab display? A) The worksheet and workbook name B) All formulas included on that worksheet C) The address of the current cell D) The name of a worksheet within a workbook Answer: D Diff: 2 Objective: 1. Explore the Excel window 8) A cell address: A) identifies the active cell and worksheet. B) identifies a cell by a column letter and a row number. C) contains a column letter, a row number, and a worksheet tab name. D) identifies a worksheet by its column letter and row number. Answer: B Diff: 2 Objective: 1. Explore the Excel window 9) To display a long text label on two or more lines within a single cell: A) type the first line, press Enter, and type the remaining line. B) insert a line break with Alt+Enter. C) insert a line break with Ctrl+Enter. D) use F2 to insert a line break after the first line. Answer: B Diff: 2 Objective: 2. Enter and edit cell data

10) AutoComplete: A) adds all numbers in the row automatically. B) searches for and displays any other similar label in the current column when you begin typing. C) adds numbers within a column automatically. D) searches for and displays any other similar label in the current row when you begin typing. Answer: B Diff: 2 Objective: 2. Enter and edit cell data 11) A value: A) controls the sequence in which Excel performs arithmetic operations. B) is a number that represents a quantity and can be the basis of calculations. C) includes letters, numbers, and spaces. D) is a combination of cell references, operators, values, and/or functions used to perform calculations. Answer: B Diff: 2 Objective: 2. Enter and edit cell data 12) Press ________ to enter data into a cell and keep that cell as the active cell. A) F2 B) Ctrl+F2 C) Shift+F4 D) Ctrl+Enter Answer: D Diff: 3 Objective: 2. Enter and edit cell data 13) A formula is: A) a number that represents a date and can be the basis of calculations. B) a combination of cell references, operators, values, and/or functions used to perform calculations. C) a number that represents a quantity and can be the basis of calculations. D) entered into a cell by pressing F2. Answer: B Diff: 2 Objective: 2. Enter and edit cell data 14) You should use cell references in formulas instead of constant values so that: A) you can easily include letters, numbers, and spaces. B) it is easier to debug the errors. C) you can change the input values without changing the formulas. D) you can control the sequence in which Excel performs arithmetic operations. Answer: C Diff: 2 Objective: 3. Create formulas 3 Copyright © 2014 Pearson Education, Inc.

15) The order of precedence in Excel 2013: A) includes letters, numbers, and spaces. B) controls the sequence in which Excel performs arithmetic operations. C) is a software application used to create and modify business communications. D) includes formulas, functions, and formatting. Answer: B Diff: 2 Objective: 3. Create formulas 16) Auto Fill in Excel 2013: A) enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle. B) is the fastest way to type A1 in the name box. C) is adjustable so you can display more or fewer characters in a column. D) helps carry over the fill to the remaining worksheets. Answer: A Diff: 2 Objective: 4. Use Auto Fill 17) The fill handle: A) is a red bolded circle at the bottom-right of an active cell. B) helps carry over the fill in an active cell to another range. C) is the same action as pressing the Enter key. D) is a small green square at the bottom-right corner of a cell. Answer: D Diff: 2 Objective: 4. Use Auto Fill 18) Using the fill handle on a cell containing a formula: A) cannot complete a sequence of dates in a column. B) changes the background color of the selected cells to yellow. C) copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula. D) has two or more sub-commands related to the command. Answer: C Diff: 2 Objective: 4. Use Auto Fill 19) Which of the following is NOT a way to insert a new worksheet? A) Click New sheet to the right of the last tab B) Press Ctrl+F11 C) Right-click a tab, select Insert from the shortcut menu, click Worksheet D) Click the Insert arrow in the Cells group, select Insert Sheet Answer: B Diff: 3 Objective: 6. Manage worksheets 4 Copyright © 2014 Pearson Education, Inc.

20) Column width: A) is adjustable so you can display more or less characters in a column. B) is not adjustable so keep the formulas as short as possible. C) always switches back to default. D) is best left unchanged unless you absolutely have to. Answer: A Diff: 2 Objective: 7. Manage columns and rows 21) Which of the following is NOT a way to unhide column A in a worksheet? A) Type A1 in the name box and then press the Enter key B) Right-click the hidden column heading and select Unhide C) Click Select All and use the Hide & Unhide submenu D) Click Unhide on the View tab Answer: D Diff: 3 Objective: 7. Manage columns and rows 22) A range: A) cannot be selected with the mouse. B) is the numbers that fall between the smallest and largest in a formula or function. C) is another word for the active worksheet. D) refers to a group of adjacent or contiguous cells. Answer: D Diff: 2 Objective: 8. Select, move, copy, and paste data 23) To select a range by using the name box: A) click in the name box and type the range address such as B15:D25 and then press Enter. B) select the name box from the File menu and choose Range. C) position the mouse pointer over the column headings holding the Alt key. D) click in the first cell of the range, hold the Ctrl key, and then click in the last cell of the range. Answer: A Diff: 3 Objective: 8. Select, move, copy, and paste data 24) Copy as Picture can be a useful command when: A) you do not have a printer available. B) the formulas, functions, and headings need to be tested even if it's been pasted into a Word document. C) you simply want to paste (and not edit) into a Word document. D) you need to edit the data quickly even if it has been pasted into PowerPoint of Word. Answer: C Diff: 3 Objective: 8. Select, move, copy, and paste data 5 Copyright © 2014 Pearson Education, Inc.

25) The wrap text feature in Excel: A) can be downloaded as an add-on to Excel 2013. B) enables long formulas to wrap to two or more lines within a single cell. C) is most useful with very short titles or column headings. D) enables data to appear on two or more lines within a cell. Answer: D Diff: 3 Objective: 9. Apply alignment and font options 26) A border: A) is data from another cell that is only temporarily residing in an active cell. B) is a line that surrounds a cell or a range of cells. C) never prints. D) is preset and weight cannot be adjusted. Answer: B Diff: 1 Objective: 9. Apply alignment and font options 27) Which of the following is FALSE pertaining to Excel number formats? A) When you apply a number format, you can specify the number of decimal places. B) Changing number formats changes the way a number displays in a cell. C) Values have no special formatting when you enter data into cells. D) The default number format is Comma. Answer: D Diff: 3 Objective: 10. Apply number formats 28) Which of the following is NOT a number format available in the Number group on the Home tab? A) Comma Style B) Percent Style C) Accounting Number Format D) Date Format Answer: D Diff: 3 Objective: 10. Apply number formats 29) Which of the following is NOT an option available on the Page Layout tab of Excel 2013? A) Select the print area B) Select the number format C) Select orientation D) Set the margins Answer: B Diff: 2 Objective: 11. Select page setup options

30) The Print Preview feature in Excel 2013 is available: A) on the Quick Access Toolbar. B) on the Page Layout tab. C) in Microsoft Office Backstage view. D) on the View tab. Answer: C Diff: 2 Objective: 12. Preview and print a worksheet 31) By default new workbooks contain three worksheets. Answer: FALSE Diff: 1 Objective: 1. Explore the Excel window 32) To begin a formula in a cell, first type the # symbol. Answer: FALSE Diff: 1 Objective: 4. Use Auto Fill 33) The order of precedence in Excel is the same as the basic order of operations in math. Answer: TRUE Diff: 2 Objective: 4. Use Auto Fill 34) To display cell formulas, press Ctrl and the asterisk (*). Answer: FALSE Diff: 1 Objective: 5. Display cell formula 35) In Excel 2013, it is only possible to add a new worksheet when the workbook is created. Answer: FALSE Diff: 1 Objective: 6. Manage worksheets 36) Double-clicking a worksheet tab allows you to rename the tab. Answer: TRUE Diff: 2 Objective: 6. Manage worksheets 37) To help manage your worksheets within a workbook, worksheets tabs can be assigned unique patterns and even icon pictures. Answer: FALSE Diff: 2 Objective: 6. Manage worksheets

38) When you hide a column or row, the data is not deleted, it is just hidden. Answer: TRUE Diff: 1 Objective: 7. Manage columns and rows 39) Excel data can be copied and pasted into a Word or PowerPoint document. Answer: TRUE Diff: 1 Objective: 8. Select, move, copy, and paste data 40) Formatting data makes it difficult to read and tends to obscure meaningful details. Answer: FALSE Diff: 1 Objective: 9. Apply alignment and font options 41) Once cells have been merged they cannot be unmerged. Answer: FALSE Diff: 1 Objective: 9. Apply alignment and font options 42) Text in a cell can by angled clockwise. Answer: TRUE Diff: 2 Objective: 9. Apply alignment and font options 43) Use horizontal alignment to move data in a cell closer to the top or bottom of the cell. Answer: FALSE Diff: 2 Objective: 9. Apply alignment and font options 44) Merge & Center is not a good tool for creating titles of headings in Excel. Answer: FALSE Diff: 2 Objective: 9. Apply alignment and font options 45) Changing the number format of a cell changes the value of the number stored in the cell. Answer: FALSE Diff: 1 Objective: 10. Apply number formats 46) Comma, Date, Time, and Fraction are all number formats available in Excel 2013. Answer: TRUE Diff: 1 Objective: 10. Apply number formats

47) A Special number format allows characters such as hyphens. Answer: TRUE Diff: 1 Objective: 10. Apply number formats 48) The Date number format only allows Long Date, for example, March 14, 2016. Answer: FALSE Diff: 1 Objective: 10. Apply number formats 49) The Page Setup dialog box contains additional options not found on the Excel Ribbon. Answer: TRUE Diff: 1 Objective: 11. Select page setup options 50) While it is common to center a worksheet horizontally on a page, it is not possible to center it vertically on the page in Excel 2013. Answer: FALSE Diff: 2 Objective: 11. Select page setup options 51) Default margins on an Excel 2013 worksheet are .75" top and bottom. Answer: TRUE Diff: 2 Objective: 11. Select page setup options 52) Column headings or row labels can be repeated on multiple-page printouts using the Print Titles Page Setup option. Answer: TRUE Diff: 2 Objective: 11. Select page setup options 53) The &[Page] code used in a cell displays the number of pages in a workbook. Answer: FALSE Diff: 2 Objective: 11. Select page setup options 54) Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document. Answer: FALSE Diff: 2 Objective: 11. Select page setup options 55) Before printing a worksheet, click the File tab and select Print to preview the worksheet. Answer: TRUE Diff: 1 Objective: 12. Preview and print a worksheet 9 Copyright © 2014 Pearson Education, Inc.

56) The ________ Toolbar allows a user to quickly save, undo, and redo or repeat commands in Excel 2013. Answer: Quick Access Diff: 2 Objective: 1. Explore the Excel window 57) The ________ of a workbook displays the file name as well as the software name. Answer: title bar Diff: 2 Objective: 1. Explore the Excel window 58) A(n) ________ is a single spreadsheet. Answer: worksheet Diff: 1 Objective: 1. Explore the Excel window 59) The ________ button on a worksheet appears as a triangle at the intersection of the row and column headings. Answer: Select All Diff: 3 Objective: 1. Explore the Excel window 60) The ________ bar displays information about a selected command or operation in progress. Answer: Status Diff: 2 Objective: 1. Explore the Excel window 61) The ________ command is helpful for navigating to a cell that is not visible onscreen. Answer: Go To Diff: 3 Objective: 2. Enter and edit cell data 62) To display a different worksheet click the sheet ________ at the bottom of the workbook window. Answer: tab Diff: 2 Objective: 1. Explore the Excel window 63) A number that represents a quantity or amount is called a(n) ________. Answer: value Diff: 2 Objective: 2. Enter and edit cell data

64) A combination of cell references, arithmetic operations, values, and/or functions used in calculations is called a(n) ________. Answer: formula Diff: 3 Objective: 2. Enter and edit cell data 65) For Excel to recognize a formula, it must start with a(n) ________ sign. Answer: equal OR = Diff: 1 Objective: 3. Create formulas 66) The order of ________ controls the sequence in which Excel does math. Answer: precedence Diff: 3 Objective: 3. Create formulas 67) You can copy the contents of a cell or a range of cells by dragging the ________. Answer: fill handle Diff: 2 Objective: 4. Use Auto Fill 68) Use ________ to complete a sequence in a worksheet such as January, February, March, and April. Answer: Auto Fill Diff: 3 Objective: 4. Use Auto Fill 69) The Show Formulas button is accessible from the ________ tab. Answer: Formulas Diff: 2 Objective: 5. Display cell formula 70) Click Format in the Cells group on the ________ tab to change the color of a worksheet tab. Answer: Home Diff: 1 Objective: 6. Manage worksheets 71) Adjust the column ________ to accommodate the widest entry in a column. Answer: width Diff: 1 Objective: 7. Manage columns and rows 72) If you select cells R45:S46 and T49:V53 you have selected a(n) ________ range. Answer: nonadjacent Diff: 2 Objective: 8. Select, move, copy, and paste data 11 Copyright © 2014 Pearson Education, Inc.

73) Use the ________ to select a range by clicking in it and typing a range address, and then pressing Enter. Answer: Name Box Diff: 3 Objective: 8. Select, move, copy, and paste data 74) When you've selected and subsequently cut the range, it is copied to the ________. Answer: Clipboard Diff: 2 Objective: 8. Select, move, copy, and paste data 75) If you enter data into a worksheet and decide you want the columns and rows reversed, you can click the Paste arrow, and then click ________. Answer: Transpose Diff: 3 Objective: 8. Select, move, copy, and paste data 76) ________ refers to how data are positioned in cells. Answer: Alignment Diff: 2 Objective: 9. Apply alignment and font options 77) The default number format in Excel 2013 is ________. Answer: General Diff: 3 Objective: 10. Apply number formats 78) The ________ format includes an optional dollar sign placed immediately to the left of a number. Answer: Currency Diff: 2 Objective: 10. Apply number formats 79) The ________ feature on in Page Setup displays a list to set or clear a print area on a worksheet. Answer: Print Area Diff: 3 Objective: 11. Select page setup options 80) The ________ view displays print options and displays a worksheet in print preview mode. Answer: Office Backstage Diff: 3 Objective: 12. Preview and print a worksheet

81) Match the following terms to their meanings: I. spreadsheet II. Title bar III. worksheet IV. workbook V. Ribbon A. electronic file that contains a grid of columns and rows B. contains file name and software name C. commands organized into groups D. file containing related worksheets E. spreadsheet that contains formulas, functions, values, etc. Answer: A, B, E, D, C Diff: 1 Objective: 1. Explore the Excel window 82) Match the parts of the Excel Window to their meanings: I. Name Box II. Formula Bar III. sheet tab IV. Select All V. active cell A. displays the contents of the active cell B. displays the name of a worksheet within a workbook C. current cell indicated by a dark green border D. identifier that displays the address of the current cell E. intersection of a column or row Answer: D, A, B, E, C Diff: 1 Objective: Multiple objectives 83) Match the following terms to their meanings: I. F2 II. Shift+F11 III. text IV. value V. formula A. number that represents a quantity used for calculations B. combination of cell references, operators, values, and/or functions to perform a calculation C. combination of letters, numbers, symbols D. insert a new worksheet E. make changes to cell contents Answer: E, D, C, A, B Diff: 1 Objective: Multiple objectives 13 Copyright © 2014 Pearson Education, Inc.

84) Match the following terms to their meanings: I. Page Number II. Orientation III. Accounting IV. Vertical V. Concatenation A. Header and Footer element B. Number format C. Page Setup command D. Alignment option E. Order of precedence Answer: A, C, B, D, E Diff: 2 Objective: 1. Explore the Excel window 85) Match the keystrokes to their descriptions: I. Page Up II. Page Down III. Tab IV. Ctrl+Home V. Ctrl+End A. move insertion point up one screen B. move insertion point down one screen C. move right one cell in the same row D. move insertion point to cell A1 E. move insertion point to the last active corner in the worksheet Answer: A, B, C, D, E Diff: 2 Objective: 1. Explore the Excel window 86) Match the type of data that can be entered into a cell with its description: I. text II. values III. dates IV. formulas V. AutoComplete A. 3-Oct-16, for example B. Quarter 1, for example C. cell references, arithmetic operations, and values used in calculations D. 534.34, for example E. displays other labels in that column that match the letters you type Answer: B, D, A, C, E Diff: 2 Objective: 2. Enter and edit cell data 14 Copyright © 2014 Pearson Education, Inc.

87) Match the following terms to their meanings: I. formulas II. semi-selection III. starts all formulas IV. A2+A3 V. =C24*D24 A. pointing to cells when building a formula B. change static numbers into meaningful results C. text D. formula E. equal sign (=) Answer: B, A, E, C, D Diff: 2 Objective: 3. Create formulas 88) Match the arithmetic operators in order of precedence: I. Parentheses II. Exponent III. Multiplication IV. Division V. Addition A. 3rd in order of precedence B. 1st in order of precedence C. 4th in order of precedence D. 5th in order of precedence E. 2nd in order of precedence Answer: B, E, A, C, D Diff: 2 Objective: 3. Create formulas 89) Match the following terms to their meanings: I. fill pointer II. series of pound signs III. Auto Fill IV. fill handle V. display cell formulas A. thin black plus sign B. cell is too narrow to display a full value C. Ctrl + ` combination D. copying the contents of a cell or range by dragging E. small square at the bottom-right corner of a cell Answer: A, B, D, E, C Diff: 3 Objective: Multiple objectives 15 Copyright © 2014 Pearson Education, Inc.

90) Match the following terms to their meanings: I. range II. Copy as Picture command III. nonadjacent range IV. Copy V. select all cells in a worksheet A. C10:C20 and E10:E20 B. default copy option C. cannot edit individual cell data D. press Ctrl+A twice E. group of adjacent or contiguous cells Answer: E, C, A, B, D Diff: 3 Objective: 8. Select, move, copy, and paste data 91) When B5 is the active cell and you press Ctrl+Enter, what happens? Answer: The label, value, or formula is entered into cell B5 and B5 remains the active cell. Diff: 2 Objective: 2. Enter and edit cell data 92) Briefly describe the data type "Text." Provide one or two examples of text entries in an Excel worksheet. Answer: Text is any combination of letters, numbers, symbols, and spaces not used in calculations. Worksheet titles such as "Juan's Taqueria Quarterly Sales" or a social security number such as 123-45-6789 are text entries. Diff: 2 Objective: 3. Create formulas 93) If you have =D5*E5 in cell F5 and want to copy that down to F6 through F12, assuming data is contained in cells D6:E12, what is the quickest and easiest way to do that? Answer: Click in cell F5, place your cursor over the fill handle until the cursor changes to a small, black plus sign. Double-click the fill handle to quickly copy the formula down through cell F12. Diff: 2 Objective: 4. Use Auto Fill 94) Describe a nonadjacent range, provide an example, and describe how to select a nonadjacent range. Answer: A nonadjacent range contains two or more cells or ranges that are not touching each other; for example, C10:C13 and E15:E25. Select the first range, press and hold Ctrl, and select the additional range or ranges. Diff: 2 Objective: 8. Select, move, copy, and paste data

95) Describe alignment in relation to Excel 2013. How is text automatically aligned, how are values automatically aligned, and how are dates automatically aligned? Answer: Alignment refers to how data are positioned in cells. Text aligns at the left cell margin, and dates and values align at the right cell margin. Diff: 2 Objective: 9. Apply alignment and font options 96) How do the Comma, Accounting, and Currency formats differ? Answer: The Comma format includes the comma as a separator for numbers of 1,000 and over. The Accounting format includes a dollar sign placed at the left border of the cell. The Currency format includes a dollar sign placed immediately to the left of the number. Diff: 2 Objective: 10. Apply number formats 97) Why would you want to use the Increase Decimal or Decrease Decimal buttons on the Home tab? Answer: Use Increase Decimal or Decrease Decimal on the Home tab to display more decimal places for greater or lesser precision. If, for example, a whole column contains whole dollar values and no cents, displaying .00 down the column looks cluttered. It is also important for number formats to be consistent and decreasing or increasing decimal places can keep numbers consistent in a row, column, or range. Diff: 3 Objective: 10. Apply number formats 98) Describe page orientation when printing. What is the default and in what circumstances may you want to change orientation? Answer: Orientation displays the orientation of the physical page--portrait, for worksheets with more rows than columns, and landscape, for worksheets with more columns than can fit in portrait orientation. Portland orientation is the default. Landscape orientation is more appropriate when a worksheet has many columns and fewer rows. Diff: 2 Objective: 11. Select page setup options 99) Describe three features available for headers and/or footers. Answer: A header and/or footer can appear at the top and/or bottom of every printed page of a workbook. You can create different headers or footers on different pages. You can create a header or footer that is different on the first page than on all other pages. You can also include your name, the date of the worksheet, and page numbers. Diff: 3 Objective: 11. Select page setup options

100) How would you print multiple worksheets? Answer: To print multiple worksheets, click the first sheet tab, press and hold Shift, and then click the last sheet tab. If you choose to select nonadjacent sheets, press and hold Ctrl as you click each sheet tab. When Print options display in Microsoft Office Backstage view, choose Print Active Sheets. Diff: 3 Objective: 12. Preview and print a worksheet

Exploring Microsoft Excel 2013, Comprehensive (Poatsy) Chapter 2 Formulas and Functions: Hands-On-Exercise Videos 1) When copying a cell, the term absolute cell reference indicates ________. A) the value of the cell will not change B) the cell label will not change C) cell reference will not change D) the cell can only be referenced one time Answer: C Diff: 2 Objective: HOE 1: Formula Basics 2) =D$3 is an example of a(n) ________ cell reference. A) relative B) absolute C) mixed D) combined Answer: C Diff: 2 Objective: HOE 1: Formula Basics 3) When cell C3 containing the formula =B6*C8 is copied to cell D2, the formula in cell D2 is ________. A) =B6*C8 B) =B6*B7 C) =C5*D8 D) =C5*D7 Answer: B Diff: 2 Objective: HOE 1: Formula Basics 4) A formula that refers to its own cell creates a(n) ________ reference. A) circular B) cross C) absolute D) erroneous Answer: A Diff: 2 Objective: HOE 1: Formula Basics

5) The MEDIAN function is used to find the ________ number in a range of cells. A) average B) middle C) lowest D) highest Answer: B Diff: 2 Objective: HOE 2: Function Basics 6) The value of =C3+C4+C5+C6+C7+C8+C9 can be calculated by using ________. A) =TOTAL(C3:C9) B) =SUM(C3:C9) C) =TOTAL(C3...C9) D) =SUM(C3...C9) Answer: B Diff: 2 Objective: HOE 2: Function Basics 7) If you wanted to determine how many cells in a range are not empty, you would use the ________ function. A) COUNTA B) COUNT C) MEDIAN D) MAXIMUM Answer: A Diff: 2 Objective: HOE 2: Function Basics 8) Which Excel function displays the current date? A) CURRENT B) DAY C) NOW D) TODAY Answer: D Diff: 2 Objective: HOE 2: Function Basics

The expression that implements the flow chart shown in the above figure is ________. A) IF(E2>B$2,0,B$3) B) IF(E2>B$2,B$3,0) C) IF(B$3,0,E2>B$2) D) IF(B$3,E2>B$2,0) Answer: B Diff: 2 Objective: HOE 3: Logical, Lookup, and Financial Functions 10)

Using the table shown above, you would use the ________ function to find interest rates corresponding to the number of years. A) HLOOKUP B) VLOOKUP C) IF D) INDEX Answer: B Diff: 2 Objective: HOE 3: Logical, Lookup, and Financial Functions 11) The name for a range can begin with a letter or ________. A) underscore (_) B) hyphen (-) C) number D) period (.) Answer: A Diff: 3 Objective: HOE 4: Range Names

12) A range name can contain up to ________ characters. A) 25 B) 100 C) 255 D) 300 Answer: C Diff: 3 Objective: HOE 4: Range Names 13) =D5 is an example of an absolute cell reference. Answer: FALSE Diff: 1 Objective: HOE 1: Formula Basics 14) =$R$5 is an example of a mixed cell reference. Answer: FALSE Diff: 1 Objective: HOE 1: Formula Basics 15) To tally a column, you would use the COUNT function. Answer: TRUE Diff: 2 Objective: HOE 2: Function Basics 16) The TODAY and NOW functions return the same result. Answer: FALSE Diff: 2 Objective: HOE 2: Function Basics 17) AVERAGE and MEDIAN are two functions used to determine central tendencies. Answer: TRUE Diff: 3 Objective: HOE 2: Function Basics 18) The IF function is an example of a Logical function. Answer: TRUE Diff: 1 Objective: HOE 3: Logical, Lookup, and Financial Functions 19) The PMT function calculates the amount of a mortgage. Answer: FALSE Diff: 2 Objective: HOE 3: Logical, Lookup, and Financial Functions

20) Range names are edited and deleted using the Name Manager. Answer: TRUE Diff: 1 Objective: HOE 4: Range Names

Exploring Microsoft Excel 2013, Comprehensive (Poatsy) Chapter 2 Formulas and Functions: Performing Quantitative Analysis 1) A relative cell reference: A) indicates a cell's specific location and the reference does not change when you copy the formula to another cell or range. B) contains both an absolute and a relative cell reference. C) indicates a cell's relative location from the cell containing the formula; the reference changes when you copy the formula. D) occurs when a formula directly refers to the cell containing the formula. Answer: C Diff: 1 Objective: 1. Use relative, absolute, and mixed cell references in formulas 2) An absolute cell reference: A) causes a potential error. B) indicates a cell's specific location and the reference does not change when you copy the formula. C) happens only when a formula indirectly refers to the cell containing the formula. D) contains both an absolute and a relative cell reference. Answer: B Diff: 2 Objective: 1. Use relative, absolute, and mixed cell references in formulas 3) A mixed cell reference: A) occurs when a formula directly or indirectly refers to the cell containing the formula. B) causes a potential error. C) contains absolute or relative cell references, but not both. D) contains both an absolute and a relative cell reference. Answer: D Diff: 3 Objective: 1. Use relative, absolute, and mixed cell references in formulas 4) A circular reference: A) is a predefined formula that performs a calculation. B) is a rule that governs the structure and components for functions. C) occurs when a formula directly or indirectly refers to the cell containing the formula. D) is an input such as a cell reference or a value needed to complete a function. Answer: C Diff: 2 Objective: 2. Correct circular references

5) Which of the following is FALSE about a function in Excel? A) A function is a predefined formula that performs a calculation. B) There are more than 400 functions in Excel 2013. C) Functions are organized into two categories in Excel. D) Functions in Excel must adhere to correct syntax. Answer: C Diff: 3 Objective: 3. Insert a function 6) Syntax: A) displays a list of functions and defined names as you enter a function. B) is a small pop-up description that displays the arguments for a function as you enter it. C) is a set of rules that govern the structure and components for a function. D) is an input such as a cell reference or a value needed to complete a function. Answer: C Diff: 3 Objective: 3. Insert a function 7) Formula AutoComplete: A) results in formulas such as =B4+C4. B) calculates the total of values contained in two or more cells. C) is a small pop-up description that displays the arguments for a function as you enter it. D) displays a list of functions and defined names as you enter a function. Answer: D Diff: 2 Objective: 3. Insert a function 8) What does a function ScreenTip do? A) Automatically inserts functions such as SUM (B4:C4) B) Calculates the total of values contained in two or more cells C) Automatically inserts formulas such as =B4+C4 D) Displays a small pop-up description of the arguments for a function as you enter it Answer: D Diff: 2 Objective: 3. Insert a function 9) Argument names that display in ________ are required; others are optional. A) italic B) all caps C) red D) bold Answer: D Diff: 2 Objective: 3. Insert a function

10) When #NAME? displays in a cell, you may have: A) used a range name that doesn't exist. B) used a worksheet name in the formula that does not exist. C) mistyped a workbook name in a function. D) mistyped the name of a function. Answer: D Diff: 3 Objective: 3. Insert a function 11) The SUM function: A) identifies the midpoint value in a set of values. B) calculates the total of values contained in two or more cells. C) calculates the arithmetic mean or average of values in a range. D) displays the lowest value in a range. Answer: B Diff: 2 Objective: 4. Insert basic math and statistics functions 12) How many arguments are required for the SUM function? A) 1 B) 2 C) 3 D) It depends on the type of SUM function Answer: A Diff: 2 Objective: 4. Insert basic math and statistics functions 13) The ellipsis in function syntax indicates that: A) you can add as many additional ranges as desired. B) the function has an error embedded in it. C) the function is part of the Logical function category. D) you are required to add additional ranges. Answer: A Diff: 2 Objective: 4. Insert basic math and statistics functions 14) For a straightforward, basic mathematical expression, it is best to use: A) the arithmetic mean or average of values. B) a formula like =C16*C17. C) a function such as =SUM(B4:C4). D) a nested formula inside of a function. Answer: B Diff: 2 Objective: 4. Insert basic math and statistics functions

15) What does the MEDIAN function do? A) Identifies the lowest value in a range B) Identifies the midpoint value in a set of values C) Identifies the highest value in a range D) Tallies the number of cells in a range that contain values Answer: B Diff: 2 Objective: 4. Insert basic math and statistics functions 16) The COUNTBLANK function: A) tallies the number of blank cells in a range. B) highlights every blank cell in a range. C) displays the current date in every blank cell in a range. D) tallies the number of cells in a range that are not empty. Answer: A Diff: 2 Objective: 4. Insert basic math and statistics functions 17) Which of the following is a new feature in Excel 2013? A) Lookup tables B) The COUNT functions C) Quick Analysis D) The Range Names feature Answer: C Diff: 2 Objective: 4. Insert basic math and statistics functions 18) Which of the following is NOT one of Excel's three basic count functions? A) COUNTA B) COUNTBLANK C) COUNTEMPTY D) COUNT Answer: C Diff: 2 Objective: 4. Insert basic math and statistics functions 19) A nested function: A) contains data for the basis of the lookup and data to be retrieved. B) is the lowest value for a specific category or series in a lookup table. C) looks up a value and returns a related result from the lookup table. D) contains another function embedded inside one or more of its arguments. Answer: D Diff: 2 Objective: 4. Insert basic math and statistics functions

20) What does the TODAY function do? A) Evaluates the day of the week, the date, and the time that the function was entered B) Displays the current date and time C) Displays the current date D) Displays any day that the user enters Answer: C Diff: 3 Objective: 5. Use date functions 21) Which of the following is FALSE about the NOW function? A) It displays the current date in a cell. B) It uses the computer's clock to display the date and time. C) It uses military time. D) It displays the current date and time. Answer: A Diff: 3 Objective: 5. Use date functions 22) The IF function: A) contains data for the basis of the lookup and data to be retrieved. B) looks up a value and returns a related result from a lookup table. C) evaluates a condition and returns one value if the condition is true, a different if false. D) contains another function embedded inside one or more of its arguments. Answer: C Diff: 2 Objective: 6. Determine results with the IF function 23) The logical test: A) is the lowest value for a specific category or series in a lookup table. B) evaluates true or false. C) contains another function embedded inside one or more of its arguments. D) contains data for the basis of the lookup and data to be retrieved. Answer: B Diff: 2 Objective: 6. Determine results with the IF function 24) What is a lookup table used for? A) It looks up a value and returns a related result. B) It contains data for the basis of a lookup and the data to be retrieved. C) It is the lowest value for a specific category or series. D) It is a reference to a cell containing a value to look up. Answer: B Diff: 3 Objective: 7. Use lookup functions

25) The breakpoint: A) looks up a value and returns a related result from the lookup table. B) is a range containing a lookup table. C) is the lowest value for a specific category or series in a lookup table. D) is a reference to a cell containing a value to look up. Answer: C Diff: 2 Objective: 7. Use lookup functions 26) The lookup value: A) is the argument in a function that identifies which lookup table column from which to return a value. B) looks in a horizontal table where the first row contains the values. C) is a reference to a cell containing a value to look up. D) is a range containing a lookup table. Answer: C Diff: 3 Objective: 7. Use lookup functions 27) The rate in a PMT function is: A) the periodic interest rate, such as a monthly interest rate. B) the total number of payment rate periods. C) a word or a string of characters that represent one or more cells. D) the rate of present value of a loan. Answer: A Diff: 1 Objective: 8. Calculate payments with the PMT function 28) The nper in a PMT function is: A) the total number of payment periods. B) a word or a string of characters that represent one or more cells. C) the present value of a loan. D) a set of range names. Answer: A Diff: 1 Objective: 8. Calculate payments with the PMT function 29) A range name: A) indicates a cell's specific location and the reference does not change when you copy the formula. B) is a word or a string of characters that represent one or more cells. C) indicates a cell's relative location from the cell containing the formula. D) always begins with an equal sign (=). Answer: B Diff: 3 Objective: 9. Create and maintain range names 6 Copyright © 2014 Pearson Education, Inc.