Excel Formula Application Quiz

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)`

• `=AVERAGE(A1:A12)`

• `=MAX(A1:A12)`

You are analyzing a dataset of student scores in a class. You want to determine the highest score achieved. Which formula will help you find this?

• `=MIN(A1:A30)`

• `=AVERAGE(A1:A30)`

• `=MAX(A1:A30)`

• `=CONCAT(A1:A30)`

You have a list of numbers in cells B1 to B10. You need to find the average of these numbers, but only if the average is greater than 50. Which formula will you use to achieve this?

• `=IF(AVERAGE(B1:B10)>50, AVERAGE(B1:B10), "Below 50")`

• `=SUM(B1:B10)/10`

• `=MAX(B1:B10)`

• `=RANDBETWEEN(1,100)`

You are tasked with generating a random number between 1 and 100 for a simulation. Which formula should you use?

• `=CONCAT(1,100)`

• `=RANDBETWEEN(1,100)`

• `=SUM(1,100)`

• `=IF(1,100)`

You have a dataset of monthly expenses in cells C1 to C12. You want to find out the minimum expense for any month. Which formula will you use?

• `=MAX(C1:C12)`

• `=MIN(C1:C12)`

• `=AVERAGE(C1:C12)`

• `=SUM(C1:C12)`

You need to combine the first name in cell D1 and the last name in cell E1 into a full name in cell F1. Which formula will you use?

• `=SUM(D1, E1)`

• `=CONCAT(D1, " ", E1)`

• `=IF(D1, E1)`

• `=MAX(D1, E1)`

You are given a list of temperatures in cells F1 to F7. You need to calculate the average temperature, but only if the average is less than 30 degrees. Which formula will you use?

• `=IF(AVERAGE(F1:F7)<30, AVERAGE(F1:F7), "Above 30")`

• `=SUM(F1:F7)/7`

• `=MIN(F1:F7)`

• `=RANDBETWEEN(1,30)`

You have a list of product prices in cells G1 to G20. You want to find the total sum of these prices. Which formula should you use?

• `=IF(G1:G20)`

• `=SUM(G1:G20)`

• `=AVERAGE(G1:G20)`

• `=MAX(G1:G20)`

You are working with a dataset of exam scores in cells H1 to H15. You need to find the lowest score. Which formula will help you achieve this?

• `=MAX(H1:H15)`

• `=MIN(H1:H15)`

• `=AVERAGE(H1:H15)`

• `=CONCAT(H1:H15)`

You have a list of random numbers in cells I1 to I10. You want to find the average of these numbers. Which formula should you use?

• `=SUM(I1:I10)/10`

• `=AVERAGE(I1:I10)`

• `=MAX(I1:I10)`

• `=MIN(I1:I10)`