Coding Avengers

  Answer- Follow the given steps to sort data of a selected range of cells-  Step 1- Open Excel sheet. Step 2- Select the cell range we want to sort. Step 3- Click on Sort button in the Sort & Filter group on Data tab. Step 4-  The Sort  dialog box will appear. Choose the  column  you want to sort by. Step 5- Decide the sorting order (either ascending or descending). Step 6- Once you're satisfied with your selection, click OK. The cell range will be sorted by the selected column.

  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...

Python is case sensitive . Hence a variable with name  codingavengers  is not same as  CodingAvengers For path specification, python uses  forward slashes . Hence if you are working with a file, the default path for the file in case of Windows OS will have backward slashes, which you will have to convert to forward slashes to make them work in your python script. For window's path  C:\folderA\folderB  relative python program path should be  C:/folderA/folderB In python,  there is no command terminator , which means no semicolon  ;  or anything. So if you want to print something as output, all you have to do is: print "Hello, World!" Oops! we just shared the first python program too with you. Yes, just one single statement. In one line only a single executable statement should be written  and the line change act as command terminator in python. To write two separate executable statements in a single line , you should...

1.Simple Elegant Syntax Programming in Python is fun. It's easier to understand and write Python code.  Why? The syntax feels natural. Take this source code for an example: a = 2 b = 3 sum = a + b print(sum) Even if you have never programmed before, you can easily guess that this program adds two numbers and prints it. 2.Not overly strict You don't need to define the type of a variable in Python. Also, it's not necessary to add semicolon at the end of the statement. Python enforces you to follow good practices (like proper indentation). These small things can make learning much easier for beginners. 3.Expressiveness of the language Python allows you to write programs having greater functionality with fewer lines of code.You will be amazed how much you can do with Python once you learn the basics. 4.Great Community and Support Python has a large supporting community. There are numerous active forums online which can be handy if you are stuck. Some of th...

Welcome! This is your first step towards learning Python programming language. Or, Do you know this language already and are here just to revise your concepts?. It doesn't matter which category you belong to because we will be teaching you Python, right from the basics. An experienced programmer might have an advantage of picking up topics and lessons rather quickly, even though we recommend you to not to hurry through the topics, since Python, although being a normal programming language, carries some nice treats for programmers, and you would not want to miss those in the tutorials. For all the noobs out there, there is nothing to worry. You should be happy that you have chosen the most amazing and simple tutorial to learn Python. Why Python? Python is considered as one of the most versatile programming languages. If you have even a little experience in programming, then you will soon notice the difference. Let's take a look at the features of Python. Features o...

You have seen the basic structure of a C program, so it will be easy to understand other basic building blocks of the C programming language. Tokens in C A C program consists of various tokens and a token is either a keyword, an identifier, a constant, a string literal, or a symbol. For example, the following C statement consists of five tokens − printf ( "Hello, World! \n" ); The individual tokens are − printf ( "Hello, World! \n" ) ; Semicolons In a C program, the semicolon is a statement terminator. That is, each individual statement must be ended with a semicolon. It indicates the end of one logical entity. Given below are two different statements − printf ( "Hello, World! \n" ); return 0 ; Comments Comments are like helping text in your C program and they are ignored by the compiler. They start with /* and terminate with the characters */ as shown below − /* my first program in C */ You cannot have comments within comments...