MS Excel keyboard shortcuts MCQ - Practice Questions with Answers

In MS Excel, Ctrl + 1 opens the Format Cells dialog box, where number format, alignment, font, border, fill, and protection settings can be changed. Ctrl + F opens the Find tool, so it is for searching within the worksheet. Ctrl + 2 toggles bold formatting for selected cell content, equivalent to the Bold command. Ctrl + D fills the selected cell or range downward from the cell above. Only Ctrl + 1 directly displays the required dialog box.

In Excel, Ctrl + Page Up moves the active view to the previous worksheet in the same workbook. Ctrl + Shift + Page Up is used for selecting the current and previous sheet together, not simply moving to the previous sheet. Alt + Page Up generally moves the worksheet view horizontally towards the left, so it does not switch to the previous sheet tab. Tab + Page Up is not the standard shortcut for moving between worksheet tabs. Therefore, the command that takes the user to the previous sheet of a workbook is Ctrl + Page Up.

In Excel, Ctrl + F6 is used to move to the next workbook window when more than one workbook window is open. Tab moves between controls or cells depending on context, but the printed combined choice retains Ctrl + F6 as the relevant shortcut. F6 and Shift + F6 cycle through panes or interface areas, not the next workbook. Ctrl + Page Up moves to the previous worksheet tab within a workbook. Ctrl + Shift + F6 is normally associated with moving to the previous workbook window, not the next one.