Prefer to watch and learn? Check out this video tutorial:
Prefer to watch and learn? Check out this video tutorial:
Complete the following Practice Activity and submit your completed project.
For Excel Practice 2, we will use Excel to create an inventory of computer items donated to be refurbished and checked out by students. Key skills in this practice are entering data in a range, using arithmetic operators, quick analysis tool, and absolute and relative cell references,
- Start Excel. Click Blank Workbook.
Name the workbook as Yourlastname_Yourfirstname_Excel_Practice_2.
- In cell A1, type ‘Inventory of Donated Computers and Devices’ and press Enter.
- Type ‘Items to be Refurbished’ in cell A2.
- In cell B3 Type ‘Quantity’ and press Tab. The word Quantity is a label. Labels are used to describe and identify data in a spreadsheet.
- In cell C3 type Retail Price and press Tab.
- In cell D3 type Additional Cost and press Tab.
- In cell E3 type Total Value and press Tab.
- In cell F3 type Percent of Total Retail Value and press Enter.
- In cell A4, type ‘2017 Dell Laptop’ and then press Enter.
- Apply the autofit column width to all cells. This is found in the cells grouping on the home tab, format options.
- Select the range A5:A8 and type the following row titles, pressing Enter after each one:
- 2012 Apple iPad
- 2019 HP Laptop
- 2020 MacBook Pro
- Total Value for All Products
- Notice how when a range is selected, data can be quickly entered by using the Enter key within just that range of cells that is selected.
- Adjust column A to the width of 59.22 (420 pixels).
- Merge and Center the text in the range A1:F1 and then apply the Title style.
- Merge and Center the text in the range A2:F2 and then apply the Heading 2 style.
- Check Spelling for the entire worksheet, making necessary corrections. To check the spelling, go to the Review Tab, Proofing group, and choose Spelling. You can also use the shortcut key of F7.
- Select the range B4:D7.
- Pressing Enter after each entry with B4 as the starting “active” cell in the range, type the following:
- 10
- 30
- 17
- 7
- With cell C4 active, continue to type the following values, pressing Enter after each:
Retail Price Additional Cost 250 82 200 61<PHONE_NUMBER> 92 - In cell E4, type =b4*c4 and click the Enter button on the Formula Bar (the checkmark). Click in cell E4 and drag the fill handle down to cell E7. Note that the cell reference can be typed in uppercase or lower case when manually typing in a formula. The * is an operator used to multiply two values. In this formula, we are taking the quantity and multiplying it by the retail price to give us the total value.
- Select the range B4:B7 and apply the comma number style with zero decimals. The comma style is located on the Home Tab, Number Group, Comma. In the same location, click the decrease decimal button twice to remove all decimals.
- Select the range E4:E7 and notice how at the bottom of your screen, the values for Average, Count, and Sum are displayed in Excel’s Status Bar. If you right cl