About Me

header ads

BASIC KNOWLEDGE OF COMPUTER

Admin April 17, 2019





1 DIGITECH HARDWARE ACADEMY 33/2, EAST GHOSH PARA ROAD, PO- AUTHPUR, DIST.- 24 PGS (N), PIN- 743128, WEST BENGAL. PHONE:- ...
2 COMPUTER Computer is an electronic device or machine in which store and process data or infor- mation and give us a mean...
3 Analog computer is another kind of a computer that represents data as variable across a continuous range of values. The ...
4 Figure 1.9. Microcomputers  Desktop Computer or Personal Computer (PC) is the most common type of microcom- puter. It i...
5 games, etc. Blackberry, Apple, HTC, Nokia and LG are some of the manufacturers of smart phones. 1.6.2. Minicomputers Min...
6 1.6.4. Supercomputers Supercomputers (Figure 1.12) are the fastest and the most expensive machines. They have high proce...
7 Figure 1.13. Parts of computer system Hardware consists of the mechanical parts that make up the computer as a machine. ...
8 The input-process-output concept of the computer is explained as follows—  Input The computer accepts input data from t...
9 THERE ARE THREE COMPONENTS OF COMPUTER SYSTEM. i) INPUT DEVICE, ii) OUTPUT DEVICE, iii)C.P.U.  Input/Output Unit The us...
10 THERE ARE TWO TYPES OF MEMORY INTERNAL MEMORY :- This is the primary memory of the computer system. The storing capacit...
11 There are two types of External Memory i) F.D.D. (Floppy Disk Drive), ii) H.D.D. (Hard Disk Drive) i)F.D.D. :- It is a ...
12 There are three button in the Mouse. 1) LEFT BUTTON, 2) RIGHT BUTTON, 3) SCROLL OR WHEEL. LEFT CLICK BUTTON OR CLICK BU...
13 Office Computer Working With Different Programming PAINT Paint is a type of program in which we can draw picture with d...
14 PAINT PAGE WITH TOOLS FILE i) NEW :- To open the new page of paint file.  FILE––click–––––NEW–––click–––––NEW PAGE WIL...
15 v) PRINT PREVIEW :- To see the preview before printing.  FILE–––clcik––––PRINT PREVIEW–––click––––YOU CAN SEE PREVIEW ...
16 WORD PAD It is a type of programs in which we can write text document with different size and font color. To enter into...
17 WINDOW EXPLORER In Windows Explorer we can make folder or directory and also can able to search any file or folder. FOL...
18 To Copy & Paste Folder-  ON THE FOLDER––––R.click–––––COPY–––––click––––NOW FOLDER IS COP- IED. MICROSOFT OFFICE WORD ...
19  CTRL+1 :- To give single space in between the line of text.  CTRL+5 :- To give 1.5 spaces between the line of text. ...
20  Alignment :- To set the alignment (Like Left, Right, Middle& Justify).  Shading :- To set shading in line.  Indent ...
21  Columns :- To divided page in Columns.  Breaks :- To apply break of page.  Line Number :- To insert number by line,...
22 Accept –Accept & Move to next for showing also click on reject for hide all tracking.  Compare :- To Compare between t...
23 EXCEL PAGE WITH CHART All the Calculation we made in Excel is through the formulas. For Addition :- =SUM(first cell add...
24 For Square :- =cell add ^ 2,3,4, etc enter. To see the current date and time:- =Now ( ) enter. To see the current date:...
25 TO SHOW THE DETAIL OF SINGLE SALARY SLIP. = SELECT HEAD TITLE OF ROW – DATA- FILTER – Select a range of amount –Ok. TO ...
26 TO COUNT THE TOTAL NUMBER OF YES/NO & Present and absent CELL ADD. =COUNTIFS(B2:D2,"=Yes") TO GET THE PERCENTAGE IN IF ...
27 TO KNOW TOTAL SALE BY MONTHLY. = SUMIFS (SELECT SALES COLUMN, SELECT YEAR COLUMN,”= 2001”,SELECTMONTH COLUMN,”=1”). TO ...
28 =MONTH(SELECT AFTER DATE) – MONTH(SELECT PREVIOUS DATE). (Example: Month(6/20/2013) – Month(6/8/2013). TO CALCULATE / O...
29 =(B2-A2)*1440 TO CALCULATE TOTAL SECOND BETWEEN TWO TIMES. =(B2-A2)*86400 TO CONVERT DAYS TO HOUR. A 1 DATA 2 6 =CONVER...
30 COUPDAYSNC function Returns the number of days from the settlement date to the next coupon date. Syntax COUPDAYSNC(sett...
31 Remarks  Microsoft Excel stores dates as sequential serial numbers so they can be used in calcula- tions. By default, ...
32 Coupan Date is 15/5/2007 by help above formula. Calculate a compound annual growth rate (CAGR) A compound annual growth...
33 CONVERT 6 DEGREES CELSIUS TO FAHRENHEIT =CONVERT(A2,"C","F")…………………………….Ans.. (42.8) CONVERT 6 TEASPOONS TO TABLESPOONS...
34 EXAMPLE OF RESULT:- V-LOOKUP Searches for a value in the first column of a table array and returns a value in the same ...
35 Let's assume we are given the following sales table: If you wish to retrieve Dan's January sales (hence cell B3), the v...
36 =vlookup(A6,salesTable,3,false) H-LOOKUP Sales Report by Month/Year with Product Name. PRODUCT NAME RICE DAL PAPAD SWEE...
37 HOME Cut, Copy Paste :- To cut, Copy & Paste the selected cell. Formatting of text :- To format text or cell by Font st...
38 Select Entire column :- Ctrl+Space button (“) Select Entire Row :- Shift+Space button (“) Enter the Current Time :- Ctr...
39 Select all cell that contains Comment:- Ctrl + Shift+ O (“) Close the Selected Excel Window :- Ctrl + W (“) Repeat Last...
40 Show & Evaluate Formula :- To show & Evaluate formula. Watch Windows :- To Show details of Cell formulas by added user....
41 Create Outline & Clear :- To create & clear outline for raw and column. DATA VALIDATION FORMULA (ONLY PRACTICAL OFFICE ...
42 REVIEW Spelling & Grammar :- To check spelling & grammar of a word. Thesaurus :- To get a nearest meaning of word--Sele...
43 To enter into the Microsoft Powerpoint program by RUN COMMAND  Start ---Run----type there POWERPNT-----click Ok To mak...
44 link, text box, Header & footer, word art, date & Time, Slde Number, symbol & sound. DESIGN Design :- To insert page in...
45 INTERNET INTERNET: - Internet is a way or technique by which we can share or transfer file or in- formation from one pl...
46 E-MAIL E = ELECTRONICS MAIL = LETTERS. It is type of address the website by E-mail we can send text documents, picture,...
47 like www.yahoo.com, www.rediffmail.com, www.indiatimes.com, www.hotmail.com, etc. To make E-mail Address or E-mail Acco...
48 D.O.S (DISK OPERATING SYSTEM)  HOW TO OPEN THE DOS PROMPT :- START-ALL PROGRAMME-ASSOSERIES-COMMOND PROPMT To enter in...
49 C:/> - COPY – CON – FILE NAME THEN PRESS ENTER. FILE NAME IS TYPE AND PRESS F6 FOR SAVE THE FILE  TO SERIES OF FILE:- ...
Tags:

Post a Comment

0 Comments