An Excel formula has been entered in cell B9 which gives different results according to different...

Transcribed Image Text:

An Excel formula has been entered in cell B9 which gives different results according to different values in cells B2 to B8. Here are the two examples: Student Name Attendence Emma Present 3. Liam Absent Olivia Absent Noah Present 6. Ava Absent Lucas Absent Are there more students absent TRUE 9 than present? 10 Student Name Attendence Emma Present Liam Absent Olivia Absent Noah Present Ava Present Lucas Absent Are there more students absent FALSE 9 than present? 10 Here is the formula in cell B9. =COUNTIF (B2:87, Blank 1) < COUNTIF(B2:B7, Blank 2 You need to fill in the two blanks so that the formula can show the result correctly as described above. You need to write the answers clearly in the boxes below. You only need to write a string in each answer. There is no space anywhere in the result. You need to write the correct big/small letters in the string. Blank 1 is Blank 2 is An Excel formula has been entered in cell B9 which gives different results according to different values in cells B2 to B8. Here are the two examples: Student Name Attendence Emma Present 3. Liam Absent Olivia Absent Noah Present 6. Ava Absent Lucas Absent Are there more students absent TRUE 9 than present? 10 Student Name Attendence Emma Present Liam Absent Olivia Absent Noah Present Ava Present Lucas Absent Are there more students absent FALSE 9 than present? 10 Here is the formula in cell B9. =COUNTIF (B2:87, Blank 1) < COUNTIF(B2:B7, Blank 2 You need to fill in the two blanks so that the formula can show the result correctly as described above. You need to write the answers clearly in the boxes below. You only need to write a string in each answer. There is no space anywhere in the result. You need to write the correct big/small letters in the string. Blank 1 is Blank 2 is

Answer rating: 100% (QA)

Please find the syntax COUNTIFB2B7Present COUNTIFB2B7Absent Note Kindly please insert the ... View the full answer