Question<\/p>\n
1. Question : (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
create links among the worksheets.<\/p>\n
Question 2. Question : (TCO 5) In Excel, which of the following would you perform to group nonadjacent 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 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
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.<\/p>\n
horizontal<\/p>\n
vertical<\/p>\n
diagonal<\/p>\n
square<\/p>\n
Question 4. Question : (TCO 5) In Excel, which of the following is NOT a method for removing a split window?<\/p>\n
Drag a split bar to the edge of the worksheet.<\/p>\n
Double-click a split bar.<\/p>\n
Click Split in the Window group on the View tab.<\/p>\n
Right-click in the active cell and click Remove.<\/p>\n
Question 5. Question : (TCO 5) Which of the following functions do NOT work with 3D formulas?<\/p>\n
SUM<\/p>\n
VLOOKUP<\/p>\n
AVERAGE<\/p>\n
COUNT<\/p>\n
Question 6. Question : (TCO 5) Before you can create an external reference you must first __________.<\/p>\n
select the cell or cells to hold the external reference.<\/p>\n
open the destination workbook and all source workbooks.<\/p>\n
switch to the source workbooks and click the cells.<\/p>\n
click on Insert Function on the Formulas tab.<\/p>\n
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)?<\/p>\n
A1<\/p>\n
A2<\/p>\n
A3<\/p>\n
A1 & A2<\/p>\n
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.<\/p>\n
two, two<\/p>\n
two, one<\/p>\n
one, two<\/p>\n
one, one<\/p>\n
Question 9. Question : (TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables.<\/p>\n
one<\/p>\n
two<\/p>\n
three<\/p>\n
four<\/p>\n
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?<\/p>\n
Scenario Manager<\/p>\n
Solver<\/p>\n
Data Table<\/p>\n
Goal Seek<\/p>\n
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.<\/p>\n
Set cell<\/p>\n
By changing cell<\/p>\n
To value<\/p>\n
Goal<\/p>\n
Question 12. Question : (TCO 6) After creating a scenario summary report, it is recommended that you do all the following EXCEPT:<\/p>\n
delete blank row 1 and blank column A.<\/p>\n
change the colors of the title row.<\/p>\n
replace cell references with descriptive labels in the first column.<\/p>\n
replace the explanatory paragraph below the table with a narrative explaining the report.<\/p>\n
Question 13. Question : (TCO 6) Which of the following is NOT one of the three parameters in Solver?<\/p>\n
Constraints<\/p>\n
Objective cell<\/p>\n
Changing variable cells<\/p>\n
Input value<\/p>\n
Question 14. Question : (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
Variables that change within the specified limitations<\/p>\n
Question 15. Question : (TCO 6) Which of the following has to be loaded onto Excel?<\/p>\n
Goal Seek<\/p>\n
Solver<\/p>\n
Scenario Manager<\/p>\n
Data Tables<\/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. create links among the worksheets. Question 2. Question : 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-119832","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/119832","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=119832"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/119832\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=119832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=119832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=119832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}