Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please enter the following worksheet. Be sure to align the column headings (Shares, Price, and Total) on the right sides of the cells and enter

image text in transcribed

Please enter the following worksheet. Be sure to align the column headings (Shares, Price, and Total) on the right sides of the cells and enter the formulas for column E for the Totals for E6, E7, E8, and El 0. Format the cells as shown. (a) The Stocks were purchased for the following amounts: Apple 184.90, Exxon 66.57, and Google 465.24. Add a new column that lists the purchase price for each. Add a column that shows our total original investment in each stock and a column that indicates the amount of money we have gained (or lost) on each stock since we purchased it. Finally, add another column that indicates the percentage gain or loss from the purchase price. Your formulas should work whatever the values in the cells. Format the numbers in this column as percentages with two decimal places. (b) Add Validation to the cells for the current prices per share so that a user must enter a positive number or be given an error message. Test the validation by trying to enter a negative current share price for Google. (c) Spend some time formatting the worksheet so it looks nice. Include different colors or shades for different cells. Include different fonts of different sizes and styles. (d) Conditionally format the cells that contain the amount of money gained or lost on each stock with different colors. Now conditionally format the cells that contain percentage gains

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions