Question 1. Question : <\/p>\n
(TCO 5) Excel’s multiple worksheet abilities can do all of the following EXCEPT:<\/p>\n
create Pivot Charts.<\/p>\n
group worksheets together to enter data.<\/p>\n
display worksheets side by side.<\/p>\n
IN create links among the worksheets.<\/p>\n
Comments: <\/p>\n
Question 2. Question : <\/p>\n
(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?<\/p>\n
Click the first tab, hold Shift, and then click the last tab.<\/p>\n
Click the first tab, hold Ctrl, and then click the last tab.<\/p>\n
Right-click a worksheet tab, then select Select All Sheets.<\/p>\n
Right-click a worksheet tab, then select Group.<\/p>\n
Comments: <\/p>\n
Question 3. Question : <\/p>\n
(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.<\/p>\n
horizontal<\/p>\n
IN vertical<\/p>\n
diagonal<\/p>\n
square<\/p>\n
Comments: <\/p>\n
Question 4. Question : <\/p>\n
(TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet?<\/p>\n
Drag a split box.<\/p>\n
IN Double-click a split box.<\/p>\n
Right-click in the active cell and click Split.<\/p>\n
Click Split in the Window group on the View tab.<\/p>\n
Comments: <\/p>\n
Question 5. Question : <\/p>\n
(TCO 5) Which of the following external references is for a workbook and worksheet that have no spaces?<\/p>\n
“[New.Jersey.xlsx]Qtr4!”B6<\/p>\n
‘[New.Jersey.xlsx]Qtr4!’B6<\/p>\n
IN [New.Jersey.xlsx]Qtr4!,B6<\/p>\n
[NewJersey.xlsx]Qtr4!B6<\/p>\n
Comments: <\/p>\n
Question 6. Question : <\/p>\n
(TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT:<\/p>\n
validate data in worksheets.<\/p>\n
hide worksheets.<\/p>\n
arrange windows to view multiple sheets at once.<\/p>\n
split a worksheet window to see separate sections at once.<\/p>\n
Comments: <\/p>\n
Question 7. Question : <\/p>\n
(TCO 5) Which of the following is the proper use of a 3D formula?<\/p>\n
=SUM(Yr1:Yr5!C7)<\/p>\n
IN =SUM(Yr1-Yr5!C7)<\/p>\n
=SUM(‘Yr1:Yr5’!C7)<\/p>\n
=SUM(“Yr1:Yr5”!C7)<\/p>\n
Comments: <\/p>\n
Question 8. Question : <\/p>\n
(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.<\/p>\n
two, two<\/p>\n
two, one<\/p>\n
one, two<\/p>\n
one, one<\/p>\n
Comments: <\/p>\n
Question 9. Question : <\/p>\n
(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?<\/p>\n
IN Scenario Manager<\/p>\n
Goal Seek<\/p>\n
One-variable data table<\/p>\n
Two-variable data table<\/p>\n
Comments: <\/p>\n
Question 10. Question : <\/p>\n
(TCO 6) What is the main difference between Goal Seek and variable data tables?<\/p>\n
Goal Seek produces a list of result values.<\/p>\n
Goal Seek uses the original worksheet data to change an input.<\/p>\n
Goal Seek manipulates multiple variables to produce multiple results.<\/p>\n
Goal Seek shows results in a separate table.<\/p>\n
Comments: <\/p>\n
Question 11. Question : <\/p>\n
(TCO 6) The Scenario Manager dialog box enables you to do all the following EXCEPT:<\/p>\n
format scenarios.<\/p>\n
add scenarios.<\/p>\n
IN delete scenarios.<\/p>\n
edit scenarios.<\/p>\n
Comments: <\/p>\n
Question 12. Question : <\/p>\n
(TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?<\/p>\n
Scenario Manager<\/p>\n
Goal Seek<\/p>\n
Data Table<\/p>\n
Solver<\/p>\n
Comments: <\/p>\n
Question 13. Question : <\/p>\n
(TCO 6) Which of the following is NOT one of the three parameters in Solver?<\/p>\n
IN Constraints<\/p>\n
Objective cell<\/p>\n
Changing variable cells<\/p>\n
Input value<\/p>\n
Comments: <\/p>\n
Question 14. Question : <\/p>\n
(TCO 6) Which of the following is NOT required for Solver to generate a solution?<\/p>\n
Constraints<\/p>\n
A formula that produces a value to be optimized<\/p>\n
Precedent values<\/p>\n
IN Variables that change within the specified limitations<\/p>\n
Comments: <\/p>\n
Question 15. Question : <\/p>\n
(TCO 6) The initial results of a Goal Seek are:<\/p>\n
automatically entered into the worksheet.<\/p>\n
inserted into a new worksheet.<\/p>\n
presented visually in a chart.<\/p>\n
shown in the Goal Seek Status dialog box.<\/p>\n
Comments: <\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. 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. IN create links among the worksheets. Comments: Question 2. 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-53396","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/53396","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=53396"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/53396\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=53396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=53396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=53396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}