Excel Quiz Basic Excel Quiz 1. Which formula is used to calculate the sum of a range in Excel? A) =SUM(A1:A10) B) =ADD(A1:A10) C) =COUNT(A1:A10) D) =SUMIF(A1:A10, ">10") 2. What does the formula =AVERAGE(A1:A10) calculate? A) Total sum B) Median C) Arithmetic mean D) Highest value 3. How do you concatenate two text strings in Excel? A) =ADD(A1, B1) B) =CONCATENATE(A1, B1) C) =SUM(A1, B1) D) =JOIN(A1, B1) Your Name: Submit
No comments