Boost your Excel skills with this quiz. Answer questions on Excel functions and formulas to master data analysis.
What function adds all numbers in a range?
What does the AVERAGE function do?
Which function returns the number of cells with numbers?
What function returns the largest number?
What does the IF function do?
Which function counts non-empty cells?
What does VLOOKUP do?
Which function checks multiple conditions?
What is the result of =LEN("Excel")?
Which function rounds numbers up?
What does =TODAY() return?
Which function gives the current time?
What does CONCATENATE do?
What does the TRIM function do?
What does =LEFT("Excel",2) return?
What is the use of MID function?
What does the FIND function return?
Which function can be used for error handling?
What does =MOD(10,3) return?
Which function calculates loan payments?
What does =TEXT(1234,"$#,##0") return?
What is the function for conditional sums?
Which function returns the column number?
What function removes duplicates?
Which function returns TRUE if cell is blank?
What does the INDIRECT function do?
What is the result of =ROUND(2.49,0)?
Which function finds position in a range?
What does =ISNUMBER("123") return?
Which function extracts the year from a date?
Learnpages and our partners use cookies to store and access information such as unique IDs to deliver, maintain, and improve our services and ads.
Privacy Statement Terms & Conditions
Control how we use your data. You may object to processing based on Legitimate Interest.
