1. (5 pts) Copy the following data (including the text header) into cells C8 to
ID: 3194803 • Letter: 1
Question
1. (5 pts) Copy the following data (including the text header) into cells C8 to C23. Then sort cells C8 to C23, ordering the data from highest to lowest with cell C9 containing the largest value and cell C23 the smallest. Sales $207.90 $415.43 $695.30 $37.98 $873.36 $231.56 $764.54 $997.18 $55.35 $652.25 $552.90 $360.99 $331.82 $83.26 $71.63 1. (5 pts) Copy the following data (including the text header) into cells C8 to C23. Then sort cells C8 to C23, ordering the data from highest to lowest with cell C9 containing the largest value and cell C23 the smallest. Sales $207.90 $415.43 $695.30 $37.98 $873.36 $231.56 $764.54 $997.18 $55.35 $652.25 $552.90 $360.99 $331.82 $83.26 $71.63Explanation / Answer
Method is quite simple. Copy the complete table and paste in excel starting at cell C8.
then use the ribbon data, and there is an option to sort it.
shortcut command in excel is Alt+A+SA
Sales $997.18 $873.36 $764.54 $695.30 $652.25 $552.90 $415.43 $360.99 $331.82 $231.56 $207.90 $83.26 $71.63 $55.35 $37.98Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.