Excel Function Shortcut Keys Tutorial

This video tutorial covers various function shortcuts in Excel, focusing on keys F1 to F12. Each key is explained with its specific function, such as opening help, editing cells, inserting functions, repeating commands, and more. The tutorial encourages viewers to practice these shortcuts alongside the video to enhance their Excel skills.

What happens when you press F1 in Excel?

• It creates a new chart.

• It edits the active cell.

• It hides the ribbon.

• It opens the Excel help task pane.

Which shortcut is used to insert a new worksheet?

• Ctrl + F1

• Alt + F1

• Alt + Shift + F1

• Shift + F1

How can you switch between split panes in a worksheet?

• Press F6

• Press F5

• Press Alt + F6

• Press Ctrl + F6

What is the function of Ctrl + Shift + F6?

• Display the macro dialog box.

• Minimize the workbook.

• Open the spelling dialog box.

• Switch between all open Excel files.

Which function key opens the spelling dialog box?

• F9

• F10

• F7

• F8

What does Shift + F10 do in Excel?

• Opens the 'Save As' dialog box.

• Displays the shortcut menu.

• Inserts a new worksheet.

• Minimizes the workbook.

Which shortcut key is used for 'Save As' in Excel?

• F12

• Shift + F12

• F11

• F10