MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and 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 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 column then choose Paste Special, then click Transpose and 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 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 Which setting you must modify to print a worksheet using letterhead? Paper Margin Orientation Layout Paper Margin Orientation Layout ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by Clicking the formula button Double clicking the cell to edit it in place None of these Selecting Edit > Edit cell from the menu Clicking the formula button Double clicking the cell to edit it in place None of these Selecting Edit > Edit cell from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The autosum button The quicktotal button The total button The Formula button The autosum button The quicktotal button The total button The Formula button ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS