1. Use the SUM function to add the cost paid for each stock in your portfolio.
2. Find the AVERAGE, MINIMUM, and MAXIMUM (using the appropriate functions) of:
3. number of stocks purchased
4. purchase price of each stock
5. price paid for all stocks in your portfolio
6. Perform a simple conditional analysis by using at least one logical function (i.e., IF, AND, OR...). Apply the test on only cells that contain data. For example, show whether the purchase price of one stock is higher or lower than the average purchase price of all stocks in your portfolio. In the column header to the right of your logical function, briefly explain the test being performed.
7. Enter the function labels (SUM, AVERAGE, etc.) in the cells adjacent to the calculations so that a reader can easily tell what calculations are present in the worksheet.

Chrome File Edit View History Bookmarks Profiles Tab Window Help O Wed 6:47 PM . . . ID PAI X BO * Bo * Bo X BO X BO x Co | Un * 37: * 37: * 37 4 BO (6 * Co f Da E H. Pa # M| | 4 Te G . C . C a rasmussenedu-my.sharepoint.com/:x:/r/personal/hurmat_hameed_smail_rasmussen_edu/_layouts/15/doc2.aspx?sourcedoc=%7Bd22c0159-24fc-482f-9db1-162b... ( * * = h . .. Excel Book 3 - Copy - Saved Search (Option + Q) HH File Home Insert Draw Page Layout Formulas Data Review View Automate Help Editing Share Comments Catch up & Cut [ AutoSum AY Calibri V 11 " A" A de Wrap Text Currency [A Copy Clear BIUDab VA Insert Delete Format Sort & Find & Paste Merge & Center $ ~ % 9 08 28 Conditional Format As Styles Analyze Filter Select Format Painter Formatting Table Data Undo Clipboard Alignment Number Cells Analysis Font Styles Editing F9 " X V fx =D9*E9 Stock name tTcker Symbol Purchase Date # Of Shares Purchased Purchase Price Total Paid Current Stock Price Current Stock Value Money Made/ Lost amazon inc amzn 4/1/2022 1000 $101.00 $101,000.00 tesla inc tsla 5/6/2022 500 $195.00 $292,500.00 facebook inc fb 10/5/2022 1300 $42.00 $54,600.00 walmart wmt 5/8/2022 1500 $142.00 $213,000.00 vs inc CVS 7/7/2022 1600 $97.20 $155,520.00 berkshire hathway inc BRK_A 8/6/2022 1700 $457.67 $778,030.50 apple inc aapl 9/6/2022 1800 $148.00 $266,400.00 Capital one COF 10/7/2022 1900 $103.56 $196,764.00 chipotle mexican grill inc cmg 6/9/2022 2500 $1,506.00 $3,765,000.00 starbucks corp SBUX 5/8/2022 5000 $97.38 $486,900.00 0 summary web sources + Give Feedback to Microsoft - 100% + Calculation Mode: Automatic Workbook Statistics Show All X H.HAMEED_ P...DOCX 9 215 16 zoom