New Perspectives Excel 2013 Tutorial 1: SAM Project 1a 1

New Perspectives Excel 2013 Tutorial 1: SAM Project 1a

1. 

On the Expenses Detail worksheet, cut the contents of the range B1:B3

and paste them into the range A1:A3.

2. 

Add outside borders to the range A5:D5.

3. 

Change the width of column C to 16.00.

4. 

Select cell B6 and then edit the cell content to be 125.24.

5. 

Enter the values shown in Table 1 into the corresponding cells in the

range B20:B25.

6. 

Select cell A26 and then enter the word Total. Add cell borders to the

range A26:B26 using the All Borders border format.

7. 

In cell B26, use the SUM function to create totals for the data in the

range B6:B25.

8. 

In cell D6, type TCM, in cell D7, type KTT, and then use Flash Fill to

automatically enter codes in the range D8:D25.

9. 

Zoom out to 90% on the Expenses Detail worksheet.

10. 

On the Expenses by Salesperson worksheet, change the orientation to

landscape. (Note: Do not change the orientation of the Expenses Detail

worksheet.)

11. 

In cell A2, edit the cell content to read Sales Team Expenses by

12. 

In the Expenses by Salesperson worksheet, manually change the height

of row 3 to 15.00. (Hint: Do not use AutoFit.)

13. 

In cell A5, edit the cell content to read Salesperson.

14. 

Change the width of column D to 19.00.

15. 

Enter the values shown in Table 2 into the corresponding cells in the

range A6:A10.

16. 

In the cell D6, enter a formula to determine the Non-Travel Expenses,

where the Non-Travel Expenses equals the Total Expenses (cell B6) minus

the Travel Expenses (cell C6).

17. 

Copy the formula you created in cell D6 to the range D7:D10.

18. 

In cell A12, delete the text As of April 30, 2016.

19. 

Apply the wrap text formatting to cell A13. (Note: You may need to adjust

the height of row 13 to make all the wrapped text visible.)

20. 

Zoom in to 110% on the Expenses by Salesperson worksheet. (Note:

Leave the zoom at 90% for the Expenses Detail worksheet.)

21. 

Move the Expenses Detail worksheet to the left of the Expenses by

Salesperson worksheet. (Tip: The Expenses Detail worksheet should be

between the Documentation and the Expenses by Salesperson)

22. 

Insert a new worksheet in the workbook, rename the worksheet Expenses

by Category, and move the new worksheet to the end of the workbook.