Important Questions and Notes
Ch 11 Queries in Libre Office Base NOTES Important Points Ch 11 Queries in Libre Office Base NOTES Important Points Introduction A database is used to store data in an organized manner. Queries are used to to retrieve the desired data easily and accurately from database. In other words we can say that a query … Read more
IT-402 Ch 10 Working with Multiple Tables Question Answers IT-402 Ch 10 Working with Multiple Tables Question Answers A. Multiple choice questions Q1. Which of the following actions can be performed once the tables are created in a database? (a) Add a field in a table(b) Rename a table(c) Delete a table(d) All of the … Read more
Ch 10 Working with Multiple Tables NOTES Important Points Ch 10 Working with Multiple Tables NOTES Important Points INTRODUCTION After creating the table in database, we may require to edit or delete the table. Sometimes we have to setup the relations between tables to control data redundancy and inconsistency. If you set up relations between … Read more
Ch 9 Starting with Libre Office Base Questions Answers Ch 9 Starting with Libre Office Base Questions Answers A. Multiple choice questions Q1. Which of the following is NOT a type of text data type? (a) Memo(b) Varchar(c) Float(d) Char Q2. A currency data type can only store monetary data that is in dollars. (a) … Read more
Ch 9 Starting with LibreOffice Base Notes Important Points Ch 9 Starting with LibreOffice Base Notes Important Points Introduction LibreOffice Base is a free and open source DBMS. It can be downloaded from www.libreoffice.org. Data which we stored in DBMS can be a text, number, date or in any other form. So, we need to … Read more
Ch 8 Introduction to Database Management System Questions Answers Ch 8 Introduction to Database Management System Questions Answers A. Multiple choice questions Q1. Which of the following can not be considered as an example of a database? (a) Dictionary(b) Telephone directory(c) Marks Register(d) Newspaper Q2. Which of the following is NOT a DBMS? (a) MS … Read more
Ch 7 Share and Review Spreadsheet Question Answers Ch 7 Share and Review Spreadsheet Question Answers A. Multiple choice questions Q1. Sharing allows to edit the Spreadsheet by (a) single user(b) different users simultaneously(c) one by one users(d) one after other users Q2. Sharing spreadsheet feature allows to save the changes in (a) multiple sheets(b) … Read more
Ch 6 Linking Spreadsheet Data Notes Important Points Ch 6 Linking Spreadsheet Data Notes Important Points Introduction When the marks scored by each student in three terminal examinations are stored in three different sheets T1, T2, T3. Now to generate final result in single result sheet by finding the addition of marks of each subject, … Read more
Using Macros in Spreadsheet Question Answers Using Macros in Spreadsheet Question Answers A. Multiple choice questions 1. Macro Recordings can be enabled from the ________________ option in the menu bar. (a) Sheet(b) Data(c) Tools(d) Window. 2. Which of the following is valid Macro Name? (a) 1formatword(b) format word(c) format*word(d) Format_word. 3. Which of the following … Read more
Chapter 4 Analyse data using Scenarios and Goal Seek NOTES Important Points Chapter 4 Analyse data using Scenarios and Goal Seek NOTES Important Points Introduction Data Analysis a is the process to extract useful information for making effective decisions. The spreadsheet is one of the best software used for data analysis. The spreadsheet component in … Read more