Question

In which menu bar consolidate and subtotal option is available

Answer 1

Answer:

This command button is known as the AutoSum button. You can quickly enter the AVERAGE, COUNT, MAX or MIN functions by expanding the drop-down menu. The "More Functions" button displays the (Insert > Function) dialog box. You can also use the shortcut key (Alt + =) to quickly sum the adjacent cells.

Answer 2

Explanation:

Insert>consolidation

hope it will be helpful to you