MS Excel keyboard shortcuts MCQ — 2 Practice Questions with Answers

Explanation

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.

Explanation

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.