Tag Archives: Max Ms-Excel 2010

Moving and Copying Max Ms-Excel 2010 – Final

Moving and Copying15

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. …

Read More »

Creating a Form Max Ms-Excel 2010 – 7

Creating a Form45

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 …

Read More »

Pie Charts Max Ms-Excel 2010 – 6

Pie Charts16

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 …

Read More »

Bar chart Max Ms-Excel 2010 – 5

Bar chart17

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 …

Read More »

Functions Max Ms-Excel 2010 – 4

Functions10

*** 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 …

Read More »

Formula Max Ms-Excel 2010 – 2

Selecting Cells to format13

The really good thing about Excel is when you start to use formulae. Using a formula Excel will make calculations for you automatically. To learn how to use formula in Excel, we will do a page of sums. We use these symbols in Excel. +   add –   subtract *   multiply …

Read More »

What is a Spreadsheet? Max Ms-Excel 2010 – 1

What is a Spreadsheet5

**** Open Microsoft Excel Either double click on the short cut which looks like this. Or you can open it from the start button on the bottom left hand side of the screen. **** When you open Excel it will look like this. **** The main area is called the …

Read More »

Powered by moviekillers.com