Microsoft Excel 2021365 - Beginner to Advanced - Navigating and Selecting Cells, Rows, and Columns

The video tutorial covers various methods of making selections in Excel worksheets. It begins with basic cell selections and progresses to more advanced techniques like selecting non-contiguous cells using the control key. The tutorial also explains how to navigate large datasets efficiently and how to select entire columns and rows. Keyboard shortcuts and formatting options are discussed to enhance productivity in Excel.

What keyboard shortcut is used to save changes in an Excel workbook?

• Control + A

• Control + P

• Control + S

• Control + Z

How can you select multiple contiguous cells in Excel?

• By clicking and dragging the mouse

• By holding the Shift key and clicking

• By using the Alt key

• By pressing Control + C

Which key should you hold to select non-contiguous cells in Excel?

• Shift

• Alt

• Control

• Tab

What is the keyboard shortcut to select all cells in a column from a specific cell downwards?

• Control + Shift + Down Arrow

• Control + Down Arrow

• Shift + Down Arrow

• Control + Alt + Down Arrow

How can you select an entire column in Excel?

• By pressing Control + C

• By clicking the column letter

• By double-clicking the column letter

• By right-clicking the column letter

What happens when you click the black downward arrow at the top of a column?

• It deletes the column

• It selects the entire row

• It selects the entire column

• It opens the column settings

Which method is NOT efficient for selecting a large range of cells in a column?

• Clicking the column letter

• Using Control + Shift + Down Arrow

• Using Control + Down Arrow

• Clicking and dragging the mouse