MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? MOD ( ) FACT ( ) ROUND ( ) Div ( ) MOD ( ) FACT ( ) ROUND ( ) Div ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5436.80 6.8 5430 5436.8 5436.80 6.8 5430 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not an example of a value? 350 0.57 May 10, 2001 Serial Number 50771 350 0.57 May 10, 2001 Serial Number 50771 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 click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box 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 select the Centered alignment From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Extends a sequential series of data All of the listed here Automatically adds range of cell values Applies a boarder around the selected cells Extends a sequential series of data All of the listed here Automatically adds range of cell values Applies a boarder around the selected cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Custom List Fill across worksheet Fill series Auto fill options Custom List Fill across worksheet Fill series Auto fill options ANSWER DOWNLOAD EXAMIANS APP