MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? MOD ( ) FACT ( ) ROUND ( ) Div ( ) MOD ( ) FACT ( ) ROUND ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell locator coordinates Cell names Column letters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column letters and row numbers Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; A horizontal axis A chart plot area The data range that supply chart data The organization of individual values with a chart’s data series A horizontal axis A chart plot area The data range that supply chart data The organization of individual values with a chart’s data series ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from You can not set Page Border in Excel From Border tool in Formatting toolbar From Border tab in Farmat cells dialog box From Line style tool in Drawing toolbar You can not set Page Border in Excel From Border tool in Formatting toolbar From Border tab in Farmat cells dialog box From Line style tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP