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#36897 | Written in 18-Jul-2015Price : $19