The correct keyboard shortcut to create a new PivotTable in Microsoft Excel is the access key sequence Alt + N, V. Pressing Alt activates the KeyTips on the ribbon. Pressing N selects the 'Insert' tab. Finally, pressing V selects the 'PivotTable' command, which launches the "Create PivotTable" dialog box. This is the officially documented and standard keyboard method for initiating the PivotTable creation process from a data range or table.

A. Ctrl + Shift + T: This is not a standard Excel shortcut. The related shortcut, Ctrl + T, is used to create a standard Excel table, not a PivotTable.
B. Ctrl + Shift + P: This shortcut opens the 'Format Cells' dialog box with the 'Font' tab active, allowing for quick changes to font size and style.
C. Alt + A, P: This access key sequence selects the 'Data' tab (Alt + A), but 'P' is not a valid command for creating a PivotTable within that tab.

1. Microsoft Corporation. (n.d.). Keyboard shortcuts in Excel. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f.

Reference Point: In the section "Ribbon keyboard shortcuts

" the document outlines the use of Alt key sequences. The path to insert a PivotTable (Insert > PivotTable) corresponds directly to the Alt

N

V sequence. The document also lists Ctrl+Shift+P for opening the Font dialog box.

2. Microsoft Corporation. (n.d.). Create a PivotTable to analyze worksheet data. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576.

Reference Point: The article explicitly states the creation path: "Select Insert > PivotTable." This confirms the ribbon location that the Alt + N

V shortcut accesses.

3. University of Wisconsin-Madison. (n.d.). Excel 2016 - Getting Started with Pivot Tables. Software Training for Students. Retrieved from https://sts.doit.wisc.edu/wp-content/uploads/sites/135/2017/05/Excel-2016-Getting-Started-with-Pivot-Tables.pdf.

Reference Point: Page 2

under the section "Creating a Pivot Table

" instructs users to "Click on the Insert tab and then click on the PivotTable button." This university courseware validates the ribbon path

which is the basis for the Alt + N

V access key shortcut.