MS Excel Concatenation of text can be done using Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 8 255 3 none of above 8 255 3 none of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Validation Formulas All of above Formats Validation Formulas All of above Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which would you choose to create a bar diagram? Format, Chart Insert, Chart Tools, Chart Edit, Chart Format, Chart Insert, Chart Tools, Chart Edit, Chart 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
EXAMIANS