MS Excel Which of the following Excel screen components can NOT be turned on or off ? Tool Bar None Formula Bar Status Bar Tool Bar None Formula Bar Status Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Hash (#) Apostrophe (') Tilde (~) Exclamation (!) Hash (#) Apostrophe (') Tilde (~) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by Clicking the formula button None of these Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place Clicking the formula button None of these Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place 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 You can select a single range of cells by Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells Pressing the Shift key and an arrow key Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Divide Add Subtract SQRT Divide Add Subtract ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS