Posts

Showing posts from March, 2022

Learn (Gujarati Typing) Terafont-Varun Keyboard Layout by Sama Soyab

Image
 For Gujarati Typing : (by Sama Soyab) Required : Terafont-Varun Font  After Successfully Installed Terafont Varun Open Any Text Editor or any program. Select Font Terafont-Varun -> Ok   Search Topics : Sama Soyab, Learn terafont varun, Learn terafont chandan, Learn terafont gujarati to english translation, Learn terafont varun keyboard, Learn terafont converter, Learn terafont varun zip, Learn terafont keyboard, Learn terafont kinnari, Learn terafont akash, Learn terafont aakash, Learn terafont akash ttf, Learn terafont aakash gujarati download, Learn terafont akash keyboard, Learn terafont akash download for windows 10, Learn terafont akash font download, Learn terafont arun, Learn terafont border, Learn terafont chandan keyboard, Learn terafont-chandan font, Learn tera font chandana, Learn convert terafont to shruti, Learn convert terafont varun to shruti, Learn terafont varun chart, Learn terafont download, Learn terafont download for windows 10, Learn terafont downlo

Marksheet in Excel Formula Tutorial by Sama Soyab

Image
  Open Microsoft Excel -> Three Steps to Open MS Excel 1. Double Click on Ms Excel Icon 2. Start-> All Programs-> Microsoft Office -> Ms Excel 3. Start->Run-> Excel-> Ok  => Fill the detail as above Image Enter Detail Column A to I ->  Total : =SUM(C4:I4) SUM formula use for Calculate Sum of Total Subject Mark - J4 -> Enter above Formula  =SUM(C4:I4)   Min : =MIN(C4:I4) Min formula use for Calculate Minimum Value of Subject Mark - K4 -> Enter above Formula  = MIN(C4:I4) Max : =MAX(C4:I4) Max formula use for Calculate Maximum Value of Subject Mark - L4 -> Enter above Formula  = MAX(C4:I4)   Average : =if(N4="Fail","***",AVERAGE(C4:I4)) Average formula use for Calculate Average Value of Subject Mark - M4 -> Enter above Formula  = =if(N4="Fail","***",AVERAGE(C4:I4))   Result : =If(K4>=35,"PASS","FAIL") IF formula use is Conditional Formula We are check If Minimum Marks is Greater Th

Find Age in Excel formula Tutorial by Sama Soyab

Image
  Open Microsoft Excel -> Three Steps to Open MS Excel 1. Double Click on Ms Excel Icon 2. Start-> All Programs-> Microsoft Office -> Ms Excel 3. Start->Run-> Excel-> Ok  => Give The Column Name in First ROW Enter Detail Column A2,B2,C2 ->  Find Year : =DATEDIF(D5,TODAY(),"Y") DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date. - D5 -> Is Cell Address where We entered Birth Date.  - TODAY() -> This Excel Formula which shows current date. - "Y" -> This is used for shows answer in Year Find Month : =DATEDIF(D5,TODAY(),"Y") DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date. - D5 -> Is Cell Address where We entered Birth Date.  - TODAY() -> This Excel Formula which shows current date. - "YM" -> This is used for shows answer in Yea