When working in a Pivot Table, the additional menu items "Options" and "Design" are found:

Which keyboard shortcut selects cells that contain formulas that directly reference the active cell?

The sumif function can sum data based on multiple criteria.

What happens when you push F1 button

If you want to select margin sizes,where you should go?

Where in the ribbon is the 'Zoom to Selection' tool located?

Option used for limiting or restricting the cell entries to a certain data type?

What will happen when we click on the marked triangle as shown in the given image?

The CHOOSE function can be used for selecting up to how many values based on an index number?

Which is NOT a valid option for Macro Settings under the Trust Center?

Which tab will you click for accessing the View Macros option?