Question
You want Excel to indicate which cell in a column of numbers contains the smallest number. The numbers are located in cells D15 through D89.
You want Excel to indicate which cell in a column of numbers contains the smallest number. The numbers are located in cells D15 through D89. Ignoring the need for an equal sign, which of the following, if typed into cell E15 and pulled down the column, will identify the desired cell? A. IF(D15=MIN(D15:D89),"Smallest","No") B. IS(D15=MIN(D$15:D$89),"Smallest"," ") C. (IF D15=MIN(D$15:D$89),"Smallest","No") D. IF(D15=MIN(D$15:D$89),"Smallest","No") E. (IF D15=SMALL(D$15:D$89),"Smallest","No") F. IF ($D15=SMALL($D$15:$D$89),"Smallest","No") G. two of the above are correct.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started