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 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 All of above Use =if() function to format the required numbers red 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 All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Hyperlinked placed in a word table Embedded Use the word menu bar and toolbars Linked Hyperlinked placed in a word table Embedded Use the word menu bar and toolbars Linked ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. View Tools File Insert View Tools File Insert ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes the content of a cell Deletes Formats of cell Deletes the comment of cell Deletes selected cells Deletes the content of a cell Deletes Formats of cell Deletes the comment of cell Deletes selected cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS