Coding Avengers

  Answer- Data validation is a feature in MS Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters. Data validation can simply display a message to a user telling them what is allowed.Data validation can also stop invalid user input.In addition, data validation can be used to present the user with a predefined choice in a dropdown menu.

Answer- Conditional formatting means highlighting or emphasizing selected cells on the basis of a criteria or condition. It allows us to set rules on how the cells should be formatted. We can change either the cell color or font color or font style of selected cells on the basis of a condition. We can highlight the cells with a background color to make the data more valuable.

Answer- Following are the two options available in MS Excel for filtering data- (i) Auto Filter ( For simple criteria) (ii) Advanced Filter ( For more complex criteria)

Answer- Adding New  Records Using Form We can add new records in our database using form feature of Ms Excel. To add new records, follow the given steps- Step 1- Select a cell and click on Form button in the Quick Access Toolbar . A dialog box appears on the screen. Step 2- Click on New button to add a new record in our database. Step 3- Here we can type the information for new record. Step 4- Click on Close button to exit from data form. Hence, the new record will be entered in our database.

Answer- In MS Excel filter feature is used to filter out only a desired data from a larger set of data. It will hide all the unwanted data and only the data specified in the filter will be shown. For example - We have a worksheet containing data about employees . Column A contains name and Column B contains Salary. If you want to see how many employees earn less than 10 thousand you can check the values in filter of column B which are less than 10 thousand . The result will be all the employees earning less than 10 thousand.

Answer- Sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize. E.g. Arranging a list on the alphabetical order, arranging your data on in increasing or decreasing order of numeric values.

Answer-  A database is an organized collection of data, so that it can be easily stored, accessed and managed in a computer system. We can organize data into tables, rows, columns, and index it to make it easier to find relevant information.

import javax.swing.*; public class RadioButtonExample { JFrame f; RadioButtonExample() { f=new JFrame(); JRadioButton r1=new JRadioButton("Male"); JRadioButton r2=new JRadioButton("Female"); r1.setBounds(75,50,100,30); r2.setBounds(75,100,100,30); ButtonGroup bg=new ButtonGroup(); bg.add(r1); bg.add(r2); f.add(r1); f.add(r2); f.setSize(300,300); f.setLayout(null); f.setVisible(true); } public static void main(String args[]) { new RadioButtonExample(); } }

Often, a program called "Hello, World!" is used to introduce a new programming language to beginners. A "Hello, World!" is a simple program that outputs "Hello, World!". However, Python is one of the easiest language to learn, and creating "Hello, World!" program is as simple as writing  print("Hello, World!") . So, we are going to write a different program. Program to Add Two Numbers 1 2 3 4 5 # Add two numbers num1 = 3 num2 = 5 sum = num1 + num2 print ( sum ) How this program works? Line 1:  # Add two numbers Any line starting with  #  in Python programming is a comment. Comments are used in programming to describe the purpose of the code. This helps you as well as other programmers to understand the intent of the code. Comments are completely ignored by compilers and interpreters. Line 2:  num1 = 3 Here,  num1  is a var