Home > CompTIA A+ Exam > 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 number of combinations for a specified number of items

2. Returns the sum of the squares of corresponding items in the arrays

3. Returns the standard deviation of a population based on a sample of numbers

4. Returns the ISO week number for a date

5. Returns the quartile from a set of values

6. Returns a text to a number specifying the decimal and group separators

7. Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number

8. Returns the interest rate for an annuity

9. Returns the base-10 logarithm of a number

10. Returns the payment amount for a loan

11. Returns the serial number of a time

12. Extracts a substring from a string (starting at any position)

13. Returns the number of permutations for a specified number of items

14. Returns the predicted exponential growth based on existing values provided

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

16. Returns the covariance, the average of the products of deviations for two data sets

17. Returns the number of columns in a cell reference

18. Returns a number rounded to a specified number of digits

19. Convert a number from one measurement unit to another measurement unit

20. Returns a number truncated to a specified number of digits

21. Returns the number of cells in a column or database that contains numeric values and meets a given criteria

22. Returns a random number that is greater than or equal to 0 and less than 1

23. Returns the variance of a population based on the entire population of numbers

24. Returns the cumulative beta probability density function

25. Returns the number of periods for an investment

⚡ Recently practiced quizzes in this topic
Live quiz activity
Comptia A+ Port Numbers CompTIA A+ Windows Command Line A+ Guide To IT Technical Support Glossary CompTIA A+ Certification 802 Exam Practice CompTIA A+ 220-801 Exam A+ Guide To IT Technical Support - Network Hardware CompTIA A+ 220-901 Exam Practice Questions CompTIA A+ 220-901 Practice Questions Comptia A+ 220-902 Exam Terms A+ Guide To IT Technical Support - Hard Drives and Other Storage Devices
 
❤ 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 | 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.