MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Add Divide Subtract SQRT Add Divide Subtract ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Both of above None of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above None of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Delete the column from the worksheet Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Delete the column from the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 6.8 5430 5436.8 5436.80 6.8 5430 5436.8 ANSWER DOWNLOAD EXAMIANS APP