triadakool.blogg.se - Ms excel 2007 tutorial pdf with formulas

#MS EXCEL 2007 TUTORIAL PDF WITH FORMULAS HOW TO#

In this tutorial, the name rate will be given to cell C6 to identify the deduction rate applied to employee salaries. The easiest way to create named ranges is to use the name box located in the top left corner of the worksheet above the row numbers. Named ranges can be used as a substitute for cell reference when used in functions, formulas, and charts. To correct the problem, widen column C using the method described in the preceding step of the tutorial.Ī named range is created when one or more cells are given a name to make the range easier to identify. Data that has been formatted as a specific type of number – such as currency, dates, or time, however, do not spill over to the next cell if they are wider than the cell where they are located. If a row of hashtag symbols appear in cell C2 instead of the date after adding the TODAY function to that cell, it is because the cell is not wide enough to display the formatted data.Īs mentioned previously, unformatted numbers or text data spill over to empty cells to the right if it is too wide for the cell. The current date should be added to cell C2.

Click Done in the box to enter the function and return to the worksheet.

Click on the Today function to bring up the Formula Builder.

Click on the Date & Time option on the ribbon to open the list of date functions.

Click on the Formulas tab of the ribbon.

Click on cell C2 to make it the active cell.

The steps below will add the TODAY function to cell C2 of the worksheet. The TODAY function is also one of Excel's volatile functions, which means it updates itself every time the recalculates – which is usually ever time the worksheet is opened. The TODAY function is easy to use because it has no arguments – which is data that needs to be supplied to the function in order for it to work. Functions are just built-in formulas in Excel to make it easy to complete commonly performed tasks – such as adding the date to a worksheet. Excel has a number of date functions that make it easy to enter the date into a worksheet. It is normal to add the date to a spreadsheet - quite often to indicate when the sheet was last updated. Alternatively, Excel has a feature called merge and center which will be used in a later step to quickly center the title over the data table. Since the worksheet title is so long compared to the other labels in column A, if that column was widened to display the entire title in cell A1, the worksheet would not only look odd, but it would make it difficult to use the worksheet because of the gaps between the labels on the left and the other columns of data.Īs there are no other entries in row 1, it is not incorrect to just leave the title as it – spilling over into the cells to the right.

Widen other columns to show data as needed.

Click and hold down the left mouse button and drag the double-headed arrow to the right to widen column A until the entire entry Thompson A.

The pointer will change to a double-headed arrow.

Place the mouse pointer on the line between columns A and B in the column header.

#MS EXCEL 2007 TUTORIAL PDF WITH FORMULAS HOW TO#

The steps below cover how to widen columns using the mouse. As with all Microsoft programs, there are multiple ways of widening columns. To correct this problem so that the data is fully visible, the columns containing that data need to be widened.

entered into cell A8 are truncated because the cells to the right contain data. Several cells of data entered in the previous step, such as the label Deduction Rate: entered into cell B3 and Thompson A. If the cell to the right contains data, however, the contents of the first cell are truncated to the first eight characters. If the cell or cells to the right are blank, the entered data is displayed in the worksheet, as seen with the worksheet title Deduction Calculations for Employees entered into cell A1. By default, the width of a cell permits only eight characters of any data entry to be displayed before that data spills over into the next cell to the right.