"*" indicates required fieldsHiddenDate MM slash DD slash YYYY (Fill the Assignment Form In Block Letters) प्रत्येक स्टूडेंट्स को अपना असाइनमेंट एक सप्ताह के अंदर ही पूर्ण करना है।छात्र अपना Assigment सोमवार से शुक्रवार तक ही दर्ज कर सकते हैं. Roll Number*Enter your Roll-numberHiddenAssignment IDStudents's Name*Enter Student's Name In block letter First Last Students's mobile number*Enter Student's Mobile NumberGuardian's mobile number*Enter Guardian's mobile numberEmail* Enter your Correct Email AddressBatch Time*08:00 to 09:00 AM09:00 to 10:00 AM10:00 to 11:00 AM11:00 to 12:00 AM02:00 to 03:00 PM03:00 to 04:00 PM04:00 to 05:00 PM05:00 to 06:00 PMSubject*Fundamental & internetMicrosoft WindowsMicrosoft WordMicrosoft ExcelMicrosoft AccessMicrosoft PowerpointMicrosoft OutlookTally ERP-9Fundamental Assignment*Select Assignment NumberFundamental Assignment-1Fundamental Assignment-2Window Assignment*Select Assignment NumberWindow AssignmentWord Assignment*Select Assignment NumberWord Assignment-1Word Assignment-2Word Assignment-3Word Assignment-4Word Assignment-5Power-Point Assignment*Select Assignment NumberPower-Point Assignment-1Power-Point Assignment-2Power-Point Assignment-3Power-Point Assignment-4Excel Assignment*Excel Assignment-1Excel Assignment-2Excel Assignment-3Excel Assignment-4Access Assignment*Select Assignment NumberAccess Assignment-1Access Assignment-2Access Assignment-3Access Assignment-4Outlook Assignment*Select Assignment NumberOutlook Assignment-1Outlook Assignment-2Tally Assignment*Select Assignment NumberTally Assignment-1Tally Assignment-2Tally Assignment-3Tally Assignment-4Fundamental of Computer Assignment -1 Questions* 1. Introduction to Computer? 2. Advantages and Disadvantages of Computers? 3. Similarities Difference between computer and Human? 4. What is software/hardware? 5. Generation OF COMPUTERS? 6. Analog computers ,Digital Computers ,Hybrid Computers, Mini Computers, Mainframe Computers ,Super Computers? 7. Advantages of Computers -Speed ,Accuracy, Efficiency ,Storage Capability ,Versatility? 8. Difference between Human and Computer? 9. Input Unit ,The Central Processing Unit ,Output Unit? 10. Advantages of the keyboard? 11. Optical Character Reader? 12. Magnetic Ink Character Recognition (MICR)? 13. Voice Recognition Systems? 14. Define: Peripheral Devices, Input Devices, Output Devices? 15. Write Short notes on: Keyboard, Optical Scanner, Plotter? 16. What are impact printers? Describe any two types of impact printers? 17. Discuss what storage units are. What are the types of storage units? 18. Define Cache memory,Virtual memory? 19. Describe direct access storage devices & sequential access devices? 20. Discuss optical storage devices?Select AllAll Questions are CompulsoryFundamental of Computer Assignment -2 Questions* 1. History of internet? 2. Define internet? 3. Define network? 4. Define Types of networks? 5. Define the benefits of network? 6. Define is protocol? 7. Define TCP/IP with example? 8. Define Web-browser & with example? 9. Define ISP? 10. Define virus & vaccine? 11. What is spyware? 12. Define type of computer viruses? 13. Define server & clients? 14. What is website? 15. Define Internet Bnaking with example? 16. What is domain? 17. What is hosting? 18. Define search engine with example? 19. What is cloud storage with example? 20. What are the benefits of cloud storage?Select AllAll Questions are CompulsoryMicrosoft Windows Assignment-1* 1. Explain the main purpose of an operating system? 2. What are the functions of an operating system? 3. What is Windows Server? 4. What are the different types of Windows OS? 5. What are the advantages of the windows operating system? 6. What is the control panel in Windows? 7. List the various editions of Windows 10? 8. What is pirated software? 9. What are real-time systems? 10. What is a virtual memory? 11. What is fragmentation? 12. What is Direct Access Method? 13. What are device drivers? 14. What is multitasking? 15. What is caching? 16. What is GUI? 17. What are interrupts? 18. What is BIOS? 19. Define POST? 20. Define folder & Subfolder?Select AllAll Questions are CompulsoryMicrosoft Word Assignment -1 Questions* 1. What is M.S Word explain? 2. How to Start M.S Word in different Ways? 3. What is template Explain? 4. How to create a new document using Blank Template? 5. How to create a document using Online Template? 6. How to save word document in your own Folder? 7. How to save your word document in OneDrive? 8. How to save word document in word 97-2003 format? 9. How to add text in your document by inserting text box? 10. How to resize, rotate the text box? 11. How to fill colour in text box? 12. How to find and replace text in M.S Word? 13. How to Go to a Particular Page number in M.S Word? 14. How to Convert Word document in PDF Format? 15. How to Create a Bookmark in Your Document? 16. How to Go to a Particular Bookmark? 17. How to align Text in M.S Word? 18. How to set the Line spacing in a document? 19. How to Insert Current Date and Time in a document? 20. How to create bullet list in a document?Select AllAll Questions are CompulsoryMicrosoft Word Assignment -2 Questions* 1. How to Create Your own Bullet Style? 2. How to Create Numbers list in a document? 3. How to Change the numbering style of the list? 4. How to apply text formatting in your document? 5. How to Highlight Text in your document? 6. How to Copy text Formatting using Format Painter Button? 7. How to Clear Text Formatting? 8. How to add a paragraph border in your document? 9. How to add a page border in your document? 10. How to add page number in a documents? 11. How to add page border using Border Art? 12. How zoom in & zoom out the documents? 13. How to change the view of the documents? 14. How to Insert Special Character in a document? 15. How to create Shortcut for Special Character? 16. How to Insert a Symbol by using text? 17. How to Apply a Solid Colour Background? 18. How to apply fill effects in Page Background? 19. How to apply Text Watermark in your document? 20. How to apply pre define themes in a document?Select AllAll Questions are CompulsoryMicrosoft Word Assignment -3 Questions* 1. How to apply Picture Watermark in your document? 2. How to set Pre-defined page margin of the document? 3. How to set Custom margin of the document? 4. How to Change the page size of the document? 5. How to defined custom Page Size? 6. How to Change the Page Orientation? 7. How to split the text on a page into columns? 8. How to change the column width and spacing? 9. How to insert a line between the column? 10. How to Insert a line Numbers in your document? 11. How to insert header in your document? 12. How to insert footer in your document? 13. How to create Footnote and Endnote? 14. How to check Spelling and Grammar in your document? 15. How to insert online picture in your document? 16. How to insert offline picture in your document? 17. How to Insert a Word Art? 18. How to edit Word Art Style? 19. How to Insert Drop cap in MS word? 20. How to Add equations in Your document?Select AllAll Questions are CompulsoryMicrosoft Word Assignment -4 Questions* 1. How to Insert a Hyperlink in your document? 2. How to resize, move, crop the picture? 3. How to add border to a picture? 4. How to insert shapes in a word document? 5. How to resize and move the shapes? 6. How to fill colour in the shapes? 7. How to add text to a shape? 8. How to group or ungroup the shapes? 9. How to insert a table using box selection? 10. How to insert a table using the insert table dialog box? 11. How to draw a table according to your requirement? 12. How to Change the line colour of the table? 13. How to create a table of contents? 14. How to remove line from the table? 15. How to insert column in the table? 16. How to insert rows in the table? 17. How to convert table into text? 18. How to convert text into table? 19. How to Change row and column width? 20. How to remove a column from a table?Select AllAll Questions are CompulsoryMicrosoft Word Assignment -5 Questions* 1. How to remove row from a table? 2. How to delete a cell from the table? 3. How to add border in the table? 4. How to add shading in the table? 5. How to merge cells in a table? 6. How to splitting a cell in a table? 7. How to split the table? 8. Sort the database ascending or descending order in the table? 9. How to add formula in a table? 10. How to protect document from unauthorized access? 11. Assign restrict editing in an M.S Word document? 12. How to assign keyboard shortcut in M.S Word document? 13. How to Import or Export ribbon or Tab setting? 14. How to Create your own tab and group in M.S Word? 15. How to create an address book in mail-merge? 16. How to edit address book? 17. How to add address block in mail-merge? 18. How to add fields in mail merge latter? 19. How delete address in the address book? 20. How to preview & print Mail-merge?Select AllAll Questions are CompulsoryMicrosoft Excel Assignment -1 Questions* 1. What is Microsoft Excel Explain? 2. Write down the importance of Excel Explain with Extention? 3. How to start MS excel in different ways explain each? 4. How many rows & columns in Excel 97-2003 & excel 2021? 5. How many cells in a excel 2021 worksheet? 6. How to go to last row & last columns in excel with the help of Keyboard? 7. How to add a new worksheet with help of keyboard? 8. How to rename/delete a sheet? 9. What is difference between workbook & worksheet? 10. How many types of entry made in MS excel cell? 11. What is logical entry explain.? 12. What is range of cell explain? 13. How to copy formula is a cell? 14. How set column width & row height of the sheet? 15. How to merge cell? 16. How fill color in a cell in excel? 17. How to align cell contents? 18. How to insert rows & columns in a sheet? 19. How to change the sheet background? 20. How save your workbook in your own folder?Select AllAll Questions are CompulsoryMicrosoft Excel Assignment -2 Questions* 1. How many types of cell references in M.S Excel? 2. Write down the importance of function with example? 3. Give the syntax of the following A. SUM () B. DATE () C. COUNT () D. AVERAGE () 4. Explain text function with example? 5. Give the syntax of the following text function? A. MID() B. LEFT() C. LEN() D. REPT() 6. Types of operator in M.S Excel explain each? 7. What is logical function explain with example? 8. Write down the syntax of Sumif function? 9. What is auto fill explain with example? 10. What is data validation and how to apply it? 11. How to create list validation? 12. How to assign input message and error alert in data validation? 13. What is range and range name? 14. How many ways to create range name explain each? 15. How to create non continuous range name? 16. How to check range name? 17. How to delete range name? 18. How to edit range name? 19. How to refer another sheet of the same workbook? 20. How to refer the worksheet in another workbook?Select AllAll Questions are CompulsoryMicrosoft Excel Assignment -3 Questions* 1. How to remove grid lines from sheet? 2. How to insert word Art in M S Excel? 3. What is database explain? 4. How many types of databases in M S Excel? 5. How many types of filters in M S Excel explain Each? 6. How to filter table data with or without Heading? 7. How filter table data result in different location? 8. How to filter data using AND/OR condition? 9. How to remove filter? 10. Give the syntax of D-function with Example? 11. How to apply D-function in a sheet? 12. Write down the benefits of pivot table? 13. What is data validation explain With Example? 14. How to assign text validation with input/error Alert Massage? 15. How to assign date validation with input/error Alert Massage? 16. How to assign number validation with input/error Alert Massage? 17. How to Assign list validation in M S Excel. 18. How to Sort Excel Sheet data? 19. How to apply subtotal in a sheet? 20. Write down the importance of chart in M S Excel?Select AllAll Questions are CompulsoryMicrosoft Excel Assignment -4 Questions* Q1. How to Insert shapes in excel. Q2. How to apply auto sum. Q3. How to Display formula in each cell instead of resulting value. Q4. How to protect a sheet. Q5. How to Apply conditional formatting Q6. How to create a chart in excel Q7. How to change the chart type. Q8. How to set the print area in MS Excel. Q9. What is dynamic data range and controls explain. Q10. Give the syntax of offset function. Q11. What is dynamic data range Name explain. Q12.Give the steps to create dynamic data range name. Q13.How to check & delete dynamic data range name. Q14. What is Goal seek Explain with examples. Q15. Give the syntax of PMT function. Q16.Give the steps to create goal seek. Q17. What is scenario manager explain. Q18.How to create a scenario give steps. Q19.How to update & delete scenarios. Q20. How to create scenario summary report.Select AllAll Questions are CompulsoryTally Assignment-1 Questions* Deselect AllAll Questions are CompulsoryStudent's Signature*Guardian's Signature*Terms & ConditionYou can Complete your Assignment within the 7 days of assignment creation.Only ICL Computer Private Limited Can Approve the Assignment.Contact at institute for assignment Submit Date.