Which of the following options is not available in Paste Special dialog box?

Concept: Paste Special is a paste-control dialog, not a calculation engine. Everything it can do falls into three groups — which part of the copied cell is brought across, one arithmetic operation that combines the copied number with the number already sitting in the destination cell, and two paste modifiers. Anything Excel carries out through a formula lies outside this dialog.

Application: the three groups of the dialog hold exactly these settings.

The Operation group is therefore a fixed list of five radio buttons. Add, Subtract and Divide all sit inside it: picking Divide and pasting a 4 onto a cell holding 10 leaves 2.5 in that cell. SQRT appears in none of the three groups — it is a Math & Trig worksheet function typed into a formula, as in =SQRT(16), which returns 4, and the dialog gives you nowhere to type a function name.

Cross-check:

• Divide really is in the dialog — it is the fifth radio button of the Operation group, sitting under Multiply. It is easy to overlook because that group is a short unlabelled column, but Microsoft's documentation lists None, Add, Subtract, Multiply and Divide for Excel 2019 and for Microsoft 365 alike.

• SQRT belongs to the worksheet-function library (Math & Trig). Functions are evaluated by formulas inside cells, never by paste settings, so no release of the dialog has ever carried it.

• "None of these" would need every named item to live inside the dialog, and SQRT does not.

Result: SQRT is the item that is not available in the Paste Special dialog box.