MS Excel What does COUNTA () function do? Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals Data, Form Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Fill down in the selection Apply double underline for the active cell None of the listed here Open the font dialog box Fill down in the selection Apply double underline for the active cell None of the listed here Open the font dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Today () Now () Time () Date () Today () Now () Time () Date () ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS