MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals Data, Form Data, Sort Data, Table ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by 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 Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells 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 Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top right corner Towards the top left corner Towards the bottom left corner Towards the bottom right corner Towards the top right corner Towards the top left corner Towards the bottom left corner Towards the bottom right corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 8 none of above 3 255 8 none of above 3 255 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell locator coordinates Column letters and row numbers Cell names Column numbers and row letters Cell locator coordinates Column letters and row numbers Cell names Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS