Answered step by step
Verified Expert Solution
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
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 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started