Excel Excellence
What Excel function adds a range of numbers together?
SUM
What is the name of this event?
Forecasting Feud
Who are our Co-Presidents?
Max and Navya
What OMBA term describes the maximum number of assignments you can realistically handle in one day?
Capacity
What does OMBA stand for?
Operations Management and Business Analytics
What Excel function searches vertically for a value in a table?
VLOOKUP
What company came to OMBAS last week?
(BONUS: name the recruiter!)
KPMG
(BONUS: Erica)
Which e-board member can name all 195 countries?
Nyssa
What OMBA term describes the single group member who everyone is waiting on to finish their part before anyone else can move forward?
Bottleneck
Who is the professor for BMGT385? (Hint: They are also the new OMBA chair!)
John Silberholz
What type of cell reference does not change when copied to another cell.
(BONUS: what symbol locks a cell reference?)
Absolute reference
(BONUS: Dollar sign $)
What was the program we did a workshop on this semester?
R-Studio
Which e-board member loves matcha lattes?
Jamie
What OMBA time-series component would describe a steady improvement in your GPA over multiple semesters?
Trend
Which OMBA class is recommended to take soon after taking BMGT230 (business statistics)?
BMGT430: Data Modeling in Business
What does =COUNTIF(A1:A5,">=10") return?
(See slides!)
4
Who was the first company that came to our meetings last semester?
Morgan Stanley
Which e-board member has been swarmed by a gang unit in Atlanta?
Yonael
What OMBA term would you use to describe how you would redesign your walk to class?
Lean / Six Sigma
What is the name of the optimization extension tool used in Excel in BMGT332?
Excel Solver
Which EXCEL function can be used to combine the texts to write “Jim 4 5”
(See slides!)
=CONCAT
Based on last week’s workshop in R, how would you create a model in R using y, x1 and x2? (Hint: use lm(equation))
lm(y ~ x1 + x2)
What is Nidhi’s deepest darkest fear, and what happened in her most recent dream about it?
Fear: Squatters
Dream: Family went out of town for the weekend, she came home before they did, noticed the basement lights were on even though they were left off, a random man was peaking out the window and then disappeared.
(Themes: family/other people, basement/dark room, lights, window, out of town/trip/weekend, separation from a group/alone, stranger/random man/stalker, police, hallucinations, phone call)
What kind of forecasting method assumes that next week’s workload will be identical to this week’s workload? (A __ forecasting method)
Naive
According to the UMD website, what three math classes are strongly advised for students interested in graduate work in OMBA to complete in addition to lower level courses?
MATH141, MATH240 and MATH241