MS Excel Which of the following option is not available in paste Special dialog box ? Subtract Add Divide SQRT Subtract Add Divide SQRT ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Shift key Esc key End key Ctrl key Shift key Esc key End key Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Widen the columns Select the cells containing the title text plus the range over which the title text is to be centered Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Widen the columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Choose the new command from the file menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts non-empty cells Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells Counts empty cells 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 From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS