-
Development in Computer Science chronologically.
Development in Computer Science chronologically. Development In this chapter, we will discuss the development in Computer Science chronologically. The following table lists down the development − Year Development 1959 Transistors: IBM 7090; IBM 1401…
-
Creating Formulas in Excel
Formulas in MS Excel Formulas are the Bread and butter of worksheet. Without formula, worksheet will be just simple tabular representation of data. A formula consists of special code, which is entered into a…
-
Copying Formulas in Excel
Copying Formulas in MS Excel Copying formulas is one of the most common tasks that you do in a typical spreadsheet that relies primarily on formulas. When a formula uses cell references rather than constant…
-
Formula Reference in Excel
Cell References in Formulas Most formulas you create include references to cells or ranges. These references enable your formulas to work dynamically with the data contained in those cells or ranges. For example, if…
-
Built-in Functions in Excel
Built In Functions MS Excel has many built in functions, which we can use in our formula. To see all the functions by category, choose Formulas Tab » Insert Function. Then Insert function Dialog appears from…
-
Data Filtering in Excel
Filters in MS Excel Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.) Using the store data, if you are interested in seeing data…
-
Data Sorting in Excel
Sorting in MS Excel Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or,…
-
Using Ranges in Excel
Ranges in MS Excel A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column…
-
Data Validation in Excel
Data Validation MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular…
-
Using Styles in Excel
Using Styles in MS Excel With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that…