Question: 1 . Rename the tab to TAB 1 . Copy and paste the attached file into a fresh / clean excel worksheet. 2 . Rename

1. Rename the tab to TAB 1. Copy and paste the attached file into a fresh/clean excel worksheet.
2. Rename the tab to TAB 2. Add a column after column F, title it Updated Days Required, use text wrap, add 75 days to the existing "Days required" column, Hide Days required column. Hint: You can link or perform a copy paste.
3. Rename the tab to TAB 3. Sort Project name from A-Z. Change the colors in the heading, change the font and change the color of the font and font size and style. Your choice.
4. Rename the tab to TAB 4. Create two separate formulas using "IF" "AND" "OR" of the three options you need to use two. Describe what you are wanting to find out then complete the formula. You can make this as easy or complex that you want.
5. Rename the tab to TAB 5. Create a dropdown box whereby you can select the "Assigned to" person from the entire drop-down list.
6. Rename the tab to TAB 6. Create two different style graphs from the data provided.
7. Rename the tab to TAB 7. Create a pivot table with slicers.
8. Rename the tab to TAB 8.Answer the following question - Who is the person from which project that is 100%.
9. Rename the tab to TAB 9. Answer the following question - Who is the person who is assigned which with the least progress.
10. Rename the tab to TAB 10. Answer the following question - From either TAB 8 or TAB 9 create a graph from your output.
11. Rename the tab to TAB 11. Create an interactive dashboard as illustrated during our last class. Use the links provide during class. You have complete control as to what you are going to represent and how you are going to do it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!