Loading the lesson
Loading the lesson
Search AllRounder.ai
Search the courses, subjects, tracks, games and features, or jump straight to a page.
Search the courses, subjects, tracks, games and features, or jump straight to a page.
2 cards from this section. Quick, good the night before a test.
Write an Excel formula to calculate the average of cells A1 to A5 ignoring any blanks.
Use AVERAGEIF to exclude blanks.
What does the VLOOKUP function do?
Think about how it matches data.
What function will you use to find the average of non-blank cells in a range?
Think about how you could filter or ignore certain entries.
True or False: VLOOKUP can only search for values in a single column.
Consider how the VLOOKUP operates within a table.
Create an Excel formula that extracts the top three highest sales amounts from a sales report listed in a CSV file.
Think about the 'LARGE' function, which identifies the highest values.
Write a prompt that utilizes both SUMIF and AVERAGEIF in a single task to analyze performance metrics from a dataset.
Consider how both functions can leverage criteria.
5 more questions in this section. Enroll free to practise them all.
Enroll free