Practice - Using Formulas and Functions
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What does the SUM function do?
💡 Hint: Think about its role in calculations.
Explain the function of the NOW() function.
💡 Hint: Consider how this might be useful in tracking changes.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does the COUNT function do?
💡 Hint: Think about its name—what does it imply?
True or False: The ROUND function can only round numbers up.
💡 Hint: Consider how rounding affects a number.
3 more questions available
Challenge Problems
Push your limits with advanced challenges
Create a spreadsheet that calculates the final grade of students based on scores in three categories: assignments, midterms, and finals. Use IF to determine pass/fail based on the average.
💡 Hint: Break it down into parts: calculate average first, then decide.
Use DATEDIF to find out how many months have passed since a specific date in A1 and return a message indicating if it’s more than 6 months.
💡 Hint: Focus on breaking the problem into checking the month difference.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.