sum = Add numbers, it is basically sumission =SUM(number1, [number2], ...) Example: =SUM(A1:A7) ⚡ Tips: You can use AutoSum for quick addition: Select a cell → click Home → AutoSum (Σ) → press Enter . Shortcut key: Alt + = (automatically inserts =SUM() ). Min = TO FIND MINIMUM VALUE =MIN(A1:A12) max = TO FIND MAXIMUM VALUE =MAX(A1:A13) Right ExamPle: =RIGHT(E2,10) basically mere pas number hai 91 country code ke sath, main chahta hu 91 code ke bad right se 10 numbers mujhe nikal ke aa jaye yaha E2 mera column number hai and 10 jo mujhe chahiye right se Cases: किसी product code ke last digits निकालने के लिए किसी date ya year ke last 2 digits निकालने के लिए किसी naam ke last letters निकालने के लिए Note: if I want to paste horizontally number then will use 'paste ke option me transpose left == left se digits extract krne ke liye will use this =LEFT(E2,2) E2 IS CELL AND 2 IS DIG...
Q- how to Print Hello World print("Hello World") Variables in python ------- age = 30 #variable should be intutive so that we can learn any time print(age) Note: Shift+Enter is shortcut to run command 2) ' #' this is for writing the comment in python Rules for Variables--- Variable can not be start with any number like - 1age Number can use in between and end with variable like - age1 age2 Special characters are not allowed expect _ (underscore) like - age_my Space not allowed in variable Python is case sensitive Way to define Variable --- age1,age2 = 30,25 age1 = 30 age2 = 25 age1=age2=30 #if 30 age for both variable >> Data type the type of data is basically data type Integer = age1 to age3 is basically integer , Integer is basically full number lets check = type(age1) #it will give u print int float= basically decimal values Interest = 30.24 type(Interest) #answer is float Message = ...
Comments
Post a Comment