Podcast
Questions and Answers
Match the Excel shortcuts with their functions:
Match the Excel shortcuts with their functions:
Ctrl + I, Ctrl + B = To italicize and make the font bold Alt + H + A + C = To center align cell contents Ctrl + Shift + _ = To remove outline border Alt + H + B = To add a border
Match the Excel shortcuts with their functions:
Match the Excel shortcuts with their functions:
Tab = To move to the next cell Shift + Tab = To move to the previous cell Ctrl + Shift + Right arrow = To select all the cells on the right Ctrl + Shift + Left Arrow = To select all the cells on the left
Match the Excel shortcuts with their functions:
Match the Excel shortcuts with their functions:
Ctrl + Shift + Down Arrow = To select all the cells below the selected cell Ctrl + Shift + Up Arrow = To select all the cells above the selected cell F2 = To edit a cell
Match the Excel shortcuts with their functions for comment management:
Match the Excel shortcuts with their functions for comment management:
Match the Excel shortcuts with their functions for cell formatting:
Match the Excel shortcuts with their functions for cell formatting:
Match the Excel shortcuts with their functions for navigation:
Match the Excel shortcuts with their functions for navigation:
Match the Excel shortcuts with their functions for selection:
Match the Excel shortcuts with their functions for selection:
Match the Excel shortcuts with their functions for basic operations:
Match the Excel shortcuts with their functions for basic operations:
Match the following Excel features with their primary usage:
Match the following Excel features with their primary usage:
Match the following benefits of using Excel shortcuts with their descriptions:
Match the following benefits of using Excel shortcuts with their descriptions:
Match the following Excel data formats with their characteristics:
Match the following Excel data formats with their characteristics:
Match the following Excel tasks with their corresponding actions:
Match the following Excel tasks with their corresponding actions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcut benefits with their effects:
Match the following Excel shortcut benefits with their effects:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel features with their primary functions:
Match the following Excel features with their primary functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel benefits with their descriptions:
Match the following Excel benefits with their descriptions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel data management tasks with their corresponding actions:
Match the following Excel data management tasks with their corresponding actions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Match the following Excel shortcuts with their functions:
Flashcards are hidden until you start studying
Study Notes
Cell Formatting Shortcuts
- Edit a cell: F2
- Copy and paste cells: Ctrl + C, Ctrl + V
- Italicize and make font bold: Ctrl + I, Ctrl + B
- Center align cell contents: Alt + H + A + C
- Fill color: Alt + H + H
- Add a border: Alt + H + B
- Remove outline border: Ctrl + Shift + _
- Add an outline to selected cells: Ctrl + Shift + &
- Move to next cell: Tab
- Move to previous cell: Shift + Tab
- Select all cells on the right: Ctrl + Shift + Right arrow
- Select all cells on the left: Ctrl + Shift + Left Arrow
- Select column from selected cell to end of table: Ctrl + Shift + Down Arrow
- Select all cells above selected cell: Ctrl + Shift + Up Arrow
- Select all cells below selected cell: Ctrl + Shift + Down Arrow
Additional Cell Formatting Shortcuts
- Add a comment to a cell: Shift + F2
- Delete a cell comment: Shift + F10 + D
- Display find and replace: Ctrl + H, Ctrl + Shift + L
- Activate the filter: Alt + Down Arrow
- Insert current date: Ctrl + ;
- Insert current time: Ctrl + Shift + :
- Insert a hyperlink: Ctrl + K
- Apply currency format: Ctrl + Shift + $
- Apply percent format: Ctrl + Shift + %
- Go to the “Tell me what you want to do” box: Alt + Q
Row and Column Formatting Shortcuts
- Select the entire row: Shift + Space
- Delete rows and columns, hide and unhide selected rows and columns, and group and ungroup rows and columns: various shortcuts
Introduction to Microsoft Excel
- Excel is an application developed by Microsoft to record, analyze, and visualize data
- Data in Excel is in the form of rows and columns
- Excel is used to record and analyze data, perform mathematical operations, and visualize structured data in charts and graphs
- Excel helps in automating tasks through excel macros
Need for Excel Shortcuts
- Excel supports a plethora of keyboard shortcuts to work efficiently and increase productivity
- Using Excel shortcuts increases speed and reduces work-time
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
