Question 1. | Question : | (TCO 5) The tabs of grouped worksheets are displayed with a ________ background. |
| | Student Answer: | | gray | | | | yellow | | | | blue | | | | white | | | |
| |
Question 2. | Question : | (TCO 5) In Excel, which of the following would you perform to group adjacent worksheets? |
| | Student Answer: | | 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) 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. |
| | Student Answer: | | horizontal | | | | vertical | | | | diagonal | | | | square | | | |
| |
Question 4. | Question : | (TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet? |
| | Student Answer: | | Drag a split box. | | | | Double-click a split box. | | | | Right-click in the active cell and click Split. | | | | Click Split in the Window group on the View tab. | | | |
| |
Question 5. | Question : | (TCO 5) Which of the following external references is correct for a workbook and worksheet that have no spaces? |
| | Student Answer: | | “[New.Jersey.xlsx]Qtr4!”B6 | | | | ‘[New.Jersey.xlsx]Qtr4!’B6 | | | | [New.Jersey.xlsx]Qtr4!,B6 | | | | [NewJersey.xlsx]Qtr4!B6 | | | |
| |
Question 6. | Question : | (TCO 5) Which formula would return the #NAME? error? |
| | Student Answer: | | =SUM(B6.B12) | | | | =MAX(B6:B12) | | | | =AVG(B6:B12) | | | | =IF(A6=”Atlanta”,A3,0) | | | |
| |
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)? |
| | Student Answer: | | A1 | | | | A2 | | | | A3 | | | | A1 & A2 | | | |
| |
Question 8. | Question : | (TCO 6) In a what-if analysis of a car purchase, the original interest rates of 6% and 5%, 5.5% and 6.5% are the ________ values. |
| | Student Answer: | | substitution | | | | proxy | | | | alternative | | | | replacement | | | |
| |
Question 9. | Question : | (TCO 6) A two-variable data table returns ________ result(s) for each combination of two variables. |
| | Student Answer: | | one | | | | two | | | | three | | | | four | | | |
| |
Question 10. | Question : | (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: |
| | Student Answer: | | enter the cell references in the Column input cell box. | | | | enter the cell references in the Row input cell box. | | | | click the What-If Analysis command. | | | | drag to select the data table boundaries. | | | |
| |
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. |
| | Student Answer: | | Set cell | | | | By changing cell | | | | To value | | | | Goal | | | |
| |
Question 12. | Question : | (TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab? |
| | Student Answer: | | Scenario Manager | | | | Goal Seek | | | | Data Table | | | | Solver | | | |
| |
Question 13. | Question : | (TCO 6) Where is Solver located if it is already loaded onto Excel? |
| | Student Answer: | | Add-Ins tab | | | | Formulas tab | | | | Analysis group on the Data tab | | | | Data Tools group on the Data tab | | | |
| |
Question 14. | Question : | (TCO 6) Which of the following is NOT required for Solver to generate a solution? |
| | Student Answer: | | Constraints | | | | A formula that produces a value to be optimized | | | | Precedent values | | | | Variables that change within the specified limitations | | | |
| |
Question 15. | Question : | (TCO 6) The initial results of a Goal Seek are: |
| | Student Answer: | | automatically entered into the worksheet. | | | | inserted into a new worksheet. | | | | presented visually in a chart. | | | | shown in the Goal Seek Status dialog box. | | | |
| |
|