Excel Knowledge
=sum()
What is our main reporting system?
Atlas
What are the three primary colors?
Red, Blue, Yellow
What are the three types of sales teams Sales Enablement supports?
HSE, Clinical, Post Acute
what are the two main shows that were filmed in Wilmington NC?
Dawsons Creek and One tree Hill
What is the main function in Excel would you use to reference data from a separate data worksheet or workbook?
=VLOOKUP OR =HLOOKUP
Atlas, Enginuity, IPrice
What is the 6th planet from the sun?
Saturn
What are the four main proactive reports we send out monthly?
Red/Green Report, Gap Report, Interactive Dashboard, Heatmaps
What show included the TV "Couple to be" Cory and Topanga?
Boy Meets World
What Formula can you use to hide errors in excel?
What specific Dashboards do we use from Enginuity to complete a QBR?
Dynamic Dashboard and Out of Channel Business Review
What country hosted the first Olympics?
Greece
Who are all of the Sales managers and the regions they cover?
Craig Pfizenmaier -North Eastern Region
Michelle Capizzi-Eastern
Shannon Lothrop- Southeast
Amanda Groh-Central
Jennifer Baldon-West
Chris Trovato-Central
Tim Walsh-West
Neil Correia - West and east
How many seasons of Greys Anatomy are there?
17
What is a popular way to highlight values based off text/ numbers/ greater and less than situations?
Conditional Formatting
What are three things Cardinal Market can show us?
Allocation Reports, Alternatives, availability, product information, product comparison, pricing
How many Super Bowls have the Patriots won?
6
On average how much time do we give back to the sales teams by taking on their requests?
Averaging 13 hours of time given back
Name three different ways to stream tv shows and movies.
Netflix, Hulu, Amazon Prime
Other than the VLOOKUP and HLOOKUP functions, what is the other formula to reference data from a different worksheet or workbook?
INDEX + MATCH
Below is the actual formula
=INDEX(list of values, MATCH(what you want to lookup, lookup column, sorting identifier)),
What system can provide a roadmap for customers to show them cost savings, cross alternatives, current and new spend, and product standardization?
SmartDeal
What was the first colored Disney Film?
Snow White and Seven Dwarfs
Name all of the requests that we handle on a day to day basis
Crosses, NBP, Reporting a and b, projects, pricing, general, QBRS
Name five of the main characters in the office and the dates from when the show ran.
Michael, Jim Dwight, Pam , Stanley, Kevin ,Angela
2005-2013