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 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 in column then choose Paste Special, then click Transpose and 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 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 You can activate a cell by Pressing an arrow key Clicking the cell All of these Pressing the Tab key Pressing an arrow key Clicking the cell All of these Pressing the Tab key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you want to insert a blank embedded excel object in a word document you can Click the import excel command on the file menu Click the office links button on the standard toolbar Click the create worksheet button on the formatting toolbar Click the object command on the insert menu Click the import excel command on the file menu Click the office links button on the standard toolbar Click the create worksheet button on the formatting toolbar Click the object command on the insert menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline None Both Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Objects All of the listed here Scenarios Contents Objects All of the listed here Scenarios Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS