Professional Courses
Industry-relevant training in Business, Technology, and Design to help professionals and graduates upskill for real-world careers.
Categories
Interactive Games
Fun, engaging games to boost memory, math fluency, typing speed, and English skills—perfect for learners of all ages.
Typing
Memory
Math
English Adventures
Knowledge
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 related to the topic.
Question 1
Easy
Write an Excel formula to calculate the average of cells A1 to A5 ignoring any blanks.
💡 Hint: Use AVERAGEIF to exclude blanks.
Question 2
Easy
What does the VLOOKUP function do?
💡 Hint: Think about how it matches data.
Practice 4 more questions and get performance evaluation
Interactive Quizzes
Engage in quick quizzes to reinforce what you've learned and check your comprehension.
Question 1
What function will you use to find the average of non-blank cells in a range?
- SUM
- AVERAGEIF
- COUNT
💡 Hint: Think about how you could filter or ignore certain entries.
Question 2
True or False: VLOOKUP can only search for values in a single column.
- True
- False
💡 Hint: Consider how the VLOOKUP operates within a table.
Solve 1 more question and get performance evaluation
Challenge Problems
Push your limits with challenges.
Question 1
Create an Excel formula that extracts the top three highest sales amounts from a sales report listed in a CSV file.
💡 Hint: Think about the 'LARGE' function, which identifies the highest values.
Question 2
Write a prompt that utilizes both SUMIF and AVERAGEIF in a single task to analyze performance metrics from a dataset.
💡 Hint: Consider how both functions can leverage criteria.
Challenge and get performance evaluation