Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions