MS Excel Which of the following action removes a sheet from workbook? Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide None of above Both of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7*B1 =B7+14 10+50 =10+50 =B7*B1 =B7+14 10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Visual Basic C Java Visual C++ Visual Basic C Java Visual C++ ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The edit formula button The enter button All of these The cancel button The edit formula button The enter button All of these The cancel button ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Today () Date () Now () Time () Today () Date () Now () Time () 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 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 ANSWER DOWNLOAD EXAMIANS APP