$1.$ The most correct implementation of $$Binary Encoding$$ is

$2.$ The most correct structure of a nested IF statement is

$3.$ The most correct structure of an IF AND OR statement is

$4.$ If you want to pull specific information out of a large dataset using a unique identifier the best function to use is

$5.$ Binary encoding, which is sometimes referred to as dummy variable creation, is the process of converting $\_\_\_\_\_\_\_\_\_\_\_.$

$1.$ A correct implementation of the profit equation is

$2.$ A correct implementation of production costs would be

$3.$ The SUMPRODUCT function is most useful for which of the tasks

$4.$ Which condition$($s$)$ must be met in order to correctly use the SUMPRODUCT function

$5.$ If you want to automatically change the fill color of a cell based on its value, the best method to use would be