Purpose The purpose of this assignment is to demonstrate your Excel skills and k

WRITE MY ESSAY

Purpose
The purpose of this assignment is to demonstrate your Excel skills and knowledge on the topics covered in this module.
Instructions
There are two assignments to complete.
Complete the file M1 Assignment 1.xlsx. Add your unique ID to the file name.
Create a new file
Enter data in worksheet
You may add any data you want. A few ideas include creating a budget, tracking stocks, listing sports statistics, or planning and tracking professional goals.
Create at least 5 rows of data with 3 columns
Format the new table. Change each of the following to something other than the default.
Style
Font type
Font size
Add a border around the table.
Create range names for each column.
Sheet tabs
Rename Sheet 1 tab with your first name
Add a second sheet tab and name it “CMR 282”
Change the color of the sheet tab to something other than the default.
Move CMR 282 tab so it is the first tab in the workbook
On the sheet named CMR 282, add your name to cell D2.
Change the font size to 14
Change the font type to Times New Roman
Save the file, and add your unique ID to the file name.
Grading
Points will be deducted for not completing or incorrectly completing any part of the assignments.
Submit the following files:
M1 Assignment 1 uniqueID.xlsx
M1 Assignment 2 uniqueID.xlsx

WRITE MY ESSAY