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
 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 . 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
 ‘[New.Jersey.xlsx]Qtr4!’B6
 [New.Jersey.xlsx]Qtr4!,B6
 [NewJersey.xlsx]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?
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-my-paper-pay-someone-to-write-my-paper

do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods

Contact

Scroll to Top