INSET-ICT POST TEST

How to easily rename a sheet in Excel?

• Double Left Click

• Double Right Click

• Single Left Click

• Single Right Click

The number of male and female learners needs not to match in the school age and school form 2.

• TRUE

• FALSE

There are 25 registered female learners at the end of the month. What is the percentage of enrolment as of end of the month when there are 26 female learners as of first Friday of the school year?

• 100

• 98

• 96

• 94

• 17.79

• 15.13

We can find "Protect Sheet" and "Protect Workbook" in what command group in Excel?

• File

• Home

• Data

• Review

Using the COUNTIF function in Excel, you wanted to identify the number of learners who failed. What will be your criteria?

• ">75"

• ">=75"

• "<75"

• "<=75"

We can also use the COUNTIFS function to count the number of learners whose grades range from 85-89.

• TRUE

• FALSE