Question ID: 1142 11/25
PREVIOUS QUESTION NEXT QUESTION

Sort all data of the Competiton1 worksheet firstly by Salesman then by District and lastly by Total. All fields should be sorted in ascending order. Then format the Total field so that the cells displaying a value less than or equal to 1000 are displayed in red font color.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365Google Sheets

 

 

 


Sort all data of the Competiton1 worksheet firstly by Salesman then by District and lastly by Total. All fields should be sorted in ascending order. Then format the Total field so that the cells displaying a value less than or equal to 1000 are displayed in red font color.