MS Excel Edit > Delete command Deletes selected cells Deletes the content of a cell Deletes the comment of cell Deletes Formats of cell Deletes selected cells Deletes the content of a cell Deletes the comment of cell Deletes Formats of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells Both None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells Both None ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Sum Max Pmt Average Sum Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here ANSWER DOWNLOAD EXAMIANS APP