MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.80 5436.8 5430 6.8 5436.80 5436.8 5430 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto sum AutoFill Auto correct Auto format Auto sum AutoFill Auto correct Auto format ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by Selecting Edit > Edit cell from the menu Clicking the formula button Double clicking the cell to edit it in place None of these Selecting Edit > Edit cell from the menu Clicking the formula button Double clicking the cell to edit it in place None of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula 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? Fill series Auto fill options Fill across worksheet Custom List Fill series Auto fill options Fill across worksheet Custom List ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formulas All of above Validation Formats Formulas All of above Validation Formats ANSWER DOWNLOAD EXAMIANS APP