BIS 155 Week 5 Quiz (Updated)DeVry University

(TCO 5) The tabs of grouped worksheets are displayed with a ________ background. Student Answer: gray yellow blue white Question 2. Question : (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? Student Answer: Click the first tab, hold Shift, and then click the last tab. Click the first tab, hold Ctrl, and then click the last tab. Right-click a worksheet tab, then select Select All Sheets. Right-click a worksheet tab, then select Group. Question 3. Question : (TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes. Student Answer: horizontal vertical diagonal square Question 4. Question : (TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet? Student Answer: Drag a split box. Double-click a split box. Right-click in the active cell and click Split. Click Split in the Window group on the View tab. Hi there! Get instant help with BIS 155 Week 5 Quiz (Updated) Without paying anything upfront. FREE QUOTE Question 5. Question : (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces? Student Answer: “[New.J]Qtr4!”B6 ‘[New.J]Qtr4!’B6 [New.J]Qtr4!,B6 [NewJ]Qtr4!B6 Question 6. Question : (TCO 5) Which formula would return the #NAME? error? Student Answer: =SUM(B6.B12) =MAX(B6:B12) =AVG(B6:B12) =IF(A6=”Atlanta”,A3,0) Question 7. Question : (TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)? Student Answer: A1 A2 A3 A1 & A2 Question 8. Question : (TCO 6) In a what-if analysis of a car purchase, the original interest rates of 6% and 5%, 5.5% and 6.5% are the ________ values. Student Answer: substitution proxy alternative replacement Question 9. Question : (TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables. Student Answer: one two three four Question 10. Question : (TCO 6) After entering the substitution values and the reference to a formula, the next step to complete a two-variable data table and view the results is to: Student Answer: enter the cell references in the Column input cell box. enter the cell references in the Row input cell box. click the What-If Analysis command. drag to select the data table boundaries. Question 11. Question : (TCO 6) The value you want to achieve in Goal Seek needs to be entered in the ________ box in the Goal Seek dialog box. Student Answer: Set cell By changing cell To value Goal Question 12. Question : (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? Student Answer: Scenario Manager Goal Seek Data Table Solver Question 13. Question : (TCO 6) Where is Solver located if it is already loaded onto Excel?