Informational Systems Cost per unir Worksheet

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
Order Essay