CIS 150 PRACTICE 07 EXCEL CHAPTER 2 QUESTIONS AND ANSWERS
Enter a formula in the selected cell to calculate the value of cell E9 times 3. - CORRECT
ANSWER✅✅Type =E9*3. Press Enter.
On the Summary sheet, in cell B3, enter a formula to display the value of cell B3 from the ByMonth
sheet. - CORRECT ANSWER✅✅Type = and then click the ByMonth sheet tab. Click cell B3. Press Enter.
Edit the formula in cell B9 so the references to cell E2 will update when the formula is copied, and the
reference to cell B8 will remain constant. Use AutoFill to copy the formula to cells B10:B12. - CORRECT
ANSWER✅✅Double-click cell B9 to edit the formula. Change the formula to be =E2*$B$8). Press Enter.
Click the Fill Handle tool and drag down to cell B12. Release the mouse button.
Enter a formula in the selected cell to display the value of cell E3. - CORRECT ANSWER✅✅Type =E3.
Press Enter.
Use the Create from Selection command to create named ranges for the data table B8:E11 using the
labels in row 1 as the basis for the names. - CORRECT ANSWER✅✅On the Formulas tab, in the Defined
Names group, click the Create from Selection button. The Top row check box is checked by default. Click
OK.
There is an error in cell D6. Accept Excel's suggestion for fixing the error. - CORRECT ANSWER✅✅Click
cell D6. Click the Smart Tag. Click Copy Formula from Above.
Display the formulas in this worksheet. - CORRECT ANSWER✅✅On the Formulas tab in the Formula
Auditing group, click the Show Formulas button.
Hide the formulas in this worksheet and display the values instead. - CORRECT ANSWER✅✅On the
Formulas tab in the Formula Auditing group, click the Show Formulas button to hide the formulas.
Show the tracer arrows from cell B5 to the cell(s) that are dependent on it (cells containing formulas
that reference the value or formula in cell B5). - CORRECT ANSWER✅✅On the Formulas tab, in the
Formula Auditing group, click the Trace Dependents button.
Enter a formula in the selected cell to calculate the value of cell E9 times 3. - CORRECT
ANSWER✅✅Type =E9*3. Press Enter.
On the Summary sheet, in cell B3, enter a formula to display the value of cell B3 from the ByMonth
sheet. - CORRECT ANSWER✅✅Type = and then click the ByMonth sheet tab. Click cell B3. Press Enter.
Edit the formula in cell B9 so the references to cell E2 will update when the formula is copied, and the
reference to cell B8 will remain constant. Use AutoFill to copy the formula to cells B10:B12. - CORRECT
ANSWER✅✅Double-click cell B9 to edit the formula. Change the formula to be =E2*$B$8). Press Enter.
Click the Fill Handle tool and drag down to cell B12. Release the mouse button.
Enter a formula in the selected cell to display the value of cell E3. - CORRECT ANSWER✅✅Type =E3.
Press Enter.
Use the Create from Selection command to create named ranges for the data table B8:E11 using the
labels in row 1 as the basis for the names. - CORRECT ANSWER✅✅On the Formulas tab, in the Defined
Names group, click the Create from Selection button. The Top row check box is checked by default. Click
OK.
There is an error in cell D6. Accept Excel's suggestion for fixing the error. - CORRECT ANSWER✅✅Click
cell D6. Click the Smart Tag. Click Copy Formula from Above.
Display the formulas in this worksheet. - CORRECT ANSWER✅✅On the Formulas tab in the Formula
Auditing group, click the Show Formulas button.
Hide the formulas in this worksheet and display the values instead. - CORRECT ANSWER✅✅On the
Formulas tab in the Formula Auditing group, click the Show Formulas button to hide the formulas.
Show the tracer arrows from cell B5 to the cell(s) that are dependent on it (cells containing formulas
that reference the value or formula in cell B5). - CORRECT ANSWER✅✅On the Formulas tab, in the
Formula Auditing group, click the Trace Dependents button.
