Microsoft Office Tutorials and References
In Depth Information
In the Lab
2. Right-click the range C8:C14 and then click Delete on the shortcut menu. When Excel displays
the Delete dialog box, click Shift cells left and then click the OK button. What does Excel display
in cell F8? Click cell F8 and then point to the Trace Error button that is displayed to the left of
the cell. Write down the ScreenTip that is displayed. Click the Undo button on the Quick Access
Toolbar.
3. Right-click the range C8:C14 and then click Insert on the shortcut menu. When Excel displays
the Insert dialog box, click Shift cells right and then click the OK button. What does Excel display
in the formula bar when you click cell F8? What does Excel display in the formula bar when you
click cell G8? What can you conclude about how Excel responds when you insert cells next to cells
involved in a formula? Close the workbook without saving the changes.
In the Lab
Lab 3: Analysis of Indirect Expense Allocations
Problem: Your classmate works part time as a consultant for RockieView Resort and Spa. She has asked
you to assist her in creating an indirect expense allocation worksheet (Figure 3–88) that will help the resort
and spa administration better evaluate the profi t centers described in Table 3–14 on the next page.
Figure 3–88
Continued >
 
Search JabSto ::




Custom Search