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 choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box 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 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press the Edit Formula button Press the Enter button Press Esc Press the Erase key Press the Edit Formula button Press the Enter button Press Esc Press the Erase key ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? All of the listed here Select the row heading where you want to insert the new row and select Edit >Row from the menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and select Edit >Row from the menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Hyperlinks can be All of above Drawing objects Pictures Text All of above Drawing objects Pictures Text ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you print three copies of a workbook? Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Select File > Properties form the menu and type 3 in the Copies to print text box Press Ctrl+P+3 Select File > Print from the menu and type 3 in the Number of copies text box Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made Select File > Properties form the menu and type 3 in the Copies to print text box Press Ctrl+P+3 Select File > Print from the menu and type 3 in the Number of copies text box ANSWER DOWNLOAD EXAMIANS APP