If cells A1 and A2 are empty, what will be the value of the following Excel formula? =A1*A2Group of answer choices02Value! errorName? error

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

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

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