Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. Use a function in cell C14 that finds the highest sales in C5:C10 and copy to D14 (for all three sheets). Format Sales to

image text in transcribed8. Use a function in cell C14 that finds the highest sales in C5:C10 and copy to D14 (for all three sheets). Format Sales to currency, 0 dec; format No. Sold to number, 0 dec. Please figure this out

Green Thumb Nursery - Killeen \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ January Sales } \\ \hline Tree & Type & Sales & No. Sold \\ \hline Live oak & Evergreen & $700 & 18 \\ \hline Fringe Tree & Deciduous & $275 & 17 \\ \hline Mimosa & Deciduous & $300 & 16 \\ \hline Southern Magnolia & Evergreen & $210 & 4 \\ \hline Pecan & Deciduous & $500 & 32 \\ \hline American Holly & Evergreen & $195 & 6 \\ \hline Total & & $2,180 & 93 \\ \hline Average & & $623 & 27 \\ \hline \multicolumn{4}{|l|}{ Lowest } \\ \hline Highest & & & \\ \hline \end{tabular}

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

Multinational Financial Management

Authors: Alan C. Shapiro

7th Edition

0471395307, 9780471395300

More Books

Students also viewed these Finance questions

Question

=+Describe your point of view.

Answered: 1 week ago