Podcast
Questions and Answers
What is the shortcut key for applying the 'Currency' format to a cell in MS Excel?
What is the shortcut key for applying the 'Currency' format to a cell in MS Excel?
- Ctrl + Alt + $
- Ctrl + Shift + #
- Ctrl + Shift + $ (correct)
- Alt + C
Which of the following is a valid method for merging cells in MS Excel?
Which of the following is a valid method for merging cells in MS Excel?
- Highlight the cells to be merged, then press 'Alt + M'
- Type 'merge' in the formula bar and press Enter
- Select the cells to be merged, right-click, and choose 'Merge Cells' from the context menu (correct)
- Click on the 'Merge Cells' button in the 'Home' tab on the ribbon
What does the 'Wrap Text' feature in MS Excel do?
What does the 'Wrap Text' feature in MS Excel do?
- Allows text to be displayed on multiple lines within a cell (correct)
- Enables text to be displayed in a vertical orientation
- Automatically adjusts the column width to fit the content of the cell
- Converts text to uppercase within the selected cells