MS Excel Which command will you choose to convert a column of data into row? Paste Special > Transpose Cut and Paste None of above Both of above Paste Special > Transpose Cut and Paste None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet None of above Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet None of above 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? From Format Cells dialog box select the Centered alignment 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 click on Merge Cells check box From Format Cells dialog box select the Centered alignment 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 click on Merge Cells check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Border Copy handle Insert handle Fill handle Border Copy handle Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? _ (underscore) ' (apostrophe) " (quote) = (equal) _ (underscore) ' (apostrophe) " (quote) = (equal) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Objects Contents All of the listed here Scenarios Objects Contents All of the listed here Scenarios ANSWER DOWNLOAD EXAMIANS APP