2<\/p>\n
You just got hired as a Business Analyst by a company called \u201cRed Rocks\u201d in Virginia. Your manager is computer illiterate and has made it clear that he is going to rely heavily on you to do a lot of data analysis for him. Using the RedRocksData workbook provided in a separate file, your first three tasks are the following:<\/p>\n
Task#1: Rather than him going through the list of employees to find the organization and the $ amount donated by each employee, he wants you to make it easier for him using VLOOKUP so that he can enter an Employee ID number and quickly see both the Organization and the $ amount side by side right above the report column headers. He wants the Employee ID label in cell A1, the Organization label in cell D1, and the Amount label in cell G1. He wants you to put the report column headers in Row4 starting in cell A4. This first worksheet should be named \u201dRedRocks Employees\u201d. How can you do that? (4 points)<\/p>\n
Task#2: In the same worksheet, your other task is to categorize the values in the Amount column by setting multiple rules for formatting. He wants you to format the $ amount in different colors based on the following rules:<\/p>\n
> $135 – Green Fill with Dark Green Text<\/p>\n
Between $100 and $135, – Yellow Fill with Dark Yellow Text<\/p>\n
< $100 – Light Red Fill with Dark Red Text (3 points)<\/p>\n
Your third task is to create a pivot table in a separate worksheet called “Summary” in the same RedRocks_Data workbook with only the following information: Employee First Name and $ Amount with the ability to filter by the Organization. Your manager insists that he wants to see the $ Amount formatted as currency with two decimals. (3 points)<\/p>\n
Your pivot table should look like this:<\/p>\n","protected":false},"excerpt":{"rendered":"
2 You just got hired as a Business Analyst by a company called \u201cRed Rocks\u201d in Virginia. Your manager is computer illiterate and has made it clear that he is going to rely heavily on you to do a lot of data analysis for him. Using the RedRocksData workbook provided in a separate file, your […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-105992","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/105992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=105992"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/105992\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=105992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=105992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=105992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}