Question

Which function key opens a dialog box that allows you to make a special selection of, for example, all cells containing comments, or all cells containing formulas, or all objects (text boxes, shapes, etc.) on a worksheet

Answer 1

F5 key.

Step-by-step explanation:

In Computer science, F5 is a function key which opens a dialog box that allows you to make a special selection of, for example, all cells containing comments, or all cells containing formulas, or all objects (text boxes, shapes, etc.) on an excel worksheet.

In Microsoft Excel, the F5 key is known as a "Go to special function" which avails users the ability to select all cells that meets certain defined criteria, such as the cells containing comments, formulas, objects, constants etc.