Question Description
| 1 | Start Excel. Download and open the file named EXP19_Excel_Ch04_HOEAssessment_Investments.xlsx. Grader has automatically added your last name to the beginning of the filename. | 0 |
| 2 | Create a table named Transactions based on the data in the Range A4:E248. | 10 |
| 3 | Freeze the first row containing column headings. | 5 |
| 4 | Apply White, Table Style Medium 4. | 5 |
| 5 | Add a new column named Percent Change. | 4 |
| 6 | Enter a formula in the Percent Change column using unqualified structured references to calculate the percent change between the commodity purchase price and the current price. (Purchase Price/Current Price). | 8 |
| 7 | Apply Percentage Number format to the range F5:F248. | 8 |
| 8 | Add a Total Row to the Percent Change column. Set the totals to display the average of percent change column. | 10 |
| 9 | Apply Solid Blue Data Bars formatting to the Percent Change column. | 12 |
| 10 | Filter the data to only display Stocks and Bonds. | 8 |
| 11 | Sort the data by Broker, then by Commodity, then by Purchase Price. | 12 |
| 12 | Click and drag to set the range A4:F249, which is the Transactions table, as a print area. Be sure the value [#All] follows the table name in the Print area box. | 8 |
| 13 | Set row 4 to repeat when printed. | 10 |
| 14 | Save and close EXP19_Excel_Ch04_HOEAssessment_Investments.xlsx. Exit Excel. Submit the file as directed. | 0 |
Don't use plagiarized sources. Get Your Custom Essay on
Informational Systems Cost per unir Worksheet
Just from $13/Page