MS Excel Excel displays the current cell address in the ___ Title Bar Status Bar Formula Bar Name Box Title Bar Status Bar Formula Bar Name Box ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Ctrl key while 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 Dragging over the desired cells Pressing the Ctrl key while 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 Dragging over the desired cells 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 Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Microsoft Excel is a powerful ___ Word processing package Communication S/W package Spreadsheet package DBMS package Word processing package Communication S/W package Spreadsheet package DBMS package ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? ROUND ( ) Div ( ) MOD ( ) FACT ( ) ROUND ( ) Div ( ) MOD ( ) FACT ( ) ANSWER DOWNLOAD EXAMIANS APP