Computer Science
Class-VII
Chapter-5 Using Excel as Database
A. Tick the correct answer:
1. It is a collection of rows and columns.
a. table b. cell c. condition
Answer: Table
2. It is used to apply restriction on entering the type of data.
a. filter b. data validation c. subtotal
Answer: Data validation
3. It is used to arrange the data in ascending and descending order.
a. sort b. filter c. pivot table
Answer: Sort
4. It is used to summarize and analyze the data in a spreadsheet.
a. data validation b. form c. pivot table
Answer: Pivot table
5. It is the collection of information in an organized manner.
a. database b. fielld c. record
Answer: Database
B. Fill in the blanks:
1. To create a table, go to....................>table. (data/insert)
Answer: Insert
2. .................. means to retrieve only those records which satisfy certain given criteria. (filter/sort)
Answer: Filter
3. A column is also called.................... (field/record)
Answer: Field
4. To copy the data, press....................... (ctrl+c/Alt+c)
Answer: Ctrl+C
5. Ctrl+V is used to .......................... the data. (Paste/Cut)
Answer: Paste
C. Write True or False:
1. Using sort option in Excel 2016, data can be arranged in ascending order but not in descending order.
Answer: F
2. Subtotal helps to create an outline of your worksheet.
Answer: T
3. PivotTalbe restricts the entry of data in a cell by allowing only a particular type of data to be entered in a cell.
Answer: F
4. To use subtotal option, the related column must be sorted.
Answer: T
5. The name given to coumn heading is called field name.
Answer: T
D. Fill in the blanks with correct options:
1. .....................>outline group>subtotal
Answer: Data tab
2. Insert>.............................. group>Pivot Table
Answer: Tables
3. ...................... >Windows>freeze panes
Answer: View
4. Data>..................... group>data validation
Answer: Data tools
5. ............................ >sort and filter>Advanced
Answer: Data
E. Short Answer type Questions:
1. What do you understand by Database?
Answer: Database is the collection of information in an organized manner.
2. What are field and field name?
Answer: Field is a column which contains only one type of data.
Field name is the name given to the headings of columns like name, cricket, football etc.
3. What do you mean by record?
Answer: A record is a row that has the entire information about a person or organization.
4. What is the purpose of freeze panes?
Answer: Freeze panes is used to freeze the panes. To freeze panes, which become visible when you scroll the window, select the row or columns which you want to freeze, go to view>windows>freeze panes.
5. Can we freeze the top row?
Answer: We can freeze the rop row. To freeze first row, go to view>windows>freeze top row.
6. What is the purpose of using form?
Answer: A form has a lot of fields where the data is to be entered. As it is an electronic form, we can enter the data, modify it and view one record at a time.
7. Which option is used to arrange data in selected cells?
Answer: Sorting option is used to arrange data in selected cells. Sorting means to arrange data in ascending or descending order so that is becomes easier to work with.
8. Write the use of filter option.
Answer: Filtering data means to retrieve only those records which satify certain given criteria.
9. What rules need to be followed while using advanced filters?
Answer: Advanced filters are used to apply complex criteria to create a list of unique items.
Two rules that should be followed before advanced filter:
a. Header row must have a unique column heading.
b. You cannot have any blank row in data set.
10. What is Pivot Table?
Answer: A Pivot table is amodern tool in excel 2016. It helpful to summarize and analyze the data.
.png)
No comments:
Post a Comment