which Excel tool allows you to set specific conditions for data entry ensuring accuracy and consistency in your analysis...? Mcqs

which Excel tool allows you to set specific conditions for data entry ensuring accuracy and consistency in your analysis...?

(A) goal seek

(B) data validation

(C) scenario manager

(D) pivot table