Wednesday , September 20 2017
Home / Tag Archives: Max Ms-Excel 2010

# Tag Archives: Max Ms-Excel 2010

## Moving and Copying Max Ms-Excel 2010 – Final

This is the final tutorial of Max Ms-Excel 2010 Now that we have collected all the data for the group on your data collection Form. You need to enter it onto your Spreadsheet to analyse. *** Open the measurements Spreadsheet and make sure your Fruit and Veg sheet is selected. …

## Creating a Form Max Ms-Excel 2010 – 7

In this chapter you are going to create a form to use to collect data about many different fruits and vegetables are eaten by people in a group. *** Open the Spreadsheet called Measurements created in Chapter 3 and 4.   Naming the worksheets; We are going to rename the …

## Pie Charts Max Ms-Excel 2010 – 6

You are going to draw a pie chart showing the number of different kinds of song birds in just 1996. *** Open the spreadsheet Song Birds. *** Click in cell A5 and drag down to A13. *** Hold down the Ctrl button. *** Click on cell C5 and drag down …

## Bar chart Max Ms-Excel 2010 – 5

Charts are a really good way to present data so that it is easy to understand what it means immediately. *** Open a new spreadsheet workbook. ***  Type the headings and months. *** Position the pointer between the column A and B and drag to the right to make the …

## Functions Max Ms-Excel 2010 – 4

*** Make sure you have the Measurements spreadsheet open you created in the last chapter. The cell highlighted is called B11. You can see the formula in the formula bar =SUM(B4:B10). You are going to try to enter the formula in another way. *** Click in cell B11 *** Press …

## Filtering, sorting, and conditionally formatting data Max Ms-Excel 2010 – 3

Now you are going to find out how to control the way numbers are displayed, and make Excel automatically calculate columns totals. You are going to create a spread to hold data about the height, weight and foot size of people in a group. *** Open a new Excel workbook. …