MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both Excel does not have option to match case for find None of the listed here You can Find and Replace within the sheet or workbook Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel In help menu of Excel, which of the following tabs are found? Contents tab Answer Wizard tab Index tab All of these Contents tab Answer Wizard tab Index tab All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 1024 256 65535 1048576 1024 256 65535 1048576 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Hyperlinks can be Drawing objects All of above Pictures Text Drawing objects All of above Pictures Text ANSWER DOWNLOAD EXAMIANS APP
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 Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? = (equal) " (quote) ' (apostrophe) _ (underscore) = (equal) " (quote) ' (apostrophe) _ (underscore) ANSWER DOWNLOAD EXAMIANS APP