Posts

worksheet CLASS 7

  CLASS 7 WORKSHEET   1.     Convert decimal number into their binary equivalents i)                245   -   11110101 ii)            80-    1010000 2.     Convert binary number into their decimal equivalents i.                 11101- 29 ii.             010101- 21 3.                         Write the use of the following functions in excel. ·      product (range)- Multiplication ·      Today()- Date and Time ·      Sort (Number)- Sorts range in ascending or descending order ·  ...

CHAPTER 3 ANALYSE DATA IN EXCEL 2016

Q1. Fill in the blanks with the help of the given words. 1.............. is the rearragement of data in either ascending or descending order. ans- SORTING 2. .......................in Microsoft Excel helps to retrieve data to edit, analyse, format or print it. ans- FILTER 3. Auto Filter is used to filter a column or row to view the data based on a ...........condition. ANS SPECIFIED 4. To apply conditional formatting, i will click on.................group under Home tab. ANS Style 5. Sort A to Z option will sort data in......................order ANS Asceding  B. Tick the correct answer. 1. Which option will you choose to sort data in descending order? ANS-  Sort Z to A 2. Which of these is not a type of filter in Microsoft Excel? Ans- Conditional 3. Which of the following key combinations will you press to filter the data? ANS  Ctrl+Shift +L 4. Which button will you click to remove all the conditional formatting from a cell? ANS- Clear rules  5. On the Home tab, in ...

CHAPTER 4 RAISING QUERIES CLASS 8 COMPUTER

CLASS 8 CHAPTER 4 RAISING QUERIES A. Fill in the blanks with the help of the given words. 1. Connecting tables in a database is the concept of relational database. 2. A foreign key is the primary key of another table which creates a link between two tables based on a common column. 3. If you modify the primary key value, Cascade update related fields  allows you to update all the related foreign key values. 4. A query   allows you to pull information from one or more tables based on a set of defined search conditions. 5. The query design view allows you to customise the query.     B. Tick the correct answer. 1. Which of the following options allows you to delete the related records from the foreign key table, if you delete records from the primary key table? ANS B. Cascade delete related records 2. Which option in Edit Relationships dialog box prevents you from entering a value in the foreign key field? ANS B. Enforce referential integrity 3. Press.......... to...

CLASS IX AND X COMPUTER APPLICATIONS 165

  CLASS X (2025-26) COMPUTER APPLICATIONS (165)   1 . Write an assignment on the various Internet Protocols. The following Protocols should be included:   - TCP/IP     - SMTP     - POP3      - SSH     - SFTP    - FTP    - SCP     - TELNET 2. Write an assignment on the various internet services. The following should be included: 1.      E-mail    2. Search Engines     3. Chat    4. Video conferencing     5. E-learning 6. E-Banking   7. E-Shopping    8. E-Governance    9. E-Groups    10. Social Networking Homework/Assignment should be done in computer notebook.   Printing of assignment is not allowed.    CLASS IX (2025-26) COMPUTER ...