#### Details of this Paper

##### DEVRY BIS155 week 5 quiz-Which of the following is the proper use of a 3D formula

Description

solution

Question

(TCO 5) Excel's multiple worksheet abilities can do all of the following EXCEPT;create Pivot Charts.;group worksheets together to enter data.;display worksheets side by side.;create links among the worksheets.;Question 2. Question;(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?;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) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window.;the letter B;the number 2;the letter A;the number 1;Question 4. Question;(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening the ________ file.;worksheet;workspace;workview;worklink;Question 5. Question;(TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?;[New.Jersey.xlsx]Qtr4!"B6;[New.Jersey.xlsx]Qtr4!'B6;[New.Jersey.xlsx]Qtr4!,B6;[NewJersey.xlsx]Qtr4!B6;Question 6. Question;(TCO 5) Before you can create an external reference you must first __________.;select the cell or cells to hold the external reference.;open the destination workbook and all source workbooks.;switch to the source workbooks and click the cells.;click on Insert Function on the Formulas tab.;Question 7. Question;(TCO 5) Which of the following is the proper use of a 3D formula?;=SUM(Yr1:Yr5!C7);=SUM(Yr1-Yr5!C7);=SUM('Yr1:Yr5'!C7);=SUM("Yr1:Yr5"!C7);Question 8. Question;(TCO 6) A one-variable data table must have at least ________ blank row(s) and ________ blank column(s) between the dataset and the data table.;two, two;two, one;one, two;one, one;Question 9. Question;(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?;Scenario Manager;Goal Seek;One-variable data table;Two-variable data table;Question 10. Question;(TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only \$350 a month?;Scenario Manager;Solver;Data Table;Goal Seek;Question 11. Question;(TCO 6) The Scenario Manager dialog box enables you to do all the following EXCEPT;format scenarios.;add scenarios.;delete scenarios.;edit scenarios.;Question 12. Question;(TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the;scenario names.;formatting of the results.;cells containing the formulas that generate the results.;final result.;Question 13. Question;(TCO 6) What happens when you add a new scenario and generate a new scenario summary report?;The new report will be created on a new worksheet.;The new scenario will be included into the old report.;The new report will be added directly below the original report.;The new report will replace the original report.;Question 14. Question;(TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?;Add;Format;Change;Delete;Question 15. Question;(TCO 6) The initial results of a Goal Seek are;automatically entered into the worksheet.;inserted into a new worksheet.;presented visually in a chart.;shown in the Goal Seek Status dialog box.

Paper#30091 | Written in 18-Jul-2015

Price : \$34