Eset Smart Security 4.2.4..10

ESET NOD32 Antivirus System - Integrated, Real-Time Protection against viruses, worms, trojans, spyware, adware, phishing, and hackers. Best detection, fastest performance & smallest footprint. NOD32 Antivirus System provides well balanced, state-of-the-art protection against threats endangering your PC and enterprise systems running various platforms from Microsoft Windows, through a number of UNIX/Linux, Novell, MS DOS operating systems to Microsoft Exchange Server, Lotus Domino and other mail servers...

Prince of Persia (2010)

Prince of Persia: The Sands of Time 2010 Hollywood Movies Watch Online Informations : Director: Mike NewellRelease Date: 28 May 2010Genre: Action, Adventure, Fantasy, RomanceCast : Jake Gyllenhaal, Gemma Arterton, Ben Kingsley, Alfred Molina, Steve...

Windows XP Setup Simulator v1.0

Windows XP Setup Simulator is a program that teaches you how to install Windows XP, without having to worry you will mess up your hardware or software. It just simulates installing Windows XP as if it was the real setup. It reproduces every step exactly as it is in the real setup, and it does not restart your computer. This program can also be used as a guide for learning how to install Windows 2003, because the steps are very similar. The package also includes an e-book that explains every step of the Windows XP Setup and some other Windows XP Basics.

Internet Download Manager PreCracked

Internet Download Manager (IDM) is a tool to increase download speeds by up to 5 times, resume and schedule downloads. Comprehensive error recovery and resume capability will restart broken or interrupted downloads due to lost connections, network problems, computer shutdowns, or unexpected power outages. Simple graphic user interface makes IDM user friendly and easy to use.Internet Download Manager has a smart download logic accelerator that features intelligent dynamic file segmentation and safe multipart downloading technology to accelerate your downloads. Unlike other download managers and accelerators Internet Download Manager segments downloaded files dynamically during download process and reuses available connections without additional connect and login stages to achieve best acceleration performance....

Driver Genius Pro 10.0.0.526 Portable

Driver Genius Professional manage your PC to get 100% up to date Drivers and optimize PC performance. Driver Genius Professional is a powerful driver manager for Windows that can backup, restore ,search and update your drivers automatically in several mouse clicks! Driver Genius Professional is a software that backup and restore drivers.

Visit My New Website


Looking for Jobs In Gulf (Dubai, Sharjah, Abu Dhabi, Bahrain, Oman, Saudi)?

2 comments

If you are looking for job in Gulf you can should visit on below website completely free.


Click Here GulfJobPress


Official Command & Conquer TiberianSun

3 comments



EA is gaining a reputation for releasing old Command & Conquer games for free, and this is one gamer who isn’t complaining.

The last time EA offered up a free C&C title it was C&C: Red Alert to celebrate the series’ 13th anniversary. That game and C&C: Tiberian Dawn are still free to download and play, but now a third game has been added.

In an effort to help promote the forthcoming Command & Conquer 4, EA has made C&C: Tiberian Sun + Firestorm expansion free to download and play. At 1.2GB its a big download, but well worth the time to play another classic game in the series for zero dollars.

You can access all game downloads at the EA Command & Conquer Classic web page. Just scroll down to find the download button for each game. EA would also like you to click the big pre-order button for C&C 4 while you are there.

I can confirm the game works on Windows 7 and it is version 2.03.



Kubuntu 10.10 (Maverick Meerkat)

2 comments


Desktop CD

The desktop CD allows you to try Kubuntu without changing your computer at all, and at your option to install it permanently later. This type of CD is what most people will want to use. You will need at least 256MB of RAM to install from this CD.
There are two images available, each for a different type of computer:
PC (Intel x86) desktop CD
For almost all PCs. This includes most machines with Intel/AMD/etc type processors and almost all computers that run Microsoft Windows, as well as newer Apple Macintosh systems based on Intel processors. Choose this if you are at all unsure.
64-bit PC (AMD64) desktop CD
Choose this to take full advantage of computers based on the AMD64 or EM64T architecture (e.g., Athlon64, Opteron, EM64T Xeon, Core 2). If you have a non-64-bit processor made by AMD, or if you need full support for 32-bit code, use the Intel x86 images instead.


Microsoft Excel

0 comments

Microsoft excel

Definition:

“This office tool is used for accounting calculation and also different daily usage software”.

Examples:
Bill, inventory, salary sheet, etc.

File extension: .xls
Note: combination of rows and columns.

Interface of MS Excel:
1). Title bar
2). Menu bar
3). Standard tool bar
4). Formatting bar
5). Formula bar

In this bar when user applies a formula, formula automatically appears in this bar, user can edit formula with the help of this bar.

Parts of formula bar:
Formula pane
Cell address box
No of columns in cover sheet (256)
No of rows in one sheet (25536)

Working area of MS Excel is known as work sheet.

Note:
By default 3 work sheets are visible when Excel is open.

To open MS Excel:
  • L.C on start menu
  • L.C on all programs
  • L.C on MS OFFICE
  • L.C on MS EXCEL
OR

Windows + R press keys
Type excel
Press enter

Note:
File menu, edit menu, view menu, and insert menu, are similar to MS Word.

Excel formulas:
Sum
(1) =cell + cell+……..
(2) Sum (range of cells)

Subtract
= cell – cell

Multiplication
= cell * cell

Divide
=cell / cell

Note:
In excel every formula starts from “= “ sign.
In cell numeric data have right alignment
Text has alignment



Percentage:
Total obtained marks *100 /total marks

Average:
Average (range of subjects)

If condition:
To bound some cells

OR
To apple some restriction
=if (cell address > = 33, “pass”, “fail”)

If user wants to display data in alphabetic data then user must type data in double commas “




Grade scale:
        Condition              True value
  • = 90 ……………….A++
  • = 80…………………A+
  • = 70…………………A
  • = 60…………………B
  • = 50…………………C
  • = 40……………….D
  •  = 33………………..E
  • F…………..false value
Nested if condition
To repeat if condition, in nested if condition repeat on seven times.

 =if (per > = 90, “A++”, if (per > = 80, “A+”, if (per > = 70, “A”, if (per > = 60,”B”, if (per > = 50, “C”, if (per > = 40, “D”, if (per > = 33, “E”, “F”)

Remarks scale:

Condition
= A++…………………….outstanding
= A+………………………excellent
=A………………………..V. Good
= B………………………. Good
= C…………………………fair
= D………………………….Normal
= E………………………… Poor
Fail………………………..false value

= if (grade > = “A++”, “outstanding”, if (grade > = “A+”, ”Excellent”, if (grade > = “A”, “V good”, if ( grade > = “B”, “good”, if (grade > = “C”, “fair”, if (grade > = “D”, “normal”, if (grade > = “E”, “poor”, “fail”.)))))))

If and condition:
In this condition we bond cell two times or apply condition two times.
= if (and (per% cell address > = 33, cell address < =100),”pass”, “fail”)

Grade scale with nested If And:

Condition true value>90, < =100……………………………….A++
>80, < =90…………………………………A+
>70, < =80………………………..A
>60, < =70……………………….B
>50, < =60………………………C
>40, < =50………………………D
>33, < =40………………………E
False value……………………F

=if (and (per >90, per < =1 00), “A++”, if (and (per > 80, per < = 90), “A+”, if (and (per > 70, per < = 80), “A”, if (and (per > 60, per < = 70), “B”, if (and (per > 50, per < = 60), “C”, if (and (per > 40, per < = 50), “D”, if (and (per > 33, per < = 40), “E”, “F”,)))))))

If condition is logical. If and condition is technical.


Filtration functions:
Count:
To count numeric cells
= count (cell range)

Count A:
To count those cells having alphabetic and also numeric value.
= counta (cell range)

Count Blank:
To count blanks cells in database
= count blank (cell range)

Count if:
To count something with single criteria
= count if (cell range, criteria)

Sum if:
To take sum of numeric value with the help of criteria
=sumif (cell range, criteria, sum range)

Is blank:
To check cell if blank or not.

If cell is blank then answer is true otherwise false.

= is blank (cell)

Is test:
To check value in cell is alphabetic.
If cell contain alphabetic blank then answer will be true otherwise false.
= istext (cell)

Is number:
To check value of cell is numeric. If cell contain numeric value then answer will be true otherwise false.
= is number (cell)

Database functions:

Dcount:
To count something with different criteria
= dcount (database, field, criteria)

S sum:
To take sum of something or any person numeric value with different criteria.
=d sum (database, field, criteria)

D mine:
To check minimum value with the help of criteria.
= d min (database, field, criteria)

Tools protection:
1. Sheet protection
2. Book protection
3. File protection

Perform sheet protection
1. Pointer required sheet wants to protect
2. Tools menu
3. Protection
4. Sheet protection “L.C”
5. Type required password
6. Retype required password
7. Ok / save / tray to change

UN Protection:
1. Pointer required sheet wants to un protect
2. Tools menu
3. Protection
4. Un protect sheet “L.C”
5. Type required password
6. Ok / save / change required data

Perform selective UN Protection:
1. Select required data range wants to un protect
2. Ctrl + 1 “open format cell box”
3. L.C on lock tab
4. Locked “un check”
5. Ok
6. Repeat sheet protection steps

Selective protection:
1. Select all required sheet
2. Ctrl + 1 “format cell”
3. Protection tab “ L.C”
4. Locked “un check”
5. Ok
6. Select required range wants to protect
7. Ctrl + 1 “open format cell”
8. Protection tab “L.C”
9. Locked “check”
10. Repeat sheet protection steps

Book protection:
1. Pointer required book wants to protect
2. Tools menu
3. Protection
4. Book protection “L.C”
5. Type required password
6. Retype required password
7. Ok

File protection:
1. Pointer required file wants to protect
2. Tools menu
3. Option
4. Security tab “L.C”
5. Password to open “type required password”
6. Retype password
7. Ok

Macro:
“Save set of command / actions” Sheet to sheet move
1. Pointer required 1st sheet
2. Tools menu
3. Macro
4. Record new macro
5. Type required macro and key
6. Ok
7. Move required 2nd sheet
8. Stop macro “L.C”

Macro security level:
1. High level
2. Medium level
3. Low level

Change macro security level:
1. Pointer required book wants to change macro security level
2. Tools menu
3. Macro
4. Macro security “L.C”
5. Select required security level
6. Ok / save / close / open required book


Auto filter:
To filter any record with the help of criteria from drop down box.
1. Select required data base
2. L.C on data menu in menu bar
3. L.C on filter
4. L.C on auto filter
5. Select required criteria from drop down box

Advance filtration:
To check record from data base without formula.
1. L.C on data menu in menu bar
2. L.C on filter
3. L.C on advance filter
4. Select data range
5. Select criteria range
6. Select copy to another location cells
7. L.C on ok

Chart:
Graphical representation of rows and columns
1. L.C on insert menu
2. L.C on chart
3. Select chart design
4. Select data range and also select alignment of chart as row wise and column wise
5. L.C on next6. Apply chart formatting
7. L.C on next
8. Select chart as object or as new sheet
9. L.C on finish


Promote This Page!!

Website counter

Like This Page!