Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) The tabs of grouped worksheets are displayed with a _____ background.\tgray\tyellow\tblue\twhite\t\u00a0\tQuestion 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets:\tthe same formula is entered into all grouped worksheets.\tthe formula changes by one row in each grouped worksheet.\tthe formula changes by one column in each grouped worksheet.\tnothing happens to the other sheets.\t\u00a0\tQuestion 3. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) When two windows of the same workbook are opened, Excel adds _____ to the title bar of the second window.\tthe letter B\tthe number 2\tthe letter A\tthe number 1\t\u00a0\tQuestion 4. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet?\tDrag a split box.\tDouble-click a split box.\tRight-click in the active cell and click Split.\tClick Split in the Window group on the View tab.\t\u00a0\tQuestion 5. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces?\t“[New.Jersey.xlsx]Qtr4!”B6\t‘[New.Jersey.xlsx]Qtr4!’B6\t[New.Jersey.xlsx]Qtr4!,B6\t[NewJersey.xlsx]Qtr4!B6\t\u00a0\tQuestion 6. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) Which formula would return the #NAME? error?\t=SUM(B6.B12)\t=MAX(B6:B12)\t=AVG(B6:B12)\t=IF(A6=”Atlanta”,A3,0)\t\u00a0\tQuestion 7. \ufffd Question : \ufffd\u00a0\u00a0 (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)?\tA1\tA2\tA3\tA1 & A2\t\u00a0\tQuestion 8. \ufffd Question : \ufffd\u00a0\u00a0 (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.\ttwo, two\ttwo, one\tone, two\tone, one\t\u00a0\tQuestion 9. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?\tScenario Manager\tGoal Seek\tOne-variable data table\tTwo-variable data table\t\u00a0\tQuestion 10.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (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\tenter the cell references in the Column input cell box.\tenter the cell references in the Row input cell box.\tclick the What-If analysis command.\tdrag to select the data table boundaries.\t\u00a0\tQuestion 11.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 6) The Goal Seek command is located in the _____ command on the Data tab.\tWhat-If Analysis\tData Validation\tConsolidate\tAdvanced\t\u00a0\tQuestion 12.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the\tscenario names.\tformatting of the results.\tcells containing the formulas that generate the results.\tfinal result.\t\u00a0\tQuestion 13.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 6) Where is Solver located if it is already loaded onto Excel?\tAdd-Ins tab\tFormulas tab\tAnalysis group on the Data tab\tData Tools group on the Data tab\t\u00a0\tQuestion 14.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box?\tAdd\tFormat\tChange\tDelete\t\u00a0\tQuestion 15.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 6) Which of the following has to be loaded onto Excel?\tGoal Seek\tSolver\tScenario Manager\tData Tables<\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) The tabs of grouped worksheets are displayed with a _____ background. gray yellow blue white \u00a0 Question 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 5) If several worksheets are grouped and you enter Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-202958","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=202958"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202958\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}