1) Below are the monthly returns in the stock price for Companies "A"-"E" Name the ranges containing the monthly returns for each stock (5 Points) as "CO_A", "CO_B", etc.
2) Compute the average monthly return on each stock in Row 9.
3) Change the "Date" column to the format "mm/dd/yy". Change the averages and monthly returns of the stocks to the format of "0.00%".
1) Put FORMULAS in the indicated blocks to compute the following. Make sure you format the results appropriately ($, %, etc.)
2) Complete the VLOOKUP problem at the end
Formatting and Functions
1. Take the text in cell A7 (above) and format it so that it is Bold, Italicized, Underlined, 16 Point Font and Centered across cells A7:J7.
2. Write a random number generator (in cell J11) that will create a number (no decimals) between 1 and 1000:
3. Copy that for 9 more rows so you have 10 random numbers and name the range "RandomNums".
Format the random numbers as Dollars with no decimals
PLEASE NOTE
If you are unable to complete the random number generator, then please enter 10 of your own made up random numbers, but you will not get credit for Problem 2.
The following amounts should update when the random numbers above change:
4. Count how many times the 10 random numbers above is equal to or greater than 500.
5. Sum the 10 random numbers above that are equal to or greater than 500.
6. What are the average, minimum, maximum, sum, and median values of the random numbers?
7. Based on the response for #4, what is the corresponding color from the table above ...
Using the VLOOKUP function:
Using the data below apply the following formats:
1) Using conditional formatting, format in green each sales increase over the previous month and red each month in which the sales decreased.
2) What is the Max and the Min? Answers in cells G11 and G12.
3) Using conditional formatting applied to all cells, make the Sales value that corresponds to the Max show as bold and blue font cell background as yellow.
Use the data in columns H-L, and complete the table below:
1) Determine the total number of units and dollar volume sold for each product.
2) Determine the total revenue earned before December 10, 2005.
3) How many units were sold by people other than Collette?
4) How many units of makeup were sold between January 15, 2004, and February 15, 2005?
1) How many songs were not sung by Britney Spears?
2) How many songs were sung before June 15, 2004?
3) How many songs were sung between June 1, 2004 and July 4, 2006?
4) How many songs were sung by singers whose last name begins with M?
5) How many songs were sung by singers whose names contain an "e"?
1) Below is data containing employee ID Codes, Salaries, and Years of Experience. Write a formula in cell H14 that takes a given ID Code in cell G14 and yields the employee's salary.
2) Write another formula in cell I14 that takes the given ID Code and yields the employee's years of experience.
Attachment:- Assignment.xlsx