2 excel assignments
1. Open up EXCEL and title it Learning Excel 1 – [Your full name].
2. Name the Bottom sheet with your First Name
3. On the top row, type the follow.
1. COLUMN A –> [blank]
2. COLUMN B –> Names
3. COLUMN C –> Colors
4. COLUMN D –> Subjects
5. COLUMN E –> States
6. COLUMN F –> Animals
7. COLUMN G –> Numbers
8. COLUMN H –> Money
4. Under COLUMN B, type 10 names of people.
5. Under COLUMN C, type 10 different colors.
6. Under COLUMN D, type 10 types of school subjects.
7. Under COLUMN E, type 10 different states.
8. Under COLUMN F, type 10 different animals.
9. Under COLUMN G, type 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.
10. Under COLUMN H, type 30, 60, 100, 230, 450, 761, 231, 876, 1000, 1500.
1. Add boarders to all the cells.
2. Delete the words in these cells: B3, C6, E5.
3. Apply Wrap Text to one of the cells adjacent to an empty cell.
4. Merge a cell with an empty cell.
5. Change the font sizes on the top ROW.
6. Color the background font for ROW 1 to Blue.
7. Color the words in ROW 1 to RED.
8. Bold the words in ROW 1.
9. Increase the fonts to 15 point fonts.
Add boarders to all the cells.
Delete the words in these cells: B3, C6, E5.
Apply Wrap Text to one of the cells adjacent to an empty cell.
Merge a cell with an empty cell.
Change the font sizes on the top ROW.
Color the background font for ROW 1 to Blue.
Color the words in ROW 1 to RED.
Bold the words in ROW 1.
Increase the fonts to 15 point fonts.
Part 3
Apply the SUM funtions to COLUMN G.
Apply the SUM Funtion to COLUMN H.
Add the numbers from COLUMN G to COLUMN H, and create COLUMN I with it.
Apply the MONEY sign to COLUMN I.
Create two extra Decimal Formatting for COLUMN I.
Part 4
Copy and paste the info and paste it below your info.
The new info should be paste from A15 to A25.
Apply the Subtraction Funtion to COLUMN H.
Create a new worksheet.
The name of the second worksheet should be your last name.
PART 5
Create 2 charts.
Create a PIE GRAPH for the top part of this EXCEL sheet.
Create a BAR GRAPH for the second part of this EXCEL SHEET.
——-
***Second assignment pivot table and chart using patient id data set***
1. Pivot Table:
* You will create a Pivot Table using the dataset provided. The table should organize data by Services and Providers, with a count of how many times each service was provided. Follow the step-by-step guide to ensure your Pivot Table is set up correctly.
* Make sure you Title the assignment with your Full Name. For example: Pivot Table – first name and last name.
2. Pivot Chart:
* Using the same data, you’ll also create a Pivot Chart. The chart should display Providers and Services in the rows, with the Services counted and visualized. Be sure to add data labels to your chart to make it clear and informative.
* Make sure you Title the assignment with your Full Name. For example: Pivot Chart – First name and last name .