The image you provided is a reference sheet for keyboard shortcuts in Microsoft Word and Excel (for PC). The task appears to be related to understanding and applying these shortcuts effectively. Below, I will explain how to use this reference sheet and provide guidance on solving problems involving these shortcuts.
---
Understanding the Reference Sheet
The sheet is divided into three main sections:
1.
Common Shortcuts: These are general shortcuts applicable across both Word and Excel.
2.
Word Shortcuts: Specific shortcuts for formatting, editing, and navigating in Microsoft Word.
3.
Excel Shortcuts: Specific shortcuts for managing cells, data, and formulas in Microsoft Excel.
Each section lists a shortcut with its corresponding function. For example:
- In
Word, `Ctrl+B` is used to make text bold.
- In
Excel, `Ctrl+Shift+=` is used to insert cells.
---
How to Use This Sheet
1.
Identify the Task: Determine what you want to achieve (e.g., bold text, create a chart, or calculate a formula).
2.
Locate the Shortcut: Find the relevant shortcut in the appropriate section of the sheet.
3.
Apply the Shortcut: Use the keyboard combination to perform the task.
---
Example Problems and Solutions
####
Problem 1: How to Make Text Bold in Word
-
Solution: Look under the "Word" section. The shortcut for making text bold is `Ctrl+B`.
-
Steps:
1. Select the text you want to make bold.
2. Press `Ctrl+B`.
####
Problem 2: How to Insert a New Row in Excel
-
Solution: Look under the "Excel" section. The shortcut for inserting a new row is `Shift+Space`.
-
Steps:
1. Select the row where you want to insert a new row above it.
2. Press `Shift+Space`.
####
Problem 3: How to Undo an Action in Both Word and Excel
-
Solution: Look under the "Common" section. The shortcut for undoing an action is `Ctrl+Z`.
-
Steps:
1. Perform the action you want to undo.
2. Press `Ctrl+Z`.
####
Problem 4: How to Create a Chart in Excel
-
Solution: Look under the "Excel" section. The shortcut for creating a chart is `Alt+F1`.
-
Steps:
1. Select the data range you want to include in the chart.
2. Press `Alt+F1`.
####
Problem 5: How to Add a Hyperlink in Word
-
Solution: Look under the "Word" section. The shortcut for adding a hyperlink is `Ctrl+K`.
-
Steps:
1. Select the text you want to link.
2. Press `Ctrl+K`.
3. Enter the URL or file path in the dialog box that appears.
####
Problem 6: How to Calculate All Sheets in Excel
-
Solution: Look under the "Excel" section. The shortcut for calculating all sheets is `Shift+F9`.
-
Steps:
1. Press `Shift+F9` to recalculate all formulas across all sheets.
---
General Tips
1.
Practice Regularly: Familiarize yourself with frequently used shortcuts to improve efficiency.
2.
Use the Ribbon Shortcuts: As noted at the bottom of the sheet, holding `Alt` can reveal ribbon shortcuts, which can be useful for tasks not listed here.
3.
Customize Shortcuts: If needed, you can customize shortcuts in both Word and Excel through their respective options menus.
---
Final Answer
The reference sheet provides a comprehensive list of keyboard shortcuts for Word and Excel. To solve any problem involving these shortcuts:
1. Identify the task.
2. Locate the corresponding shortcut in the sheet.
3. Apply the shortcut as described.
If you have a specific problem or need further clarification, feel free to ask!
Boxed Final Answer:
\boxed{\text{Use the reference sheet to identify and apply the appropriate shortcut for your task.}}
Parent Tip: Review the logic above to help your child master the concept of printable keyboard shortcuts.
