Excel Office Pro Videos 5.3.1, 5.3.2 & 5.3.3

What happens when you press 'Delete' on the keyboard after selecting a cell's content in Excel?

• The entire row is deleted

• The entire column is deleted

• The contents of the selected cells are removed, but blank cells are left behind

• The formatting of the selected cells is removed

Which tab in Excel contains the 'Clear' option for removing data?

• Insert tab

• Home tab

• Data tab

• View tab

What is the shortcut for pasting in most applications?

• Ctrl+X

• Ctrl+V

• Ctrl+C

• Ctrl+Z

What does the 'Clear all' option do in Excel?

• Removes all formatting from the selected cells

• Removes all information from the selected cells, leaving default white cells behind

• Removes the entire row

• Removes the entire column

How can you delete an entire row in Excel?

• Press 'Delete' on the keyboard

• Click 'Delete' on the ribbon

• Right-click a row or column heading and select 'Delete'

• All of the above

What is the main topic of Video 5.3.2?

• Copy and Paste Options

• Large Data Sets

• Deleting and Clearing Cells

• Formatting Cells

What keyboard shortcut is used to copy cells in Excel?

• Ctrl+V

• Ctrl+X

• Ctrl+C

• Ctrl+Z

What should you do after selecting the cells to copy for transposing data?

• Press Ctrl+V

• Right click and choose Paste Values

• Right click and choose Transpose

• Press Ctrl+X

What should you do if you accidentally paste a formula instead of a value?

• Press Ctrl+V again

• Press Ctrl+Z to undo

• Press Ctrl+C to copy again

• Press Ctrl+X to cut

What is the purpose of the Paste Transpose option in Excel?

• To copy and paste only the values from the selected cells.

• To copy and paste the formatting from the selected cells.

• To switch rows with columns.

• To copy and paste both the values and formulas from the selected cells.