Excel Practice 4
Here is a video demonstrating the skills in this practice. Please note it does not exactly match the instructions:
Complete the following Practice Activity and submit your completed project.
For Excel Practice 4, we will continue to use Excel to manage the technology Inventory at the college. Key skills in this practice are Creating a Summary Sheet, Multiple Worksheets, Headers and Footers.
- Start Excel. Click Open, then Browse to where your data files are saved. We will continue working on the same spreadsheet as Excel Practice 3.
Name the workbook as Yourlastname_Yourfirstname_Excel_Practice_4.
- Rename Sheet1 to Inventory. To rename a sheet, right click on Sheet1 and select Rename (or double-click on the sheet tab). Type Inventory and then press Enter.
- Change the Tab Color to Red, Accent 6. To change the color of the sheet, right click on the sheet name and select Tab Color and then choose Red, Accent 6. Again, right-click the sheet tab, then choose Tab Color and select the color to apply.
- Check to see if there is a Sheet2. If not, click the plus button next to the Inventory Sheet. This will add a new blank sheet, called Sheet1. Notice how the sheet names are automatically numbered in sequential order.
- Rename this sheet to Summary using the same method you used to change the Inventory sheet name.
- Change the Tab Color to Aqua, Accent 1.
- Click the plus button to add another Sheet. Notice how this one is automatically called Sheet2. Right click on Sheet2 and select Delete.
- On the Inventory tab, in cell A2, change the date format to Long Date. The Data format is on the Home Tab, in the number group. Choose the arrow next to Number Format and select Long Date.
- On the Summary Tab, Type Summary in cell A1 and the press Enter. We will use the Summary Tab to create a Summary Sheet.
- In cell A2, clear the formats. To clear the format, go to the Home Tab, in the Editing Group, choose the arrow next to Clear. Choose Clear All.
- In cell A2, type Total Quantity and then press Enter.
- In cell A3, type Average Price and then press Enter.
- In cell A4 type Highest Price and then press Enter.
- AutoFit the content of Column A.
- On the Summary Tab, in Cell B2, type =, then select the Inventory tab and click inside cell B26 and press Enter. This will create a reference from the Summary Sheet to the Inventory Sheet. Verify in cell B2 on the Summary sheet that your formula looks like this: =Inventory!B26. You should see the displayed value of 735 in cell B2 on the Summary Tab.
- On the Summary Tab, in Cell B3, type =, then select the Inventory tab and click inside cell B27 and press Enter. This will create a reference from the Summary Sheet to the Inventory Sheet. Verify in cell B3 on the Summary sheet that your formula looks like this: =Inventory!B27. You should see the displayed value of 910.05 in cell B3 on the Summary Tab.
- On the Summary Tab, in Cell B4, type =, then select the Inventory tab and click inside cell B30 and p