MCQs>Finance & Management>Excel>A drop down menu contains 'Sum','Average' and 'Max', a table exists mapping these values to 1,2 and 3 respectively. What function next to the drop-down will Sum, Average or Max A1:A100 based on the drop-down input?
Excel MCQs
A drop down menu contains "Sum","Average" and "Max", a table exists mapping these values to 1,2 and 3 respectively. What function next to the drop-down will Sum, Average or Max A1:A100 based on the drop-down input?