Home > Microsoft Excel > Quizzes > Excel Formulas and Functions
Excel Formulas and Functions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 58% • Most missed: “Returns a four-digit year (a number from 1900 to 9999) given a date value”

Excel formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more.

Excel Formulas and Functions
Time left 00:00
25 Questions

1. Returns the y-axis intersection point of a line using x-axis values and y-axis values

2. Returns the average of all numbers in a range of cells, based on multiple criteria

3. Counts the number of cells in a range, that meets a given criteria

4. Returns the type of a value

5. Returns the standard deviation of a population based on the entire population of numbers

6. Returns the #N/A error value

7. Returns the serial number of a time

8. Returns a reference to a range that is offset a number of rows and columns

9. Returns the interest payment for an investment

10. Returns the number in Thai text

11. Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position

12. Returns the accrued interest for a security that pays interest on a periodic basis

13. Returns the modified internal rate of return for a series of cash flows

14. Returns the seconds (a number from 0 to 59) from a time value

15. Returns the inverse hyperbolic cosine of a number

16. Extract a substring from a string, starting from the left-most character

17. Returns the number of combinations for a specified number of items and includes repetitions

18. Returns the sum of the squares of a series of values

19. Returns the beta distribution

20. Returns the product of the numbers in a column in a list or database, based on a given criteria

21. Returns the accrued interest for a security that pays interest at maturity

22. Compares an expression to a list of values and returns the corresponding result

23. Returns the result of a number raised to a given power

24. Used to check for a value that is not text

25. Returns the inverse hyperbolic tangent of a number

⚡ 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.