If cells A1 and A2 are empty, what will be the value of the following Excel formula? =A1*A2Group of answer choicesValue! error2Name? error0

A red indicator in the top right corner of a cell indicates that a cell contains _____.Group of answer choicesa calculation errora filtera commenta spelling mistake

_____ Excel function returns TRUE or FALSE based on two or more conditionsGroup of answer choices=CONCAT=AVERAGEIFS=COUNTA=AND

The Excel function HLOOKUP looks up a value in the top row of a table and returns a value in the same column from a row you specify. Group of answer choicesTrueFalse

If we hit on OK what will happen.Group of answer choicesColumn A and B will be groupedRow 1 will be groupedexcel will warn on improper selectionnone of the above

Which of the following is NOT a recommended way of dealing with missing values:Group of answer choicesPut a NULL where there is a missing valueRemove the whole column if there are missing values in some row of that columnUse a model with predicts the missing value from the other fieldsRemove the whole row if there are missing values in some column of that row