MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you wrap the text in a cell ? Format, cells, alignment Format, cells, font Format, cells, number Format, cells, protection Format, cells, alignment Format, cells, font Format, cells, number Format, cells, protection ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes the content of a cell 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Objects Scenarios Contents All of the listed here Objects Scenarios Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? XY Chart Line Chart Column Chart Pie Chart XY Chart Line Chart Column Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP