MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Work sheet Macro sheet Data sheet Chart sheet Work sheet Macro sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Date () Time() Today () Now () Date () Time() Today () Now () ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above 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 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 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which setting you must modify to print a worksheet using letterhead? Layout Orientation Paper Margin Layout Orientation Paper Margin ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS