What is Computer?
Computer is an electronic device.
It takes instructions by the user through the input devices then process it
then give us result through Output devices according to given instructions.
What is the language of computer?
Its language is Binary consisting
0 and 1.
What is desktop?
The Screen which appears after
booting the windows on the monitor as well as given the user name and password
is called desktop.
What is ICON?
The items or things which appear on the desktop and work
like a shortcut of the files, folders and software which we have been installed
and stored in our computer.
What is start menu?
The menu which appear after clicking on start button from
taskbar and also hold the shortcuts of all windows utilities as well as
shortcuts of all those software which we have been installed in our computer.
What is Network and types of Network?
When two or more than two Computers connect with each other
for sharing data is called a network.
1) LAN(Local Area Network)
2) MAN(Metropolitan Area
Network)
3) WAN(Wide Area Network)
1) Building and surrounding
(limited)
2) City level by signal
3) Word level (by satellite)
What is Server?
Mean Computer of a network is called server and other one
called clients.
What is Internet?
Interconnected Network Web host server.
Abbreviations of ISP, http, dsl, url………..
ISP:
Internet services provider.
http:
Hypertext transfer protocol.
DSL:
Digital Subscriber line.
URL:
Universal Resource locater.Unit Of Computer Memory:
Bit is a smallest unit of computer memory
8bit = 1 Byte
we can store a single character in a single byte.
Space is also consider as a character
1024 Bytes = 1 Kilo Byte
1024 KB = 1 Mega Byte
1024 MB = 1 Gega Byte
1024 GB = 1 Tera Byte
1024 TB = 1 Hexa Byte
MS Word Tutorial
Microsoft Word:
Microsoft word is use to create any type of documents in english.
What is Character?
A single alphabet from English is called character like "a", "A", "B".
What is word?
A group of character without space is called word like "Mansha",
"alfalfa".
What is sentence?
A group of words is called sentence and it should be break by full stop.
What is paragraph?
A group of sentences is called paragraph and it should be break
by immediately line break or by pressing "Enter key".
Who many pages in single word file?
We can make 32767 pages in a single Microsoft word 2007 to
onward file.
Who we will appear keyboard on screen?
Hold the "windows Key" and press "R" key then write "OSK"
without commas and hit Enter.
Different Keys and their work:
Caps Lock on:
To write the capital latter.
Ctrl Key :
It makes many short keys.
Alt Key:
Optional Key (alternative Key).
Key:
Mouse Key.
Arrow Keys:
Use in Paragraph.
Enter Key:
Line Breaker.
Back Key:
Left Erase.
Delete Key:
Right Erase.
Home Key:
To go to starting point.
End Key:
To go to Ending point.
Page Up:
Page up.
Page Down:
Page Down.
Note :( We cannot perform any type of formatting without selection MS WORD.)
Selection In MS Word With Mouse Keys:
Double click on any word is use to take a single word. Ctrl+click is use to state a single tense.
Tripple click on any sentence to select whole paragraph.
click on any left side of any line to select a whole line.
Double click on left side is use to select single paragraph.
Tripple click is use to select whole document.
Alt+right click is use to vertically or horizontal selection.
Selection with Keyboard:
Shift+Right Arrow:
Is use to select a single letter or words from right side of documents.
Shift+Left Arrow:
is use to select single line or words towards left side of the document.
Shift+Up Arrow:
Is use to select up side of documents.
Shift+Down Arrow:
Is use to select down side of the documents.
Shift+Home:
I use to select a line from position to home.
Shift+End:
is use to select a line from position to end line of the documents.
Ctrl+Shift+F8:
and press arrow keys to select the documents in vertically and horizontally.
Ways to open Microsoft word.
1) All Program↔Microsoft office↔Microsoft Word.
2) Hold the Windows key and then press the R key and write "winword" without commas and hit the Enter Key.
3) Write click on desktop and go to the "new" option and select Microsoft word document.
Microsoft Word short keys.
Ctrl+S: key is use to save the current open file.
F12: key is use for save as option.
Ctrl+O: key is use to open that file which we have been already saved.
Alt+F11: is use to close the current open file.
Ctrl+N: is use to create new file.
Ctrl+P: is use to get a print of current open file.
Ctrl+Bracket close(]): is use to increase font size of selected text.
Ctrl+Bracket open([): is use to decrease the font size of selected text.
Ctrl+Shift+>: is use to increase the font size of selected text.
Ctrl+Shift+<: is use to decrease the size of selected text.
Ctrl+A: is use to select the all data of the text.
Shift+F3: is use to change the case of selected sentence.
Ctrl+B: is use to bold the selected text.
Ctrl+I: key is use to change shape of selected text from normal to italic and italic to normal.
Ctrl+U: key is use to underline the selected text.
Ctrl+Shift+d: key is use to double underline the selected text.
Ctrl+Shift+w: key is use to underline the only words from selected text.
Ctrl+=: is use to convert the selected text normal to subscript.
Ctrl+Shift+(+): is use to convert the selected text or number normal to super script.
Some Important Points For Power point:
Definition: Power point is use for presentation in the form of slide show.
Note:(We can't write anything without text box).
F5 Key: Is use to Run the slide show.
Ctrl+N: Key is use to create a new slide show.
MS Excel Tutorial
Definition of MS Excel:
Excel is a spreadsheet software which is use to perform high level calculation, addition, subtraction, sorting, filtration etc on a large amount of data.
What is columns in MS Excel?
Vertically lines can create columns, each column has it's own name, which is known as column header...........like
A,B,C,..........XED.
What is Rows In Ms Excel?
Horizontally lines can create rows, each row has its own name which is known as row header...........like
1,2,3,3,................1048576.
How we can go to the last column and row in Ms Excel?
Ctrl+Right arrow: Key is use to move in last column.We have 16384 columns in a single sheet.
Ctrl+Down arrow: Is use to move in last arrow.
What is Operators?
Specific sign performed assign function is called operators.
We have three types of operators
1) Arithmetic Operator (+,-,*,/,etc)
2) Relational Operator (>,<,=,<=,>=,<>)
3) Logic Operator (AND or NOR)
Ways to Edit the cell in MS Excel:
1) Select the cell and press the F2 key.
2) Double click on the cell.
3) Through formula bar.
Mostly we perform calculations with the help of cell address instead of values.
What is the difference between function and formula?
Function is pre defined by the software we can just put the value in it according to some text.
Formula is created by user according to requirement by using different types of operators.
Note:( Every function or formula starts with equal (=)sign).
SOME FUNCTIONS
Use of Sum Function:
This function is use to get a total of specific range.
=sum(value 1,value 2,value)
=sum(Range)
=Sum( starting cell address : Ending cell address)
What is the use of max Function:
This function is use to pick the maximum value from specific rang.
=max(Range)
What is the use of min function?
This function is use to pick the minimum value from specific range.
=min(Range)
What is the use of Large function?
This function is use to pick the required number of position in descending order from specific range.
=large(Range,K)
K stands for position that we have to required.
What is the use of small function?
This function is use to pick the required number of position in seeding order from specific range.
=small(range,K) k is position.
What is the use of count function?
This Function is use to count all those cells which contain number type data from specific range.
=count(Range)
What is the use of Count blank?
this function is use to count all the empty cells from specific range.
=count blank(Range)
What is the use of count A function?
This function is use to count all those cells which contain any type of data from specific range.
=count a(Range)
What is the use of "count if" function?
This function is use to count all those cells which fulfill the given criteria from specific range.
=count if(Range,"criteria")
What is the use of "left" function?
This function is use to pick the required number of characters from left side of selected cells.
=left(text number of characters)
What is the use of "right" function?
This function is use to pick the required number of character from right side of selected cell.
=right( text number of characters)
What is the use of "Mid" function?
This function is use to pick the required number of characters from mid.
=mid(cell, position,number)
What is the use of "concatenate" function?
This function is use to merge the data of different cells into one cell.
=concatenate( , ," ", )
What is the use of "is text" function?
This function is use to check the cell which type of data we have been entered in it.
=is text(value)
What is the use of " is number" function?
This function is use to check the cell which type of data we have been entered in it either its number or not.
=is number(value)
What is the use of "is blank" function?
This function is to check the cell either it's empty or not.
=is blank( )
What is the use of "column" function?
to get the column number in which we are working.
What is the use of "=row" function?
to know the row in which we are working.
What is the use of "column(Range) function?
To know the columns where we worked.
What is the use of "row(range) function?
To know the number of rows where we worked.
What is the use of "code alphabet" function?
This function is use to know the the code of any alphabet.
What is the use of "char(code) function?
This function is to know the alphabet of given code.
Conditional Formatting in MS Excel:
1) Select the area.
2) Click on conditional formatting.
3) Click on new rule.
4) Format only cell that contain.
5) Go to down window and define new rule.
6) Click on format button.
7) Select the color.
8) Press ok and then ok.
How we Lock our Assignment or work sheet in MS Excel?
1) Select the whole sheet.
2) Right click on anywhere on selected area.
3) Click on format cell.
4) Click on protection tag.
5) Uncheck the locked cell option and then ok.
6) Click on protect sheet.
7) Right click on selected area.
8) Format cell.
9) Check the locked cell and then ok.
10) Click on Review Ribbon.
11) Click on protect sheet.
12) Assign the password.
13) Unchecked the select locked cell option ok and retype the same password and then ok.
No comments:
Post a Comment