Microsoft Excel Shortcuts

Questions and Answers

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:

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:

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:

= To add a comment to a cell Ctrl + C, Ctrl + V = To copy and paste cells Alt + H + H = To fill color Alt + H + B = To add a border Signup and view all the answers

Match the Excel shortcuts with their functions for cell formatting:

Alt + H + A + C = To center align cell contents Ctrl + I, Ctrl + B = To italicize and make the font bold Ctrl + Shift + & = To add an outline to the select cells Alt + H + B = To add a border Signup and view all the answers

Match the Excel shortcuts with their functions for navigation:

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 F2 = To edit a cell Signup and view all the answers

Match the Excel shortcuts with their functions for selection:

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 Ctrl + Shift + Right arrow = To select all the cells on the right Signup and view all the answers

Match the Excel shortcuts with their functions for basic operations:

Ctrl + C, Ctrl + V = To copy and paste cells F2 = To edit a cell Alt + H + H = To fill color Alt + H + B = To add a border Signup and view all the answers

Match the following Excel features with their primary usage:

Excel Macros = Automating tasks Charts and Graphs = Visualizing structured data Mathematical Operations = Performing calculations Rows and Columns = Organizing data Signup and view all the answers

Match the following benefits of using Excel shortcuts with their descriptions:

Increase Productivity = Work more efficiently Reduce Work-Time = Complete tasks faster Ease of Use = Accessing the toolbar with a mouse Improved Accuracy = Reducing errors in data analysis Signup and view all the answers

Match the following Excel data formats with their characteristics:

Structured Data = Organized data in charts and graphs Unstructured Data = Randomly organized data Row Data = Data organized horizontally Column Data = Data organized vertically Signup and view all the answers

Match the following Excel tasks with their corresponding actions:

Record Data = Storing data in Excel Analyze Data = Performing mathematical operations Visualize Data = Creating charts and graphs Automate Tasks = Using Excel macros Signup and view all the answers

Match the following Excel shortcuts with their functions:

Ctrl + H = To display find and replace Ctrl + ; = To insert the current date Shift + F10 + D = To delete a cell comment Ctrl + Shift + $ = To apply the currency format Signup and view all the answers

Match the following Excel shortcut benefits with their effects:

Fewer Keystrokes = Reducing work-time Increased Speed = Completing tasks faster Easy Access = Accessing the toolbar with a mouse Improved Efficiency = Working more efficiently Signup and view all the answers

Match the following Excel shortcuts with their functions:

Alt + Down Arrow = To activate the filter Ctrl + k = To insert a hyperlink Shift + Space = To select the entire row Ctrl + Shift + % = To apply the percent format Signup and view all the answers

Match the following Excel features with their primary functions:

Charts = Visualizing data Rows = Organizing data horizontally Columns = Organizing data vertically Macros = Automating tasks Signup and view all the answers

Match the following Excel shortcuts with their functions:

Shift + F2 = To add a comment to a cell Ctrl + Shift + L = To display find and replace Alt + Q = To go to the “Tell me what you want to do” box Ctrl + Shift + : = To insert current time Signup and view all the answers

Match the following Excel benefits with their descriptions:

Time-Saving = Reducing work-time Increased Productivity = Working more efficiently Ease of Use = Accessing the toolbar with a mouse Improved Accuracy = Reducing errors in data analysis Signup and view all the answers

Match the following Excel shortcuts with their functions:

Ctrl + ; = To insert the current date Ctrl + Shift + : = To insert current time Shift + F10 + D = To delete a cell comment Ctrl + H = To display find and replace Signup and view all the answers

Match the following Excel data management tasks with their corresponding actions:

Organizing Data = Using rows and columns Analyzing Data = Performing mathematical operations Visualizing Data = Creating charts and graphs Automating Tasks = Using Excel macros Signup and view all the answers

Match the following Excel shortcuts with their functions:

Alt + Down Arrow = To activate the filter Ctrl + k = To insert a hyperlink Ctrl + Shift + $ = To apply the currency format Shift + Space = To select the entire row Signup and view all the answers

Match the following Excel shortcuts with their functions:

Shift + F2 = To add a comment to a cell Ctrl + Shift + L = To display find and replace Ctrl + Shift + % = To apply the percent format Alt + Q = To go to the “Tell me what you want to do” box Signup and view all the answers

Match the following Excel shortcuts with their functions:

Ctrl + H = To display find and replace Ctrl + ; = To insert the current date Shift + F10 + D = To delete a cell comment Ctrl + Shift + : = To insert current time Signup and view all the answers

Match the following Excel shortcuts with their functions:

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