MS Excel Which of the cell pointer indicates you that you can make selection? 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) None of above Mouse Pointer with anchor at the tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals Data, Form Data, Table Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Tools > Finder from the menu Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Max Average Sum Pmt Max Average Sum Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Click the column heading letter Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Click the column heading letter Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while 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 Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while 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 ANSWER DOWNLOAD EXAMIANS APP