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 You can enter which types of data into worksheet cells? Labels and values but not formulas Formulas only Values and formulas but not labels Labels, values, and formulas Labels and values but not formulas Formulas only Values and formulas but not labels Labels, values, and formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Square Divide Percentage Goal seek Square Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? None Press Tab Press the Alt key Press Enter None Press Tab Press the Alt key Press Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Protection Password Read-only Recommended Write Reservation Password Any of the above Protection Password Read-only Recommended Write Reservation Password Any of the above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS