Microsoft Excel

Getting the total cash inflow of organization’s annual financial report.

• And function

• Average Function

• If Function

• Sum Function

Add a condition which will ensure that the passing grade is 75.

• And function

• Sumif Function

• If Function

• Average Function

Student A wants to determine his/her overall average grade.

• And function

• Average Function

• If Function

• Sum Function

During the midst of Pandemic, the authorities want to easily determine the lowest number of

COVID-19 cases in the country.

• Min Function

• Median Function

• Max number

• Standard Deviation Function

The researchers want to find out the standard deviation of their population for their respondents.

• Count Function

• Standard Deviation Function

• Mode Function

• And Function

 Microsoft Excel can be used to organize, input and analyze data in the spreadsheet and it ensures that no incorrect data can be entered in it if programmed properly.

• True

• False

The SUM function can be used to determine the total of selected range that satisfy a given criteria.

• True

• False

The =STDEV.S function is used to get the standard deviation of the population.

• True

• False

The MAX function allows user to see the highest value of the range.

• True

• False

The formula for SUMIF function is =SUMIF(range,criteria)

• True

• False