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 formulas is not entered correctly? =B7+14 10+50 =B7*B1 =10+50 =B7+14 10+50 =B7*B1 =10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicate that you can move the content to other cell? None of above Small thin plus icon Mouse Pointer with anchor at the tip Doctor’s symbol (Big Plus) None of above Small thin plus icon Mouse Pointer with anchor at the tip Doctor’s symbol (Big Plus) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Data can be arranged in a worksheet in a easy to understand manner using Applying styles Changing fonts Auto formatting All of the listed here Applying styles Changing fonts Auto formatting All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment ANSWER DOWNLOAD EXAMIANS APP