MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R 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 Goal seek Divide Percentage Square Goal seek Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scrolling button Allow you to view a different worksheet Allow you to view additional worksheet rows down Allow you to view additional sheets tabs Allow you to view additional worksheet columns to the right Allow you to view a different worksheet Allow you to view additional worksheet rows down Allow you to view additional sheets tabs Allow you to view additional worksheet columns to the right ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? None of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above None of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above 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 Which key do you press to check spelling? F9 F5 F7 F3 F9 F5 F7 F3 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS