Purpose
The purpose of this assignment is to demonstrate your Excel skills and knowledge on the topics covered in this module.
Instructions
Complete the file M3 Assignment 1.xlsx. Add your unique ID to the file name.
Complete the file M3 Assignment 2.xlsx. Add your unique ID to the file name.
Create a new file and follow these instructions:
Starting in cell A1 and continuing down the spreadsheet, create a list of numbers you want to add together. (Example: 2, 5, 7, 9, 12)
Select the cell just below the last number you added.
Click on the “Formulas” tab in the ribbon.
Click on the “Insert Function” button.
In the “Insert Function” dialog box, search for “SUM” in the search bar.
Select the “SUM” function from the list of results and click “OK”.
In the “Function Arguments” dialog box, select the range of cells containing the numbers you want to add together.
Click “OK” to complete the function.
The total sum of the numbers will be displayed in the selected cell.
Save the file as M3 Assignment 3 uniqueID.xlsx
Grading
Points will be deducted for not completing or incorrectly completing any part of the assignments.
Submit the following files:
M3 Assignment 1 uniqueID.xlsx
M3 Assignment 2 uniqueID.xlsx
M3 Assignment 3 uniqueID.xlsx