What function returns the number of characters in a text string? LEN() LEFT() TEXT() CHAR()

Which of the following will calculate the average of numbers in cells A1 to A10, excluding blank cells? =SUM(A1:A10)/10 =AVERAGE(A1:A10) =MEDIAN(A1:A10) =MODE(A1:A10)

What does =IF(AND(A1>10, B1<5), "Yes", "No") return if A1 = 15 and B1 = 3? Yes No True Error

What does the formula =MATCH(25, A1:A10, 0) do? Finds the value 25 and returns its position in the list Compares two ranges Returns the row number of 25 Looks for the closest match less than 25

Which function returns the current system date and time? =NOW() =TODAY() =TIME() =DATE()

Which function would you use to find the largest number in a range? MAX LARGE BIG TOP

What is the result of =ROUND(3.14159, 2)? 3 3.15 3.142 3.14

Which function returns TRUE if all arguments are TRUE? COUNTA() =COUNTIF() =COUNT() =COUNTBLANK()

What does =TRIM(" Hello World ") return? "HelloWorld" "Hello World" "Hello" "Hello World "

What does =LEFT("Excel", 2) return? Ex El xl ce

Which function extracts the year from a date? =DATE(YEAR(A1),…) =YEAR(A1) =MONTH(A1) =TEXT(A1)

What is the use of ISERROR() function? To count errors To ignore errors To check if a value is an error To fix errors

What is the result of =MOD(10, 3)? 3 1 0 2