TAKE MY CLASS

BIS 155 Week 5 Quiz (Updated)

Name: Devry BIS 155 Week 5 Quiz (Updated) - Do My Class
Price: 17.00 USD
Availability: InStock

Category BIS 155 (Updated) Tags bis, bis 155, BIS 155 Week 5 Quiz (Updated), DeVry, Quiz

$17.00

Add to Cart

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.

TAKE MY CLASS

BIS 155 Week 5 Quiz (Updated)

BIS 155 Week 5 Quiz (Updated)

Hi there! Get instant help with . Without paying anything upfront.

do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods

Contact