QUESTION 67 Find and Replace Fnd Replace Find what: Replace with: Options >> Replace Find Al End Next Close In the accompanying figure, which item should you click to replace all occurrences of the choice entered in the Replace with text box? a. 1 5.2 QUESTION 68 Click Save and Submit to save and submit. Click Save All Answers to save all answers. 6 e Women Word QUESTION 64 Identify the letter of the choice that best matches the phrase or definition. A dark rectangle that outlines the cell in which you are working a. range Provides a brief description of the active command or task in progress b. Name box Identified by the coordinates of the intersecting column and c. cell pointer row d. cell address Displays the active cell address e. status bar - A selection of two or more cells QUESTION 65 QUESTION 38 Find and Replace Replace Find what: Replace with: Options > Replace A Replace Find All Eind Next In the accompanying figure, which item should you click to make sure your find and replace operation respected capitalization a. 1 b. 2 6.3 0.4 QUESTION 36 Protect Sheet P rotect worksheet and contents of locked cells BCD Quest Id Apri $1,011.32 $ 88.67 $ 854.44 $ 934.84 5 648.25 $ 675 24 $ 488.84 $ 456,88 S 963.22 S 52138 S. 897 34 $ 866.34 $ 866.42 $ 844 24 5 62 $ 398.47 $ 624.12 $ 866.34 $ 783.54 101.32 .88. 0 8 Password to unprotect sheet: S 963.22 S Allow all users of this worksheet to Selected Select unlocked cells Formats Format columns forrow Insert columns insert row seit lyperlinks Delete columns O Cancel In the accompanying figure, item 1 points to the check box option that a groups the worksheets b.freezes the worksheet cells c. opens the Document Inspector d. prevents locked cells from changes QUESTION 37 QUESTION 21 LINE E6 =PMT(D6/12, C6*12,-B6) C D B 1 Loan Calculator 3 Lender Commercial Bank 5 Venture Credit Union 6 First National Bank Loan Amount 400,000 400,000 400,000 Term (Years) 30 30 3 0 Interest Rate 4.50% 4.75% 5.00% Monthly Payment $2,026.74 $2,086.59 $2,147.29 In the accompanying figure, what is the name of the function in the formula of the active cell? a. -B6 b. D6 C. PMT d. Monthly Payment QUESTION 22