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
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 Both Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None Both Choose None on Border tab of Format cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scrolling button Allow you to view additional worksheet rows down Allow you to view additional sheets tabs Allow you to view additional worksheet columns to the right Allow you to view a different worksheet Allow you to view additional worksheet rows down Allow you to view additional sheets tabs Allow you to view additional worksheet columns to the right Allow you to view a different worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? None of the listed here Excel does not have option to match case for find You can Find and Replace within the sheet or workbook Both None of the listed here Excel does not have option to match case for find You can Find and Replace within the sheet or workbook Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which setting you must modify to print a worksheet using letterhead? Margin Orientation Layout Paper Margin Orientation Layout Paper ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto format Auto sum Auto correct AutoFill Auto format Auto sum Auto correct AutoFill ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS