Tables Assessment

This is the file needed to answer this assessment question: Tables Question 1

You are going to use a trading strategy that buys a stock when the opening price is $27 or lower and sells the stock when the opening price is $35 or higher. In the file above fill in the columns to the right using IF Statements. Assume the stock was bought at the beginning of day 1. Your formulas should automatically populate if you add new data.

This is the file needed to answer this assessment question: Tables Question 2

From the file above, construct a PivotTable and PivotChart that show the percentage of total revenue during each year earned by each person. If you add new data and refresh the PivotTable the chart and PivotTable should automatically update.

This is the file needed to answer this assessment question: Tables Question 3

From the file above , write a formula in cell G6 that tells me the name of the person with the 5th lowest salary. If I change the number in F6 then the name should change in an appropriate fashion. If new data is added, your formulas should still work.