MS Excel Which of the cell pointer indicates you that you can make selection? Small thin plus icon None of above Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip Small thin plus icon None of above Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 5436.8 6.8 5436.80 5430 5436.8 6.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? 10+50 =10+50 =B7+14 =B7*B1 10+50 =10+50 =B7+14 =B7*B1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to Split a worksheet into two panes Edit the contents of a cell View different rows and columns edit the contents of a cell View different worksheets Split a worksheet into two panes Edit the contents of a cell View different rows and columns edit the contents of a cell View different worksheets ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS