Spreadsheet Gr8 Prior Knowlege

What formula can be used to calculate the total score?

• =SUM(B1,B11)

• =SUM(B2:B11)

• =TOTAL(B1-B11)

• =ADD(B2:B11)

What formula can be used to calculate the average score?

• =AVERAGE(B2:B11)

• =AVERAGE(B2-B11)

• =MEDIAN(B2:B11)

• =AVERAGE(B2,B11)

Which formula checks if Sara's score is greater than 60?

• =IF(B3>60,"Pass","Fail")

• =IF(B3<60,"Pass","Fail")

• =IF(B3="Sara",60)

• =IF(A3>60,"Pass","Fail")

What is the result of =SUM(B2,B4)

• 170

• 140

• 100

• 90

What does the function =IF(B5<50,"Fail","Pass") return?

• Pass

• Fail

Which formula finds the average of just Ali and Aisha’s scores?

• =AVERAGE(A2,A7)

• =AVERAGE(B2,B7)

What is the result of =IF(B9<40,"Fail","Pass")?

• Pass

• Fail

What will =IF(B6>85,"Excellent","Good") return?

• Good

• Excellent

What does the AutoFill feature in Excel do?

• It sorts data in alphabetical order.

• It changes the font color based on cell values.

• It deletes empty cells in a worksheet.

• It automatically completes a series or pattern based on selected cells.

Ahmed owns a grocery shop with all information of the products in one spreadsheet. He wants to find the total profit obtained from only milk products. What function do you think he'd use?

• SUM

• SUMIF

• AVERAGE

• COUNTIF