MS Excel Concatenation of text can be done using Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Square Divide Goal seek Percentage Square Divide Goal seek Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select Insert Delete from the menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select Insert Delete from the menu 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 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
EXAMIANS