Question: table [ [ C , D , E , F , G , H , I,J , K ] , [ Name , Last

\table[[C,D,E,F,G,H,I,J,K],[Name,Last Price,Chg,% Chg,Volume,Qty,Yield,P/E Ratio,Current Value],[Primoris Services,$62.97,($0.78),2.15,-1.22%,400,4.4,22.5,],[Netflix,$756.73,$2.99,2.64,0.40%,500,4.35,42.65,],[Costco Wholesale,$874.60,($4.49),0.32,-0.51%,200,4.18,53.07,],[Apple,$227.28,($2.82),0.19,-1.22%,200,3.46,35.03,],[Tesla,$250.61,($6.94),0.93,-2.69%,200,3.84,70.62,],[Home Depot,$394.04,$1.52,3.55,0.39%,350,4.53,26.41,],[Berkshire Hathaway Class B,$453.77,($1.19),1.32,-0.26%,250,3.22,14.47,],[Amazon,$186.27,($6.46),0.91,-3.35%,500,3.55,46.18,],[Verizon Communications,$42.34,$1.06,1.82,2.56%,500,3.44,17.79,],[McDonald's,$293.85,$2.33,0.86,0.80%,200,4.63,25.59,],[Microsoft,$409.50,($23.03),1.67,-5.32%,200,3.95,36.66,],[Coca-Cola,$65.76,($0.16),0.19,-0.25%,1000,4.37,27.37,]]
Use formulas to populate the Current Value column
 \table[[C,D,E,F,G,H,I,J,K],[Name,Last Price,Chg,% Chg,Volume,Qty,Yield,P/E Ratio,Current Value],[Primoris Services,$62.97,($0.78),2.15,-1.22%,400,4.4,22.5,],[Netflix,$756.73,$2.99,2.64,0.40%,500,4.35,42.65,],[Costco Wholesale,$874.60,($4.49),0.32,-0.51%,200,4.18,53.07,],[Apple,$227.28,($2.82),0.19,-1.22%,200,3.46,35.03,],[Tesla,$250.61,($6.94),0.93,-2.69%,200,3.84,70.62,],[Home Depot,$394.04,$1.52,3.55,0.39%,350,4.53,26.41,],[Berkshire Hathaway Class B,$453.77,($1.19),1.32,-0.26%,250,3.22,14.47,],[Amazon,$186.27,($6.46),0.91,-3.35%,500,3.55,46.18,],[Verizon

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!