MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when One sheet is selected None of the listed here When many sheets are selected When no sheet is selected One sheet is selected None of the listed here When many sheets are selected When no sheet is selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation None of the listed here Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Clear >All All of the listed here Edit > Delete Edit > Clear > Contents Edit > Clear >All All of the listed here Edit > Delete Edit > Clear > Contents ANSWER DOWNLOAD EXAMIANS APP
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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS