Question: Q 1 ( 3 point ) : Use the following table to answer the questions below the table Q 1 a ( 1 point )

Q1(3 point): Use the following table to answer the questions below the table
Q1a (1 point): Format the table according to the following requirements
Merge cells B4:F4, still call it "$million";
Change the background color of cells B5:F5 to standard yellow;
Center all the numbers in cells B6:F10;
Show only two decimals for "Taxes" and "Profit After Taxes" values;
Give a thick border to include all cells with number values (cells B6:F10).
Q1b (1 point): Calculate the maximum value minus the minimum (over the 5 years )
for the metrics in each row. You are required to ONLY create a formula in H6.
Then fill down (or copy/paste) the formula to H7 : H10.
Q1c (1 point): Calculate the averages of the 3 highest values (over the 5 years)
for the metrics in each row. You are required to ONLY create a formula in 16.
Then fill down (or copy/paste) the formula to 17:I10.
 Q1(3 point): Use the following table to answer the questions below

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 Databases Questions!