In a large mixing bowl, combine the mayonnaise, mustard, apple cider vinegar, sugar, salt, onion powder, celery seeds, black pepper, and fresh lemon juice. Whisk everything together until the dressing is smooth and well-blended, making sure the sugar and salt are fully dissolved. I like to taste the dressing at this point and adjust the seasoning—if you prefer it tangier, add a splash more vinegar, or if you want it sweeter, add a bit more sugar. The dressing should taste slightly bold since it will mellow out when mixed with the pasta and vegetables.