MS Excel Which of the cell pointer indicate that you can move the content to other cell? None of above Mouse Pointer with anchor at the tip Small thin plus icon Doctor’s symbol (Big Plus) None of above Mouse Pointer with anchor at the tip Small thin plus icon Doctor’s symbol (Big Plus) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells 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 Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells 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 Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP