You have created a worksheet that contains sales revenue results, by quarter, for your regional sales representatives. You will use Microsoft 365 Excel help features to total the sales results for the year.
1. Click on the link below to open the Microsoft Excel exercise document you can use to complete this exercise.
https://github.com/alcadelina/Excel-
https://github.com/alcadelina/Excel-/blob/main/getting%20help.xlsx
2. Click cell G2 to select it, then click inside the Search box in the Title bar and type “sum” to show the available help options:
3. Click on sum under the heading Get Help on:
4. In the Help task pane that opens, read the instructions under the Use the SUM function heading to get information about an easy way to add the numbers in cells C2 through to F2:
5. This will direct you to click Formulas → AutoSum → Sum:
6. Press Enter to accept the formula. The sum will now be displayed in cell G2:
7. Now type “copy formula down” in the search field in the Help task pane. Select copy formula down column from the resulting options:
8. Read the instructions under the Copy cells heading to copy the formula in cell G2 to cells G3 through to G7:
9. You will then select cell G2 and press Ctrl + C, to copy the formula, then select cells G3 through to G7 and press Ctrl + V to paste the formula:
10. Select Cell G3 and note the structure of the formula in the Formula bar:
11. Now click on the Help tab in the ribbon, then click through the available help options to familiarize yourself with the available features:
12. Save your workbook as Activity 1-3 Complete. Close Microsoft 365 Excel to complete this activity.
13. Now, you can check out an example of a completed document in the link below:
https://github.com/alcadelina/Excel-
https://github.com/alcadelina/Excel-/blob/main/Completed%20exercise%20getting%20help.xlsx
No comments:
Post a Comment