Spreadsheet Formulas

All spreadsheet formulas begin with an equal(=) sign.After this symbol formula function is entered.
E.gs. of some important formulas :- 
★Concatenate
★Abs
★Average
★Char
★Code
★Count
★Counta
★Countif
★Exact
★Exp
★Fact
★If
★Indirect
★Int
★Len
★Ln
★Lower
★Log
★Median
★Max
★Min
★Pi
★Product
★Rand
★Randbetween
★Stdev
★Sum
★Sumif
★Text
★Today
★Trend
★Trim
★Upper
★Value
★Var
★Vlookup
★Hlookup

Comments

Post a Comment

Popular posts from this blog

Important laws of Cyber crimes

Sections Applicable for Cyber Crimes   Cyber Crime ITAA 2008 Act Section’s-IPC Section’s Email spoofing 66D-416,417,463,465,419 Hacking  66,43-378,379,405,406  Web-jacking 65-383  Virus attacks 43,66  Logic bombs  43,66  Salami attacks 66  Denial of Service attacks  43  Email bombing  66  Pornography & Child Pornography  67,67B-292,293,294  Bogus websites,cyberfrauds  420  Forgery of electronic records  463,465,470,471 Sending defamatory messages by email 66A-499,500  Sending threatening messages by email 66A-503,506  Financial Crime 415,384,506,511 CyberTerrorism  66F-153A,UAPA15-22  Identity Theft 66C-417A,419A  Website Defacement 65-463,464,468,469
Give me more »

Measuring units of computer storage

Measuring units of computer :- (1) Bit : 0 or 1 (2) Nibble : 4 Bit (3) Byte : 8 Bit (4) KiloByte{KB} : 1024 Byte (5) MegaByte{MB} : 1024 KB (6) GigaByte{GB} : 1024 MB (7) TeraByte{TB} : 1024 GB (8) PetaByte{PB} : 1024 TB (9) ExaByte{EX} : 1024 PB (10) ZetaByte{ZB} : 1024 EB (11) YottaByte{YB} : 1024 ZB (12) HellaByte{HB}* : 1024 YB (13) GeopByte{GB}** : 1024 HB * HellaByte sometimes also called BrontoByte{BB}. ** GeopByte is the largest unit in present time.
Give me more »

OSI Layers and their work

OSI (Open system interconnection) Layers :- (1) Application Layer :-  Manipulation of data, mail service etc. are provided, uses web browser. (2) Presentation Layer :-  Perform by OS that converts HLL to MLL, maintain encryption & decryption. (3) Session Layer :- Manages conversation between two different applications, Manages session b/w source and destination. (4) Transport Layer :-  Decides data transmission should be on parallel or single path, It breaks message into packets & maintain it should reach destination with reliability. (5) Network Layer :-   Acts as network controller, Decides which route data should take. (6) Data Link Layer :- Error controlling, Error detection bits are used. (7) Physical Layer :- Activates, maintain  & deactivate Physical connection, It converts digital bits into electrical signals. BONUS FACTS  :- Hub :-  Works on Physical Layer. Switch :- Works on Data Link Layer. Bridge :- Works on Data Link Layer. ...
Give me more »