MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 6.8 5436.8 5436.80 5430 6.8 5436.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Shift key and an arrow key 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 Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells Pressing the Shift key and an arrow key 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 Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of worksheet currently working on None of the listed here Shows the name of cell or range currently working on Shows the name of workbook currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of cell or range currently working on Shows the name of workbook currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation None of the listed here Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes the comment of cell Deletes Formats of cell Deletes selected cells Deletes the content of a cell Deletes the comment of cell Deletes Formats of cell Deletes selected cells Deletes the content of a cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP