Devry BIS155 week 5 quiz

Jul 29th, 2016
Studypool Tutor
Price: $15 USD

Tutor description

Question 1. 1. (TCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT: (Points : 2) create Pivot Charts group worksheets together to enter data. display worksheets side by side. create links among the worksheets. Question 2. 2. (TCO5) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets: (Points : 2) the same formula is entered into all grouped worksheets. the formula changes by one row in each grouped worksheet. the formula changes by one column in each grouped worksheet. nothing happens to the other sheets. Question 3. 3. (TCO 5) If the active cell is in row 1, but not in column A, when you click the Split command, the worksheet will appear in two ________ panes. (Points : 2) horizontal diagonal vertical square Question 4. 4. (TCO 5) In Excel, which of the following is NOT a method for removing a split window? (Points : 2) Drag a split bar to the edge of the worksheet. Double-click a split bar. Cli

Word Count: 727
Showing Page: 1/5
Devry BIS155 week 5 quizReport this Question as InappropriateQuestion 1. 1. (TCO 5) Excel's multiple worksheet abilities can do all of the followingEXCEPT: (Points : 2)create Pivot Chartsgroup worksheets together to enter data.display worksheets side by side.create links among the worksheets.Question 2. 2. (TCO5) If several worksheets are grouped and you enter a formula in cell A10 inone of the grouped sheets: (Points : 2)the same formula is entered into all grouped worksheets.the formula changes by one row in each grouped worksheet.the formula changes by one column in each grouped worksheet.nothing happens to the other sheets.Question 3. 3. (TCO 5) If the active cell is in row 1, but not in column A, when you click theSplit command, the worksheet will appear in two ________ panes. (Points : 2)horizontaldiagonalverticalsquareQuestion 4. 4. (TCO 5) In Excel, which of the following is NOT a method for removing a splitwindow? (Points : 2)Drag a split bar to the edge of the worksheet.Double-click a split bar.Click Split in the Window group on the View tab.Right-click in the active cell and click Remove.Question 5. 5. (TCO 5) Which of the following functions do NOT work with 3Dformulas? (Points : 2)SUMVLOOKUPAVERAGECOUNTQuestion 6. 6. (TCO 5) Before you can create an external reference you must first__________. (Points : 2)select the cell or cells to hold the external reference.open the destination workbook and all source workbooks.switch to t

Review from student

Studypool Student
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors