what is the function of merge and center in excel

Taking a very simple view, Excel is a tool that allows you to enter quantitative data into an electronic spreadsheet to apply one or many mathematical computations. Making Decisions with Excelįollow-along file: Not needed for this skill This chapter provides an overview of the Excel application along with an orientation for accessing the commands and features of an Excel workbook. No matter which career path you choose, you will likely need to use Excel to accomplish your professional objectives, some of which may occur daily. Microsoft Excel is perhaps the most versatile and widely used of all the Office applications. Microsoft® Office contains a variety of tools that help people accomplish many personal and professional objectives.

Become familiar with the features in the Excel Help window.

Save workbooks in the Excel 97-2003 file type.

Become familiar with the commands in the File tab.

Become familiar with the Quick Access Toolbar.

Become familiar with the Excel workbook.

Examine the value of using Excel to make decisions.

See the picture below for the results of the nine INT functions.

If Excel unsuccessfully to convert, it returns a #VALUE! error. As long excel successfully converts it to a number, Excel will round down to the nearest integer number. INT Function #7 – INT Function #9 =INT(A8)Īlthough in excel documentation a “number” argument must be a number, it turns out that if it’s filled with alphanumeric (the number represented as text), it doesn’t matter. Why? The INT function rounds down, if the number is negative, it will become more negative and different from the original number.įor negative numbers, the INT function returns the same integer number as the origin if there are no fractional numbers. INT Function #4 – INT Function #6 =INT(A5)įor negative numbers, no matter the number of fractions, always get an integer number that is different from the origin. INT Function #1 – INT Function #3 =INT(A2)įor a positive number regardless of number, whether there are fractions or not, always return the same integer number as the origin, because the INT function rounds down to the nearest integer number. What is the result if the number in column A is used as a “number” argument of the INT function? For example, there are numbers like the picture below.

What is the function of merge and center in excel