adplus-dvertising
frame-decoration

Question

While Finding and Replacing some data in Excel, which of the following statement is valid?

a.

You can Find and Replace within the sheet or workbook

b.

Excel does not have option to match case for find

c.

Both are valid

d.

None are valid

Posted under MS Office

Answer: (a).You can Find and Replace within the sheet or workbook

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. While Finding and Replacing some data in Excel, which of the following statement is valid?

Similar Questions

Discover Related MCQs

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

Q. You can move a sheet from one workbook into new book by

Q. What is the short cut key to replace a data with another in sheet?

Q. Comments put in cells are called .....

Q. Comments can be added to cells using ......

Q. Which menu option can be used to split windows into two?

Q. Getting data from a cell located in a different sheet is called ......

Q. Which of the following is not a valid data type in Excel?

Q. Which elements of a worksheet can be protected from accidental modification?

Q. A numeric value can be treated as label value if ...... precedes it.

Q. Concatenation of text can be done using

Q. Which area in an Excel window allows entering values and formulas?

Q. Multiple calculations can be made in a single formula using .......

Q. An Excel Workbook is a collection of .......

Q. What do you mean by a Workspace?

Q. MS-EXCEL is based on .........?

Q. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

Q. To select an entire column in MS-EXCEL, press?

Q. To return the remainder after a number is divided by a divisor in EXCEL we use the function?

Q. Which function is not available in the Consolidate dialog box?