BIS 155 Week 5 Quiz (Updated)

Share on facebook
Share on whatsapp
Share on twitter
Share on pinterest
Share on linkedin
Share on reddit
Share on skype
Share on email

BIS 155 Week 5 Quiz (Updated)


Question 1.Question :(TCO 5) The tabs of grouped worksheets are displayed with a ________ background.
Student Answer: gray


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


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 . Without paying anything upfront.


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.Jersey.xlsx]Qtr4!”B6


Question 6.Question :(TCO 5) Which formula would return the #NAME? error?
Student Answer: =SUM(B6.B12)


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


Question 9.Question :(TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables.
Student Answer: one


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


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


Question 13.Question :(TCO 6) Where is Solver located if it is already loaded onto Excel?
Student Answer: Add-Ins tab
 Formulas tab
 Analysis group on the Data tab
 Data Tools group on the Data tab


Question 14.Question :(TCO 6) Which of the following is NOT required for Solver to generate a solution?
Student Answer: Constraints
 A formula that produces a value to be optimized
 Precedent values
 Variables that change within the specified limitations


Question 15.Question :(TCO 6) The initial results of a Goal Seek are:
Student Answer: automatically entered into the worksheet.
 inserted into a new worksheet.
 presented visually in a chart.
 shown in the Goal Seek Status dialog box.




do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods


Scroll to Top