Page 46 - Computer Genius Class 07
P. 46
exercise
A. Tick ( ) the correct option.
1. Which of the following is called field in a database?
(i) Column (ii) Row
(iii) Cell (iv) Form
2. Which of the following is a window used to display or enter a record in an Excel worksheet?
(i) Row (ii) Form
(iii) Textbox (iv) Column
3. Which of the following options is used to search a record in a form?
i e (ii) Criteria
(iii) Clear (iv) Outline
4. In which tab is the Data Validation command present?
(i) Data (ii) Insert
(iii) Home i one o these
B. Fill in the blanks using the words given below.
conditional ormatting su total record data ase pivot table
1. A set of values for the fields is called a .
2. A contains data in the form of rows and columns.
3. Color Scales is a feature available in .
4. The command allo s you to calculate group ise sum.
5. The eature o cel 2 1 allo s to consolidate summarise and present data.
C. State whether these statements are true or false.
1. Highlight Cells Rules option is selected when you want to highlight all cells
satisfying a given condition.
2. The filters once applied can be easily removed.
3. A form displays only one record at a time.
4. We cannot add records using form.
. e ore using the Su total command data must e sorted in ascending or
descending order.
D. Answer the following questions:
1. What is data validation?
44 Computer Genius-VII

