Question

7. Which of the following Excel features allows you to select/highlight all cells that are formulas? Find ,Replace, Go To ,Go To Special ??​

Answer 1

Answer:

colour format

Explanation:

it is present in the insert tab

Answer 2

Answer:

Go To Special is the correct answer.

Explanation:

The Go-To Special Function in Excel allows you to quickly select all cells that meet specific criteria, such as cells containing:

• Formulas (numbers, text, logic, errors)

• Constants (numbers, text, logic, errors)

• Blank cells

• Objects
• Precedents and dependents

There are three ways to access Go To:

• Press the F5 key

• Press Ctrl + G

• On the Home ribbon, under “Find and Select,” choose “Go To.”

Steps to highlight the Excel formulas -

• STEP 1: Select all the cells in your Excel worksheet by clicking on your worksheet's top left-hand side corner.

• STEP 2: Press the CTRL+G shortcut, which will open the Go To dialogue box, and then select the Special button

• STEP 3: Select the Formula radio button and then press OK.

• STEP 4: This will highlight all the formulas in your Excel worksheet, and then use the Fill Color to color in the formula cells.

• And now, all the cells containing formulas are highlighted.

Read here more-

What is a valid version of MS Excel?

https://brainly.in/question/41302020

What is a Chart in MS Excel?

https://brainly.in/question/5659043