Computer Basic

The Main Part of Computer

  1. C.P.U – Centrel Processing Unit

Its a main part of Computer like a brain.
It has some devices which are
  • Hard Disk – [80G.B, 160G.B, 350G.B, 500G.B, 1T.B]
  • S.M.P.S – Switch Mode Power Supplie
  • R.A.M – Randam Acess Memory [250M.B RAM, 512M.B RAM, 1.GB RAM]
  • Mother Board With Fun

       2. Monitor

It gives us the display what we do on Computer.
Note – The monitor is connected to the U.P.S with U.G.A
  • V.G.A – Video Grafic Adapter
  • U.P.S – UnInterpted Power Suplie
It runs with system without cut power.

       3.Keyboard

There are two types of keyboard.
  1. Normal Keyboard
  2. Multimedia Keyboard
Normal Keyboard – Normal Keyboard has 100 and 101 keys.
Multimedia Keyboard – It has 106, 107, 108 keys

        4.Mouse

There are two button on the mouse one is left and second is right and one also the scrolling button in middle.
Note – Both Keyboard and mouse are Connected to the C.P.U with ps2 and U.S.B port.


Operating System

There are four types of Operating System

  1. Mycrosoft Operating System

Window97, Window98, WindowME, Window2000, WindowUista, Window2003, WindowXP, Window2008, Window2010

      2.DOS – Dick Operating System

DOS Wargon – 3.1, 3.2, 3.4

      3.Linux
      4.Unix


What is the Computer?

Computer is a electronic machine. which we give the input its gives the output.
Dest of Beground
The Process is to change the dest of beground picture right click on destop by mouse then the destop beground and Enter it.
Then Choose the picture to set the destop beground picture. Then Apply it on click save change.
Brouse 
Brouse is a system of path (Adderess, Locations)
Screen Saver
Mouse right click of destop then click on personlies then select the screen saver Enter it. Then choose the 3.D Tax fand for so the name on Display.
Photo
To give the photo setting for so on screen.
File Menue
  • New – For create a new file
  • Sort cut – Ctrl N
  • Open – Ctrl O
  • Save – To create and save a new file Ctrl S
  • Save as – To create a dublicate file F12
  • Print – To give the print command Ctrl P
  • Print Preview – before check the print status before print command.
  • Prepare
  • Properties – for give file Summery Command
Ex – Othur, Name, Title Name, Sub Name, etc.
  • Send – for sending the file in mail and fax.
  • Publish – for file searing Command.
  • Close – for closing the file

Microsoft Office Word


Table

How to create the table?

The Process to Create the table click on insert menu. Then select table then select insert table then number of coloum and number of row to be given.
Table Tools (Layout)
  • Select – To get the all information about the table like a cell, row and coloum.
  • Delete – for delete the cell, coloum row and table.
  • Insert above – for inserting the extra rows about table.
  • Insert Below – for Inserting the extra raw below side in raws.
  • Insert Left – for inserting the extra left coloum in table.
  • Insert Right – for inserting the extra right column in table.
  • Merge Cells – for merge atlest for two cells in table
  • Split Cells – for devide the cell Split table.
Split Table – To break the table in middle
Auto Fit
Autofit contents for argesting covour the free space acoding to Contane.
Autofit Window
for normal size table command.
Table (Properties)

Alignment

www.worldhitries.com
www.worldhistries.com
www.worldhistries.com

Text Wrapping

www.worldhistries.com

www.worldhistries.com
Text direction
for the change the direction of text
Cells margins
Top and Bottom
for encreaging the size in table from top and bottom.
Allow Spacing between Cells – for make a space between each cell.
  • Sort – for change the matter in Ascending and desending order.
  • convert to text – for converting the table into the text.
  • Formula – for use the formula in tables.

Table Tools (Design)

  • Table Styles – for give the table style.
  • Draw Table – for use the Pencil to create the table menule.
  • Eraser – for erase the table.

Home

  • Cut – for cut the matter Ctrl X
  • Copy – for copy the matter Ctrl C
  • Paste – for Pasting Cut and Copy matter Ctrl V
  • Font Style
  1. Regular
  2. Italic
  3. Bold
  4. Bold Italic
  • Size – for increase the size of matter 12 size is standard size.
  • Font Colour – for change the colour of matter.
  • Underline Style – for give the underline to the matter.
  • Underline Colour – to change the colour of Underline

Effects

  • Strike through – for cut the matter with single line.
  • Double strike through – for cut the matter with double line
  • Shadow – for give the sahdow to matter.
  • Outline – for give the outline to matter
  • Emboss – for give these sitting to matter
  • Engrave – for give these sitting to matter
  •  [small caps and all caps] for make the letter in capitals
  • Hidden – for hide the matter
  • Super script – for change the size of matter and give the position above side.
  • Sub script – for change the size of matter and give the position below side.

Character Spacing

  • Expanded – for make the space between each letter of name or handing by clicking on below area.
  • Condensed – for remove the space between each letter or hading by clicking on below area.

Position

  • Raised – after selecting the matter or word change the position above size by clicking on above aero.
  • Lowered – after selecting the matter or word Change the position below size by clicking on above aero.
  • Change Case – for changing the matter in 
  1. Sentences Case
  2. Lowercase
  3. Uppercase
  4. Capitalize Each Word
  5. TOGGLE CASE
  • Clear Formatting – for reset the text formate style
  • Text Hight light Colour – for make the text look like it was mark the hightlight.

Paragraph

Indents and spacing, general Aligment
  • Left – for write the matter from left side.
  • Center – for write the matter from enter side.
  • Right – for write the matter from right side.
  • Justified – for write the matter equlas right both side.
  • Before text or (left) – for move the matter form left side.
  • After text or (right) – for move the matter from right side

Special

  • First line – for move only first line in paragraph
  • Hanging – move online in paragraph with first line.

Spacing

  • Before – for make a space before paragraph
  • After – for make a space after paragraph
  • Line Spacing – for make a space between each line on matter and paragraph.
  • Bulates and Numbering Library – for give the numbers and bullets before paragraph
  • Borders and Shading – for give to the text and paragraph
  • Styles – The Style for Paragraph and make own style and Apply it in matter.
  • Find – for find a particular word in matter Ctrl F
  • Replace – for replace the particular word with finded word Ctrl H
  • Select – for select in all matter in one matter. Ctrl A

Insert

  • Cover Page – for set the cover page of file.
  • Blank Page – for insert a new blank page in file.
  • Page Break – for page break command
  • Table – for creat the table
  • Picture – for inseert the picture in file for insert the picturein file for decorate the picture in picture  tools.
  • Clip Art – for insert the clip art picture and decorate with picture tools also.
  • Shapes – for insert the differerent types of shapes.
  • Smart Art – for create diagram
  • Chat – for create a graph
  • Hyperlink – to atach one file in another file through a link
  • Book Marks – for set the book mark in middle of matter.
  • Cross-reference – for cross-reference command.
  • Header – for set the Header in page above site.
Ex – Chapter name, Book name, data, page no, etc.
  • Footer – for set the footer for page below site
Ex – Chapter. Page no, data etc.
  • Page No. – for give only Page No. in file
  • Text Box – for insert the text box in file and write anything in this box.
  • Word Art – for using the making names and titals.
  • Drop Cap – for increase the paragraph in 1st creacter in 3 line.
  • Drop Cap decation – for change the writing style for increase crecter.
  • Line to drop – for increase to creacter more then 3 lines in paragraph
  • Distance for text – for make a space between that creacter and paragraph
  • Signature Line – for insert the signature in file.
  • Date and Time – for insert data and time in file.
  • Object – for insert the other softuan types file and same software file.
  • Equation – for make the equation for math in file.
  • Symbols – for using the symbolsin file.

Page Layout

  • Themes – for change the themes of matter.
  • Margins – for page margins command 
Top and Bottom = Height
Left and Right = Width
  • Orientation – There are two types of page
  1. Portait – Which height is more and width is less
  2. Landscape – Which height is less and width is more.
  • Size – for change the size of file but we use befolt letter size.
  • Colums – to convert the text into the colums
  • Break – for page break command
  • Line Number – for gives the numbers to each and every lines of files with matter.
  • Watermark – for give the text and picture behind the matter.
  • Page Colour – for change the page colour
  • Page Borders – for give page Borders command

Mailings

  • Envelopes – to create a Envelpoes to create a letter
  • Delivery Address – The Address is written here where to be send the letter.
  • Return Address – The Address is here from where we are sending the envelopes.
  • Options – for change the setting of envelopes with size and change the also the delery Address and return Address font style.
  • Add to Document – Ok
  • Labels – to create a sheet
  • Address – The meter is written here to create a sheet.
  • Options – for change the setting of Label or sheet.
  • New Document – Ok
  • Start Mail Merge – after click on start Mail Merge select Step mail marge in wizard.

There are 6 steps

  1. Click on Next
  2. Click on Next
  3. Click on type a new list to create a new data base list then click on create. Now type the data in Table aspar required. Then OK then save the file name (my data sources) Then OK Third step is complete. Then Click on next
  4. Choose more items then insert the fields asper your data table. Then set the matter and file like titlals name is one line, first name and last name in second line and other details fill continues in other lines. Now step is completed, then click on next
  5. Check the All Recipient list, Now click on next step-6
  6. Then Print the All document Asper required.
  • Edit Recipent List – for changing in data base file click on data file in data source then click on edit, Now you can create new entry delete exicting entry and now change in created entry then Ok and updates – Yes
  • Highlight Merge Fields – for highlight the data Base Mater
  • Address Block – for change the Address Block
  • Greeting Line – for use the resected word like a dear in database.
  • Insert Merge Field – for inserting the merge field in database file.
  • Finish & Field – for give the print command throw print documents.

Review

  • Spelling & Grammer – for check error in spelling and grammer.
  • Research – for check subsitude words for a pertcular word.
  • Theasurus – same as above
  • Translate – for translate in other language
  • Word Count – for check the statistics like
  1. Page
  2. Words
  3. Characters (no space)
  4. Characters (with spaces)
  5. Paragraphs
  6. Lines
  • New Comment – for give the comment for a perticular word and paragraph.
  • Delete – for delete perticular comments and all comment.
  • Pervious and Next – for check the comments in file through this command.
  • Track Changes – after activate the track change delete the matter
  • Balloons – for check the all comments and all tracks change matter in balloons
  • Reviewing Pane – for check the comments and track change matter also in this command.
  • Accept – for Accept the change deleted matter Yes.
  • Reject – for reject the track change deleted matter No.
  • Previous and Next – for check the track change in file.
  • Compare – for compering to file and combined in one.
  • Protect Documents – for Protect the file by Passward.

References

  • Table of Contents – to create a index of chapters
Page Wise
  1. Insert Footnotes – for insert a footnotes page below side
  2. Insert Endnotes – for inserting endnotes in the end of matter.
  3. Next and Previous Footnotes – for check the footnotes in full documents
  4. Next and Previous Endnotes – for check the endnotes in full documents.
  • Cross-reference – for file cross-reference command
View
  • Print Layout – for show the page in page Layout command.
  • Full Screen Reading – for show the full screen reading command.
  • Web Layout – for internet page Layout command.
  • Outline – for use page in outline command
  • Draft – for use page in draft command.
  • Ruller – for use the ruller in Page Layout
  • Gridlines – for show the gridlines command
  • Document Map – for check the matter with hading.
  • Thumbnails – for check the pages serieswise.
  • Zoom – for zooming the matter.
  • 100% – for page Normal size command
  • One Page – for check the one page in small size.
  • two Page – for check the two Page in small size.
  • Page Width – for normal size command
  • New Window – for create a new window with same file
  • Arrange All – for arranging the all file in one Look.
  • Split – for spliting the file.
  • View side by side – for check the two file side by side.
  • Switch Window – for switching the other file.

Word Excel


Salary Sheet
 S.no  Worker name  Salary Working days   Perday Salary Net Salary 
 1  a 12,000  20  400  8,000.00 
 2  b 11,000 23  366.67  8,433.33 
 3  c 10,000   21  333.33  7,000
 4 d  10,500  22  350  7,700
 5  e  11,500  19  383.33  7,283.33
 6  f  12,000  24  400  9,600
 7  g  13,500  26  450  11,700
 8  h  13,000  23  433.33  9,966
 9 i  12,000  20  400 8,000
 10 j  11,000  19  366.67  6,966.67
 
Formula
  1. Perday Salary – =Sum(Salary/30 days)
  2. Net Salary – =Sum(Working days×perday salary)

Stock Register

 S.no  Product Name Container Ststus  Rate  Qty  Amount Party Name  Bill.no  Sales Rate  Sales Qty  Sales Amount  Party Name  Bill.no  Net Stock 
 1 Monitor  box  450  25   1,12,500 box  m/s ram  4445  500  20  10,000 m/s Shyam  99099  5
 2  Keyboard  box  650  100  65,000 box      750  90  67,500      10
 3  Mouse  box  450  100  45,000  box      550    46,750      15
 4  Printer  box  2,500  50  1,25,000  box      3,000    1,35,000      15
 5  CD  pices  10  500  5,000 pices      15    6,750      50
 DvD   pices  15  500  7,500 pices      20    9,600      20
 7  Mouse Pad   pices  10  100  1,000 pices      15    1,275      15
 8  Hardisk   pices  3,000  30  90,000 pices      3,500    84,000      6
 9  Ram   pices  1,200  40  48,000 pices      1,500    57,000      2
 10  Pendrive   pices  800  100  80,000 pices      1,000    75,000      25

Home

  • Cut – for cut the matter.
  • Copy – for copy the matter
  • Paste – for pasting cut and copy matter
  • Paste expasial – for pasting some special command like formula, value,formate, comment etc.

  1. Number

  • General – to write the digit right and matter in left side in general setting.
  • Number – for converting the amount in rupees & paise.
  • Currency – for use currency style in Amounts
  • Accounting – for use accounting style in amounts.
  • Date – for change the formate of date in cell.
  • Time – for change the formate of time in cell
  • Percentage – for using the percentage in the cell.
  • Fraction – for Fractions command
  • Text – for using the matter and digit in same side.
  • Custom – for making the series with extra (O) like O1, O2, O3 and so all

      2. Aligment

  • Horizontal – General
  • Yertical – Bottom

Text Control

  • Wrap Text – for argest the matter into the cell [cell argestment]
  • Shrink to fit – for argest the matter into the cell [matter argestment]
  • Merge Cell – for merging atleast two cell
  • Orientation – for change the direction of text.
  • Font – for change the size of matter and style.
  • Border – for set the border on sheet.
  • Fill – change the beground color of cell.
  • Style –
  • Conditional formatting – for give the color style to sheet.
  • Format as Table – for give the from of table with color.
  • Cell Styles – to decorate to each and cell acording to required like tital style, hading style and total style
  • Insert – for inserting the raw and column in sheet and inserting new sheet also.
  • Delete – for delete the adjesting raw and column and adjesting sheet also.
Formate
  • Row height – for change the height of row
  • Autofit row height – for auto adjesting the raw height in same size.
Note – Defolt Row height =15
  • Column Width – for arjesting the column
  • Autofit Column width – for autofit coloum size acoding to contain
  • Default width – for arjesting the all sheat column with the size.
Note – Deafult column with size is 8.43
  • Hide & Unhide – for hiding row column and sheet
  • Unhide – for unhiding the raw column and sheet
  • Rename Sheet – for renamimg the sheet.
  • Move or Copy Sheet – for moving and copying the sheet to other file.
  • Auto Sum – for sum the number of series.
  • Fill –
  • Series – for make the series of numbers
  • Clear – for clearing the all matter in shet.

Sort & Filter

  1. Sort smallest to large –
  •  for convert the series from smallest to large series from smallest to large series.
      2. Largest to Smallest
  • for convert the series from largest to small series.
  1. Custom Sort – for create a list of name in custom list.
  2. Find – for Find a pertcular word in the sheet
  3. Replace – for replace the word with finded word.
Salary Sheet-2
 S.no Worker name  Salary  % of da  da amount  % of ha  ha amount  % of ta  ta amount  % of pf  pf amount  Net Salary 
 1  a  15,000 10%  1,500  11%  1,650  12%  1,800  4%  600  19,350 
 2  b  14,500 11%  1,595  9%  1,305  11%  1,595   4%   500  18,415
 3  c  13,000  10%   1,300  12%  1,560  9%  1,170  4%   520 16,510 
 4  d  14,500  9%  1,305  11%   1,595  11%   1,595  4%   580  18,415
 5  e  14,000  11%   1,540  12%  1,680  11%   1,140  4%   560  18,200
 6  f  12,500  12%  1,500   13%  1,625  12%  1,500  4%   500  16,625
 7  g  20,000  13%  2,600  12%  2,400  10%   2,000  4%   800  26,200
 8  h  16,000  11%  1,760  11%   1,760  12%  1,920  4%   640  20,800
 9  i  15,000  10%   1,500  10%   1,500   13%  1,950  4%   600  19,350
 10 j  15,500  11%   1,705  11%   1,705  12%  1,860  4%   620  20,150


Party List
 S.no  Party name  Amount Pending Bill.no  Item name  % of Int  Int  Net Amount 
 1  m/s A  25,000  100  Keyboard  3%  750  25,750
 2 m/s B 100,000  102  Fridge  4%  4,000  1,04,000
 3  m/s C  20,000  90  Mouse  5%  1,000  21,000
 4  m/s Gupta  36,000  125  Printer   3%  1,080  37,080
 5  m/s Aggarwal  14,500  190  CD  4%  580  15,080
 6  m/s Reliance  16,500  250  DvD  2%  330  16,830
 7  m/s Bigbazzar  80,000  300  Monitor   3%  2,400  82,400
 8  m/s Palika  17,500  450  Pen drive  5%  875  18,375
 9  m/s Jain  5,000  500  Mouse Pad  6%  300  5,300
 10  m/s Sangwan  18,500  60  Keyboard Cover   3%  555  19,055

Sales Sheet

 S.no Product  Rate  Qty  Amount  % of tax  tax amount  Net amount 
 1  Monitor  4,500  25  1,12,500  4%  4,500  1,17,000
 2  Cooler  10,000  15  1,50,000  3%  4,500  1,54,500
 3  Led  15,000  20  3,00,000  4%  12,000  3,12,000
 4  CD  10  100  1,000  5%  50  1,050
 5  DvD  15  100  1,500  3%  45  1,545
 6  Printer  2,500  50  1,25,000  4%  5,000  1,30,000
 7  Computer  15,000  30  4,50,000  6%  27,000  4,77,000
 8  Pendrive  800  100  80,000 0 3%  2,400  82,400
 9  Keyboard  650  100  65,000  5%  3,250  68,250
 10  Mouse  450  100  45,000  4%  1,800  46,800

Insert

  • Pivot Table – To create a pivot table select a sheet then click on pivot table. Then OK then choose the field to create a report of pivot Table.
Pivot Table Tools (Option)
  • Pivot Chat – click on pivot chat to create chat of pivot table then select the chat an OK.
  • Design – To move the chat to other sheet click on move chat. Then select the new sheet and give the chat name….. then Ok.
Layout
  • Chat Titals – To give the name of chat.
  • Axis Titals – To give the axis titlas name Horizontal and Vertical
  • Legand – To show the Legand on chat.
  • Data Table – To show the amount in chat.
  • Axes – for use axes command.
  • Gridlines – for use gridlines command.
  • Plot Area – for show the plot area.
  • Tredlines – for use the Tredline command in chart.
  • Picture – for insert the picture and decorated picture formate.
  • Clip Art – for insert the clip art picutre.
  • Shapes – for insert the different type of shapes in sheet.
  • Smart Art – for create a diagram.
  • Chart – for create a graph.
  • Hyperlink – to atach one file in another file.
  • Tex Box – for insert the tax box and right anything in this box.
  • Header & Footer – for set header in page above site and footer in page low site.
  • Word Art – for create a name and decorated with tools.
  • Signature Line – for insert the signature command.
  • Object – for other insert the other software file.
  • Symbol – for use symbol command
Page Layout
  • Themes – for change the themes of matter.
  • Margins – for set Page margin command
  1. Top and Bottom – Height
  2. Left and Right – Width
  • Orientation – There are two types of pages
  1. Portrait
  2. Landscapee
  • Size – for set the page size command
  • Print Area – select the area in sheet give the Print Command.
  • Break – for page break command.
  • Back Ground – for give the background picture.
  • Print Titals – for give some Print Command like Gridlines in Print….. Black and White in print Row and Column headings in Print.
Page Order
  1. Down, then over…. over, then down.
  2. Scale to Fit – for scaling the sheet to print in single print.
  3. Gridlines with View – to show the Gridlines in print click on print surcle.
  4. Headings with View – To show the headings in print click on print surcle.
 Date Name  Qty  Amount  Advance 
 1-Jun  A  25 25,000  15,00 
 1-Jun  B 25  25,000  1,850
 1-Jun  C 30 30,000   2,000 
 1-Jun  D  26  26,000   2,100
 3-Jun  B  40  40,000   3,000 
 4-Jun  D  35  35,000  25,00
 6-Jun  A  50  50,000   3,900
 10-Jun  C  85  85,000   7,000 
 15-Jun  A  68  68000   4,500
 16-Jun  D  100  1,00,000   7,500
 21-Jun  B  125  1,25000   10,000 
 22-Jun  A  120  1,25000   12,500
 25-Jun  C  150  1,50,000   14,000 
 26-Jun  D  189  1,89,000   17,000 
 30-Jun  A  200  2,00,000   18,000 
  30-Jun  B  250  2,50,000   19,000 
  30-Jun  C  245  2,45,000   20,000 
  30-Jun  D  275  2,75,000   24,000 

Total
 

 Name  Qty  Amount Advance 
 A  463  4,63,000  40,400
 B  440  4,40,000  34,350
 C  510  5,10,000  43,000
 D  625  6,25,000  53,100


Got External Data

  • From Access – To empot the access data base file in the excel sheet
  • From Web – to empot the web file in excel sheet.
  • From Text – to empot the text file in the sheet.
  • From other sources – to empot the file from other sources.
  1. From sol Server
  2. From Analysis Services
  3. From XML data Import
  4. From data Connection Wizard
  5. From Microsoft quary
  • Exisiting Connections – to see the all import file connection
  • Sort – for insert the custom list with the name then OK.
  • Filter – after select the heading on sheet click on filter….. then find the range and the name select all that adverise remove the selections.

Number Filters

  • Custom Autofilter – show the range of amount after selecting the command is greater then equal to and less then equal to 
  • Text to Column – for convert the text into the column
  • Remove Duplicates – after select the full sheet then remove the Duplicate entry in sheet,
  • Data Validation – to apply the data validation select the cell in column then click on data validation then select the list in allow and type the sources name with comma then  OK.
  • Consolidate – to consolidate the sheet like Labour sheet click on consolidate then select the range of sheet in reference then Add then click left Column then OK.
  • Group – select the column and Row in sheet click on group
  • UnGroup – for ungrouping the grouped column and Row
  • Subtotal – to show the subtotal of total in sheet.

Office Timing

Formula

  1. [(time out from lunch-time in) + (time out-time in from lunch)]
 Office Timing Sheet
 

 S.no Name of
  Worker 
Time in   Time out
from lunch
Time in form lunch  Time out  Total hours
 1  a  8:00AM  1:00PM  2:00PM  6:00PM  9:00
 2  b  8:30AM  1:20PM   2:00PM  6:45PM  9:58
 3  c  9:00AM  1:30PM   2:30PM  6:30PM  8:50PM
 4  d  8:30AM  1:20PM   2:00PM  5:00PM  7:53PM
 5 e  9:30AM  2:00PM   3:00PM  6:00PM  7:50PM
 6  f  9:00AM  1:30PM   2:30PM  6:30PM  8:50PM
 7  g  9:00AM  2:00PM   3:00PM  5:30PM  7:50PM
 8  h 9:00AM  1:00PM   2:00PM  5:00PM  7:00PM
 9  i  7:00AM  1:00PM   2:00PM 5:00PM  9:00PM
 10  j  9:30AM  1:00PM   2:00PM 5:00PM  6:50PM

 Tender Sheet of M/S Gupta
 

 S.no Product Name  Bedget Amount  Actual Amount  Status  Total Amount 
 1  Monitor  3,500  3,510  out of bedget  10
 2  Keyboard  450  450  in bedget  0
 3  Mouse  250  260  out of budget  10
 4  Pendrive  600  450   in bedget  0
 5  Printer  2,100  2,200  out of bedget  100
 6 Washing Machine  10,0000  15,000  out of bedget  5,000
 7  Computer  14,000  13,500   in bedget  0
 8  Cooler  12,000  15,000  out of bedget  3,000
 9  Led Tv  16,500  17,000  out of bedget  500
 10  Fridge  13,000  15,000  out of bedget  2,000

Formula

  1. Total Amount – =if (actual amount>bedget amount, actual amount-bedget amount,0)
  2. Status – =if (actual amount>bedget amount, “out of bedget”, “in bedget”)
 Mark Sheet of College
 

 Name Hindi  English  Mathe  History  Science  Total  Max   Min  % of averge Result  Division 
 A  50 55  66  77  88  336  88  50  67.2  Pass  First 
 B  45 55   88 77   99 364  99  45  72.8  Pass    First 
 C  62 45  55  66   35  263  66  35  52.6  Pass   Second
 D  45 52  85  35   33  250  85  33  50  Pass   Second
 E  44  46  47  48  49  234  49  44  46.8  Pass   Second
 F  50  51 52   55  53  261  55  50  52.2  Pass   Second
 G  41  40  45  55  54  235  55  40  47  Pass   Second
 H  45  0  0  66  77 188  77  0  37.6  Fail  Third

Formula

  1. Result – if [and (Hindi>32, English>32, Math>32, Histry>32, Science>32), “Pass”, “Fail”]
  2. Division – = if [(% of avarge>59), “first”, if (% of avarge>44), “second”, if (% of avarge>32), “Third”, “Fail”]
  3. % of avarge – Total Marks/5
Worker List
 emp id  Name  Address  Phone.No
       

Review

  • Spelling – for check spelling grammer in the sheet.
  • Research – for check a subsitute word for a perticular word.
  • Theasures – same as above.
  • Translate – Traslate the language for other language.
  • New Comment – to give a particular word on a shall in sheet.
  • Delete – for deletea particular words and comment.
  • Previous and Next – for check the comments in file.
  • Show All Comments – for show all comment in one time.
  • Protect Sheet – to protect a perticular sheet with the passward.
  • Protect Work Book – to protect the whole work book.
  • Allow users to Edit Ranges – Select the Perticular range in sheet and allow it by appling to keep an protect while your are protecting your sheet.
Power Point
  • to create a Pertasion click on home menu.
  • Home Menu – click on new slides and create and data matter. for slide Percendation.
  • Design – click on design menu and set the themes on slides on percendation.
  • Anamations – click on anamation menu and select the anaminations for the slide picture.
  • Custom Anamanations – click on anamation menu then select the custom anamation for set the anamation on taxes and picture.
  • Slide Show Menu – Click on slide show menu and select the reanes timing for set the timing on every slide for Percentage
View
  • click on view menu then select slide show for show the slide percenage on full screen.
Slide Show
  • From Beigning – to show the slides in Percentage from begning.
  • From Current Slide – for show the slide from select slide
  • Custom Slide Show – to change the order of slides for the Percendation.
  • Setup Slide Show – to show the slides from where to where and all.
  • Hide Slides – to you hide the slid to not the Percentagen.
  • Record nerasions – for set the record nerasious on the each slides.
  • Rehears Timing – for set the timing every slides on Percengation.

Microsoft Access

Data Type 

  • Text – to create a data with the alphabatic words only…..exp – costumer name, costumer father name, etc.
  • Memo – for use this database with the alaphabatic and digit both. Exp – address, bill.no etc.
  • Number – for use this database only for the amount as number…. etc. exp – school fee, amount, telephone no etc.
  • Date and time – for use this database use the colonder.
  • Currency – for use this currency command.
  • Auto Number – for using this command for the number this series… exp – 1,2,3,4,5….etc.
  • Yes/No – for use Yes/No command.
  • OLE Object – tick mark command.
  • Hyperlink – to attech one file in another file.
  • Attachment – to attach any report photo and file.
  • Lookup Wizard – for atach the mail address.

Table Sheet

  • ID                                       1
  • Costumer name               ——               Text
  • Address                           ——                Memo
  • Phone no                         ——               Number
  • Item                                 ——                Text  
  • Date                                 ——                date & time                    
  • Amount                            ——                Number
  • Bill no                              ——                 Memo
  • Mode of Pay                     ——                Text 
  • Receiver By                     ——                 Text
  • Deleiver By                      ——              Text   
Table 
Click on table mean then click on table design.
Then file the field name than select the data type then save to file after click on view and give the file name.
  • Design Quary – after click on create menu then select design quary then select the table and at that table at the file then click on to click on the heading a give the critet area filled name…. then click give the create name and to give the creach area name…. Then click on run save quary to bring the quary detailes save it.
  • Quary Wizard – click on query wizard select OK… then choose the filled then selecten filled by>…..then Ok and next then next then Finish.
  • Labels – to create a labels like a chit on which you can give the name, address, phone no etc.
  • Report Wizard – to show the report click on report wizard.
  • Form – to create a form
  • Split Form – to show the form with the table.
  • Multiple Items – to show all the items in a one table with table details.
External Data
  • Import – Import the other software file in Access database file.
  • Access – to import the access files.
  • Excel – to import the excel file.
  • Text file – to import the notpad files.
  • XML File – to import the exmal files and other files also.
  • Export – to export the access database file.
  • Excel – to export the access file in the excel file.
  • Word – to export the access file in the word file.
  • Text file – to export the export access file into the text file.

Leave a Reply

Your email address will not be published.