MS Excel What does COUNTA () function do? Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to Right align the content of cell Remove the cell contents of selected cells None of above Fill the selection with active cells to the right Right align the content of cell Remove the cell contents of selected cells None of above Fill the selection with active cells to the right ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried 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 To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS