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.

Transcribed Image Text:

Chrome File Edit View History Bookmarks ID PA Bo Bo Bo C Excel Book 3 - Copy - Saved Profiles Tab Window Help Wed 6:47 PM Co |;| Un 373 37 37% Bo (69 Co h Dai H.F Par MI Tex G .C+ rasmussenedu-my.sharepoint.com/:x:/r/personal/hurmat_hameed_smail_rasmussen_edu/_layouts/15/doc2.aspx?sourcedoc=%7Bd22c0159-24fc-482f-9db1-162b... Search (Option + Q) EJ Automate Help ab Wrap Text Currency Merge & Center $ % 9 .00 .0 .00 0 Conditional Format As Styles Formatting Table Alignment Number Styles File Home Insert Draw Page Layout Formulas Data Review View 25 X Cut Calibri 11 ' Copy Paste BIUD ab Format Painter Clipboard h HH Editing Share Comments Catch up Autosum T Clear Insert Delete Format Sort & Find & Filter Select Analyze Data Cells Editing Analysis Undo F9 Stock name Font fx =D9*E9 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 1500 $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 cvs 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 summary web sources Calculation Mode: Automatic Workbook Statistics H.HAMEED_P....DOCX ^ 215 NOV 16 C A 0 zoom DOCX Give Feedback to Microsoft 100% + Show All Chrome File Edit View History Bookmarks ID PA Bo Bo Bo C Excel Book 3 - Copy - Saved Profiles Tab Window Help Wed 6:47 PM Co |;| Un 373 37 37% Bo (69 Co h Dai H.F Par MI Tex G .C+ rasmussenedu-my.sharepoint.com/:x:/r/personal/hurmat_hameed_smail_rasmussen_edu/_layouts/15/doc2.aspx?sourcedoc=%7Bd22c0159-24fc-482f-9db1-162b... Search (Option + Q) EJ Automate Help ab Wrap Text Currency Merge & Center $ % 9 .00 .0 .00 0 Conditional Format As Styles Formatting Table Alignment Number Styles File Home Insert Draw Page Layout Formulas Data Review View 25 X Cut Calibri 11 ' Copy Paste BIUD ab Format Painter Clipboard h HH Editing Share Comments Catch up Autosum T Clear Insert Delete Format Sort & Find & Filter Select Analyze Data Cells Editing Analysis Undo F9 Stock name Font fx =D9*E9 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 1500 $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 cvs 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 summary web sources Calculation Mode: Automatic Workbook Statistics H.HAMEED_P....DOCX ^ 215 NOV 16 C A 0 zoom DOCX Give Feedback to Microsoft 100% + Show All