Technology-Computer Knowledge

Technology-Computer Knowledge

Introduction

I have go through eight articles which includes the Application of functions in Excel 2010, and use of functions in formula, tabor communications and its classifications, Mathematics of knowledge and search engines: Tutorials, knowledge discovery through different search engines. Famous author Edward Tufte and his contribution to the information technology enhancement is also a part of our discussion. Evaluating interface esthetics regarding the advancements in the computer systems is discussed in the last part.

Discussion

Application of functions in Excel 2010

The most popular application for spread sheet management is run by Microsoft Office Excel. With reference to our text, we will be discussing a detailed job of its new features. These features are explored in Microsoft excel 2010. Formulas and functions strengthen its features. With its extensive features, basic calculations within excel spreadsheet are made easy to perform.

When we talk about applying a simple formula in Microsoft Excel, it's a brease. But when it comes to apply complex formulas it might get complicated. To make things work easier for its customers, Excel has manipulated different functions. These functions are actually the pre-built formulas that make tasks easier to perform. These functions may include: Average, sum count, round, square root of value of two or more numbers stored in a cell. Average and sum among the most common in use. A function mainly uses one or more cell references. We can formulate a value in the form of two digits after decimal places as per our requirement. In order to use a function, click on the cell we need to use a formula. Now by clicking the formula tab, multiple tasks can be performed depending on our use. As financial business values can be formulated by simple use of formula tab. We simply need to select the values stored in the desired cells.

Use of formula in Excel 2010

Excel provides a long list of excel's built-in formulas. Financial, statistics, Engineering, and text are some of the functions designed to execute complex mathematical operations within a second.

Excel also provides facility to formulate sum of two or more cells by simply applying a formula. The formula can be texted as {=SUM(A2:A9)}. This formula will add up all the numeric values of column ”A” from row 2 to row 9 in the respective cell where formula is placed. Thus sum of the all numeric values existing in column A from the row 2 to row 9 is calculated. This formula example refers to Contiguous or adjacent cell ranges. However, noncontiguous cell ranges can also be used as {=SUM(A4,B2,C11)}. These cells may locate at different parts of the Excel spreadsheet. It is necessary to place = sign before starting with a formula. The same practice is repeated while subtraction, multiplication and division. Let say we have to multiply any value stored in a cell with any number. Lets suppose it is =B4*4. B4 represents the numeric value contained in cell lying in column B and at row 4. By simply pressing enter, 4 will be ...