MS Excel When a row of data is to be converted into columns 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 Copy the cells in row, select the same number of cells in row and paste 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 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 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 You can activate a cell by Pressing the Tab key Pressing an arrow key All of these Clicking the cell Pressing the Tab key Pressing an arrow key All of these Clicking the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both Choose None on Border tab of Format cells None Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both Choose None on Border tab of Format cells None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not an example of a value ? May 10, 2001 350 0.57 Serial Number 50771 May 10, 2001 350 0.57 Serial Number 50771 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data Subtotals Data, Table Data, Sort Data, Form Data Subtotals Data, Table Data, Sort ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS