Answer: The correct answer is: c. Time to reorder (Z to A), Quantity in reorder (Largest to Smallest).
Step-by-step explanation:
When sorting the selected cells by "Time to reorder (Z to A)", we are arranging the cells in descending order based on the time it takes to reorder. This means that the cells with the longest time to reorder will be listed first, and the cells with the shortest time to reorder will be listed last.
After sorting by "Time to reorder (Z to A)", we then need to sort the cells by "Quantity in reorder (Largest to Smallest)". This involves arranging the cells in descending order based on the quantity of items to be reordered. The cells with the largest quantity in reorder will be listed first, and the cells with the smallest quantity in reorder will be listed last.
By following these steps, we end up with the correct sorting order: Time to reorder (Z to A), Quantity in reorder (Largest to Smallest). This arrangement allows us to prioritize the items that take the longest time to reorder and have the largest quantities for efficient inventory management.