Excel 公式問題

1) This question ask you to input seconds in Cell B2. The seconds will be converted in hours, minutes and seconds stored in CellA4, Cell B4 and Cell C4 respectively.
Enter formula and functions in following cells.

Hint: MOD() and QUOTIENT()

Seconds : 5000 計以下3樣
Hour Minutes Seconds
需要excel條式點計出黎


2) display the number of absent students in term test
3)shows whether the student has his average mark of core subjects below 50.
4)I2 shows whether one of core subjects taken by a student is below 40 marks.

以上問題請話比我知係用邊條式計出黎, 詳細