ms excel formulas

sum =SUM(B3:B14)
sumif  =SUMIF(B3:B14,"<100")
count  =COUNT(B3:B14)
counta  =COUNTA(B3:B14)
text =COUNTA(B3:B14)-COUNT(B3:B14)
count blank =COUNTBLANK(B3:B14)
total cells  =COUNTA(B3:B14)+COUNTBLANK(B3:B14)
average =AVERAGE(B3:B14)
min =MIN(B3:B14)
max =MAX(B3:B14)
small =SMALL(B3:B14,1)
large =LARGE(B3:B14,1)

Comments

Post a Comment

Popular posts from this blog

EXCEL FORMOLAS

( SUM FARMOLAS ) =SUM (A1. A20) =SUM (A1:A20) =SUM (A1, A2, A4, A20) IF FARMOLA =IF (C4>50,”PAAS”,”FAIL”) Excel formulas are used to support operators do < , Is small >, large = , equal <> , that small is big >= , bigger equals <= , is equal small IF AND FARMOLA (If you have a choice in what formula would blind Addiction) =IF(AND(F1>5,G4>500),G4*7/100,”0”)
Read more

COREL DRAW

Image
Corel Draw is a software through which we can change needed in your photos۔ kkj Coral Draw this form if you are huta is open kkj The before picture from your computer to open hy is it like Ya kkj
Read more

COMPUTER BASIC INFORMATION

Image
kkkj ICON IF YOU DESCRIBE SOMETHING OR SOMEONE AS AN ICON, YOU MEAN THAT THEY ARE IMPORTANT AS A SYMBOL OF A PARTICULAR THING. MY COMPUTER MY COMPUTER IS ALSO A ICON WHICH HAVE A SPECIFIC INTERNAL DISC WHICH SHOWS YOUR SAVING DATA INTO THE COMPUTER IN SPECIFIC DRIVES WHICH MAKE BY ITS ON USE. MY DOCUMENTS ITS A FOLDER MAKE BY A MICROSOFT  WHICH WORKES INTO  ANY SOFWARE WHEN ANY FILE SAVE THEN ITS FIRST PATH HAVE A MY DOCUMENT FOLDER. RECYCLE BIN ITS A FOLDER IN WHICH YOU ARE DELETED SOME FILE THEY ARE IN THE RECYCLE BIN UNTIL YOU DONT DELET OR SAVE THE FILE AGAIN. MY NETWORK PLACES ITS A ICON IN WHICH YOU CONNECTED SOME PC's AND YOUR COMPUTER I S BEHAVE AS A SERVER THEN YOU SEE THE WORKING OF THESE COMPUTERS ON YOUR NETWORK PLACE. INTERNET EXPLORER ITS AN ICON WHICH IS USED TO CONNECT OR TO OPEN THE WEB SITES BY CLICKING THIS ICON.
Read more