Excel Formula Application Challenge

You have a list of sales figures for the past year in cells A1 to A12. You want to find out the total sales for the year. Which formula should you use?

• `=IF(A1:A12)`

• `=SUM(A1:A12)`

• `=CONCAT(A1:A12)`

• `=MAX(A1:A12)`

You are given a list of student scores in cells B1 to B10. You need to find the highest score among them. Which formula will help you achieve this?

• `=MIN(B1:B10)`

• `=AVERAGE(B1:B10)`

• `=MAX(B1:B10)`

• `=RANDBETWEEN(B1, B10)`

You have a dataset of product prices in cells C1 to C20. You want to find the average price of the products. Which formula should you use?

• `=SUM(C1:C20)`

• `=AVERAGE(C1:C20)`

• `=IF(C1:C20)`

• `=CONCAT(C1:C20)`

You need to generate a random number between 1 and 100 for a lottery draw. Which formula will you use?

• `=RANDBETWEEN(1, 100)`

• `=MAX(1, 100)`

• `=MIN(1, 100)`

• `=SUM(1, 100)`

You have a list of expenses in cells D1 to D15. You want to find the minimum expense. Which formula should you use?

• `=MAX(D1:D15)`

• `=SUM(D1:D15)`

• `=MIN(D1:D15)`

• `=AVERAGE(D1:D15)`

You want to create a sentence by joining the text in cells E1, E2, and E3. Which formula will help you concatenate these cells?

• `=SUM(E1, E2, E3)`

• `=CONCAT(E1, E2, E3)`

• `=IF(E1, E2, E3)`

• `=MAX(E1, E2, E3)`

You have a list of numbers in cells F1 to F10. You want to check if the number in F1 is greater than 50 and return "Pass" if true, otherwise "Fail". Which formula should you use?

• `=IF(F1 > 50, "Pass", "Fail")`

• `=SUM(F1:F10)`

• `=MAX(F1:F10)`

• `=MIN(F1:F10)`

You have a list of temperatures recorded over a week in cells G1 to G7. You want to find the average temperature. Which formula should you use?

• `=SUM(G1:G7)`

• `=AVERAGE(G1:G7)`

• `=MAX(G1:G7)`

• `=MIN(G1:G7)`

You need to determine the highest value in a range of cells H1 to H20. Which formula will you use?

• `=MIN(H1:H20)`

• `=MAX(H1:H20)`

• `=SUM(H1:H20)`

• `=AVERAGE(H1:H20)`

You want to generate a random number between 10 and 50 for a game. Which formula should you use?

• `=RANDBETWEEN(10, 50)`

• `=MAX(10, 50)`

• `=MIN(10, 50)`

• `=SUM(10, 50)`