Question: Q 1 ( 3 point ) : Use the following table to answer the questions below the table Q 1 a ( 1 point )
Q point: Use the following table to answer the questions below the table
Qa point: Format the table according to the following requirements
Merge cells B:F still call it $million";
Change the background color of cells B:F to standard yellow;
Center all the numbers in cells B:F;
Show only two decimals for "Taxes" and "Profit After Taxes" values;
Give a thick border to include all cells with number values cells B:F
Qb point: Calculate the maximum value minus the minimum over the years
for the metrics in each row. You are required to ONLY create a formula in H
Then fill down or copypaste the formula to :
Qc point: Calculate the averages of the highest values over the years
for the metrics in each row. You are required to ONLY create a formula in
Then fill down or copypaste the formula to :I
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
