MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F8 F9 F10 F11 F8 F9 F10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both Click Gridline tool on Forms toolbar None Go to Tools > Options > View tab and mark or remove the check box named Gridline Both 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 remove borders applied in cells ? Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None Choose None on Border tab of Format cells Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None Choose None on Border tab of Format cells Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Line Area Pie All of the listed here Line Area Pie All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Click the formula bar Press the Alt key Double click the cell Press the F2 key Click the formula bar Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS