Home > Microsoft Excel > Quizzes > Harvard Spreadsheet Modeling
Harvard Spreadsheet Modeling
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 18% • Most missed: “=SUMIFS”
Harvard Spreadsheet Modeling
Time left 00:00
25 Questions

1. you can use MATCH and INDEX together to find the values of a certain product in a certain month. For example, Pear Charlotte in the month of April produces a number in the data chart which symbolize these two things together.

2. Ctrl-Tab

3. pivot table, and separate information

4. prescriptive model

5. deterministic model

6. control shift asterisk

7. The SUMPRODUCT function multiplies the corresponding components of each cell range. If one cell range is a row with n cells, then the other cell range must also be a row with n cells

8. You can do this by going into

9. =

10. discrete random variable

11. Ctrl-END on mac

12. Allows excel to find patterns. - For example, in a list of full length names, the computer will recognize that you only want the last name after entering the last names of the first two people in the list. - It will also work if you want to make an email list and take the last name of the person and add '@bakery.com'

13. Goes to a dialogue box

14. stochastic model

15. F9 key in key with formulas

16. ALT key on a mac

17. circular reference(s)

18. Page Down

19. table feature

20. LARGE(cell range, k) returns the kth largest number in a cell range.

21. spinners

22. Uniform random variable

23. Solver model: If the objective is to determine prices that maximize profit then...

24. continuous random variable

25. Step 3 of the model-building process

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Excel Exam 2 WGU Spreadsheet Formula Basic Microsoft Excel Practice Test Prove It - Microsoft Excel Test Microsoft Excel (MS Excel) Practice Test: All Topics Counting and Rounding Formulas Useful Excel Vocabulary Management Science MGSC 290 Final Excel Fundamentals Test (Upwork) Prove It - Microsoft Excel 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.