Performing calculation on Data

Performing Calculations on Data

excel 2007 gives you a handy place to store and organize your data. But not just that you can also calculate the data you have in many different ways.

Naming Groups of Data

When you use a large amount it is often useful to identify groups of cells that contain related data. Like you can get a selected group of cell to identify them compared to others. So that range of cells will be easier to find. A way to do that is to select the cells you want to name then in the reference tab click the name from selection and name your cells. Next time you want to go their just look it up in the cell name and you will get their much easier.

Creating Formulas to Calculate Values.

After you write data you can create a formula for the previous data you just wrote. And you can say where do you want your answer. You can do sums averages counts and many more just go to the formula dialog box.

Quiz

Abraham Salazar

1.The simplest way to enter data into a cell is to simply click on a cell and type what you want to put.

2.The purpose of auto fill and fill series is that it makes it easier for you to enter data.

3. The available auto fill options are numbers, days of the week, dates, formulas and text.

4. A pick form drop down list is to format stuff in a spreadsheet.

5. The paste option button appear in the home tab in the clipboard and is to enter data that has already been copied from somewhere else or previous workbooks or work sheets.

6.The way you locate specific data in a spreadsheet is by going to the home tab and on the last group click the find and replace button.

7.It lets you replace anything in the worksheet or workbook.

8.thsarus, checker button, and replace

9. The way you create a data table in a worksheet you fist go to the insert tab then go to the tables and click insert a table.

10.The purpose of a total row in a table is that it calculates the amounts of just tat row.

Working with data and data tables.

Excel allows you to show information in effective way by using graphs charts and others. Excel provides a wide variety of tolls you can use to enter and manage worksheet. like it helps you to put charts r tables so you can easily put your work into to the tables ad lets you analyze the work.

Entering and revising data.

As soonest you create a workbook you can begin to enter data into it one way is to click the cell and type in your work thats when you entering small pieces of data another way is to copy and paste some data that works good when your entering a large amount of data. Excel also helps you enter data according to the pattern that your showing.

Moving Data within a workbook

Their are many ways to move a specific cell in lots of ways, but one of the most direct method is to click the cell to which you want to move. When you click the cell it will be outlined and its contents will appear in the formula bar. Then you can modify the formula by clicking what do you want to do( add, subtract, and other) and then clicking or dragging the cell you want it to take effect on it. You can also make room for a column or rows so you can insert extra data.

Finding and replacing Data

You can have up to one million rows in excel but if you have so much Data it will be to hard to move row by row to find what your looking for. thats why you use the find and replace dialog box that is located in the home tab.

Modifying Worksheets

setting up a workbook

When adding a workbook You first appear with Three worksheets. On a workbook with that you have several options on how do you want to name your worksheets how many you want and more.

Another option you have is when you have a lot of workbooks open you can sort them out so they wont take much space.

You can also modify you your quick access toolbar so you wont have to be looking for commands every little while.ask it will always open with three blank worksheets. And you have to add any style you want.

When you save a work in a different format or over wright the previous one that you had for that workbook.

In a workbook you can click the office button and click the properties and you can look at all the comments tittles keywords and more.

On the custom tab of the advanced properties dialog box. to select of the existing custom category. or create your own like the date numbers and text.

When your doing a lot of records you have you can subdivide by adding more worksheets and to do that just click the worksheet tab on the tab bar ( just below the grid of cells).

A name of a worksheet doesn't always have to be sheet 1 or sheet 2 or so on. You can change the name of a worksheet depending on what you doing or depending on the tittle of the Workbook.

another way to work with ore than one workbook is to copy a worksheet from a workbook to a current one you can copy a worksheet by right clicking it and then it will tell you how you want to copy it or when do you want to move it to.

You can also change the order of the worksheets by clicking and dragging. or if you want one worksheet to out stand from the others you can right click it and change the color or make it 3D so it will out stand.

You can also temporarily delete or hide a worksheet fro a certain amount of time.