Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Which of the following is not true about Find and Replace in Excel

A) You can search for bold and replace with italics

B) You can decide whether to look for the whole word or not

C) You can search in formula too

D) You can search by rows or columns or sheets

user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/05/20
Mohamed Abou Ghanem
by Mohamed Abou Ghanem , Accounting Manager , Al Mabani International Real Estate

A) You can search for bold and replace with italics

Mohammed Khalid Karim
by Mohammed Khalid Karim , Senior Instructor (Training Specialist) , Saudi Airlines

A.) You can search for Bold and replace with Italics.

A cell that contains mixed formatted text cannot be used with the Find & Replace command.

Find and Replace only works with cells that contains single formatted text.

Mohammad Abu Yusuf Faruk
by Mohammad Abu Yusuf Faruk , Senior Gas Plant Engineer , Chevron

D is the only answer here. all other options can be performed in excel file.

Leo De Leon
by Leo De Leon , Quantity Surveyor , FAITHFUL & GOULD

Definite option is letter D.) You can search by rows or columns or sheets.

Menes Richard
by Menes Richard , HR Secretary , Zaid Alhussain & Brothers' Group

B & D - TRUE

A & C - NOT TRUE/ FALSE

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

D) You can search by rows or columns or sheets

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.