Question
The attached Excel files ask you to write simple formulas in cells: In StockWatcher create formulas in cells F4 to F9 that calculate percentage gains
The attached Excel files ask you to write simple formulas in cells:
In StockWatcher create formulas in cells F4 to F9 that calculate percentage gains based on purchase price in C column cells and current sales prices from the D column. Remember that (last price - current price divided by last price) is the algebraic formula. Which stock had the highest gain?
In MusicPlayerz, write formulas in Gross Sales and Profit cells. Gross Sales is (Price multiplied by Projected Sales). Profit is (Actual Sales multiplied by the difference between Price and Cost). The % of Sales should calculate and tell you which is your top profit maker. Which is?
In TotalMischief, I want a graph that shows Regional Sales by Quarter. Hint: highlight the cells A3:E7 and then select Insert followed by the appropriate one from Recommended Charts.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started