Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date de publication: 2015/05/20
Mohamed Abou Ghanem
par Mohamed Abou Ghanem , Accounting Manager , Al Mabani International Real Estate

A) You can search for bold and replace with italics

Mohammed Khalid Karim
par Mohammed Khalid Karim , Instructor , Saudi Arabian 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
par 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
par Leo De Leon , Quantity Surveyor , FAITHFUL & GOULD

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

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

B & D - TRUE

A & C - NOT TRUE/ FALSE

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

D) You can search by rows or columns or sheets