Excel and Pivot Table Mastery

What is the formula to calculate the sum of cells A1 to A10?

• =SUMMATION(A1:A10)

• =TOTAL(A1:A10)

• =SUM(A1:A10)

• =ADD(A1:A10)

How do you use the SUMIF function to sum values in B1:B10 where the corresponding A1:A10 values are greater than 5?

• =SUMIF(B1:B10, ">5", A1:A10)

• =SUMIF(A1:A10, "<=5", B1:B10)

• =SUMIF(A1:A10, ">5", B1:B10)

• =SUMIF(A1:A10, "5", B1:B10)

What does the IF function do in Excel?

• The IF function formats cells based on their values.

• The IF function creates charts and graphs in Excel.

• The IF function performs a logical test and returns specified values based on whether the test is true or false.

• The IF function calculates the sum of a range of cells.

How can you calculate the average of the values in C1:C10?

• =SUM(C1:C10)

• =MAX(C1:C10)

• =AVERAGE(C1:C10)

• =COUNT(C1:C10)

If a student scored 80 out of 100, what is their percentage score?

• 90%

• 80%

• 75%

• 85%

What formula would you use to find the total sales in D1:D10?

• =MAX(D1:D10)

• =AVERAGE(D1:D10)

• =COUNT(D1:D10)

• =SUM(D1:D10)

How do you apply the SUMIF function to count how many times 'Yes' appears in E1:E10?

• =SUM(E1:E10, 'Yes')

• =COUNTIF(E1:E10, "Yes")

• =IF(E1:E10='Yes', 1, 0)

• =COUNT(E1:E10, 'Yes')

What is the syntax for the IF function to check if a value in F1 is greater than 10?

• IF(F1 = 10, 'Equal', 'Not Equal')

• IF(F1 > 10, 'True Result', 'False Result')

• IF(F1 >= 10, 'Above', 'Below')

• IF(F1 < 10, 'Yes', 'No')

How do you calculate the average percentage from a range of scores in G1:G10?

• =SUM(G1:G10) / 10

• =AVERAGE(G1:G10) * 100

• =MAX(G1:G10) - MIN(G1:G10)

• =COUNT(G1:G10) * 100

If you have a total of 200 and you want to find what percentage 50 is of that total, what formula would you use?

• 30%

• 20%

• 25%

• 10%