ASK IN DETAIL

Unit – 2 Electronic Spreadsheet Advanced Class 10 Q1. What is Data Consolidation? Ans. Data Consolidation allows you to gather your data from separate worksheets into a master worksheet. Q2. Consolidate option available in ___________ menu. Ans. Data Q3. Write two functions which are available in function list of Consolidate data dialog box. Ans. Two functions are : (Write any two) a. Sum b. Max c. Min d. Average Q4. What do you mean by range of cells? Ans. Collection of two or more cells in Excel is called range of cells. for example A1 : A5 Q5. How can you give name to a range of cells? name to a range of cells as follows : Select the range of cells. Click on Data menu —-> Define range Type the name & click OK Q6. What is Subtotal in Spreadsheet? Ans. SUBTOTAL, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows. Q7. Subtotal option available in ___________ menu. Ans. Data Q8. ___________ are a tool to test “what-if” questions. A

UNIT 3: DATABASE MANAGEMENT SYSTEM Q.1 What Do you mean by datasheet view? Ans - It provides a visual way to create a table. It is a simple view which arranges the data in rows and columns and allows to edit the data, but not allows to change the format of the database,  Q.2 What Do you mean by design view? Ans - Design View It allows you to create or change the table. You can set or change every available properties for each field and can open existing tables in Design View, add, remove or change fields  Q.3 Write steps to open table in design view. Ans - 1. Click Table Design on the Ribbon 2. A blank table will appear in Design View. 3. Enter a name for each field down the left column. 4. To set a field as a primary key, right click on the field and select Primary Key. Q. 4 What is the default length of varchar data type? Ans - 50 Q.5 What is a database? Ans - A database is information that is set up for easy access, management and updating. Computer databases ty

Class-10 Basic ICT Skills  Q1. ICT stands for _______________ a. Information and Communication Technology b. Information and Communication Terminology c. Information and Common Technology d. Information to Communication Technology Ans. a. Information and Communication Technology Q2. A computer is an _____________ machine a. mechanical b. electrical c. electronic d. None of the above Ans. c. electronic Q3. ICT refers to all the methods, tools, concepts related to a. storing digital information. b. recording digital information. c. sending digital information. d. All of the above Ans. d. All of the above Q4. Which of the following ways are used to record or store information? a. handwritten on paper b. written using a typewriter c. typed in computer d. All of the above Ans. d. All of the above Q5. Physical part of computer is called ___________ a. Hardware b. Software c. Shareware d. None of the above Ans. a. Hardware Q6. Which of the following is not computer hardware? a. RAM b. Keyboar

database management system CBSE class 10 IT notes  (2MCQ SET & 1 DESCRIPTIVES SET) OBJECTIVE QUESTIONS (SET 01)    1. What is the purpose of a form in a database?  a. Form is systematic way of storing information into the table.  b. Form is used to display information.  c. Both a) and b)  d. None of the above.  Ans: a. Form is systematic way of storing information into the table.    2. Which SQL command will increase the salary of all employees by 5000? (Table name is emp and  column name is salary).  a. UPDATE emp SET sal = salary + 5000;  b. UPDATE SET sal = salary + 5000;  c. UPDATE emp SET salary = 5000;  d. None of the above.  Ans: a. UPDATE emp SET sal = salary + 5000;    3. What is the purpose of the SQL query: “SELECT * FROM Stud ORDER BY Rollno ASC;”?  a. Display all record in ascending order followed by Rollno  b. To display all the records of the table.  c. Both of the above.  d. None of the above.  Ans: a. Display all record in ascending order followed by Rollno    4. W