MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R 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 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste 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 then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data, Sort Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which key do you press to check spelling? F9 F5 F7 F3 F9 F5 F7 F3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? #a#1 !A!1 A1 $A$1 #a#1 !A!1 A1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS