MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Clear > Contents Edit > Clear >All Edit > Delete All of the listed here Edit > Clear > Contents Edit > Clear >All Edit > Delete All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Row chart Line chart Pie chart Column chart Row chart Line chart Pie chart Column chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Cut and Paste Paste Special > Transpose None of above Both of above Cut and Paste Paste Special > Transpose None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) Ampersand (&) Apostrophe (') Hash (#) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Both Formula None Cell value Both Formula None Cell value ANSWER DOWNLOAD EXAMIANS APP